List list=runner.query(conn, orcif, newBeanListHandler<Order>(Order.class),id);
示例
@Override public List orconfig(int id)throws SQLException { // TODO Auto-generated method stub String orcif="select * from easybuy_order where EO_ID=?"; Connection conn=JDBCTool.openconn(); List list=runner.query(conn, orcif, newBeanListHandler<Order>(Order.class),id); conn.close(); return list; }
如果您需要执行模糊查询,例如根据关键字搜索文本字段,则可以使用 LIKE 运算符。以下是一个示例代码片段,演示如何使用带参数的 LIKE 查询获取某个数据表中包含指定关键字的行:
List list=runner.query(conn, orcif, newBeanListHandler<Order>(Order.class),id);
示例
@Override public List sornam(int page,String name)throws SQLException { // TODO Auto-generated method stub int n=(page-1)*5; String sna="select * from easybuy_order where EO_USER_NAME like ? limit ?,5"; String ona="%"+name+"%"; Connection conn=JDBCTool.openconn(); List list=runner.query(conn, sna, newBeanListHandler<Order>(Order.class),ona,n); conn.close(); return list; }
在这个例子中,我们使用 % 通配符匹配任意字符,并将 LIKE 查询参数作为 Object[] 传递给 query() 方法。
不带参数返回list
list = runn.query(conn, sql, newBeanListHandler<ProductCategory>(ProductCategory.class));
示例
@Override public List query() { // TODO Auto-generated method stub Connectionconn= JDBCTool.openconn(); Stringsql="select * from easybuy_product_category;"; Listlist=null; try { list = runn.query(conn, sql, newBeanListHandler<ProductCategory>(ProductCategory.class)); conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; }
登入
@Override public User login(String name, String pass)throws SQLException { // TODO Auto-generated method stub String selo="select * from easybuy_user where EU_USER_Account=? and EU_PASSWORD=?"; Connection conn=JDBCTool.openconn(); User us=runner.query(conn, selo, newBeanHandler<User>(User.class),name,pass); conn.close(); return us; }