queryrunner用法

声明：

public class DbHelper {

public static QueryRunner getQueryRunner() {

 

DataSource ds = null;

 

try {

 

Context context = new InitialContext();

ds = (DataSource) context.lookup("java:/comp/env/jdbc/mysqlds");

} catch (NamingException e) {

System.out.println("出错");

}

QueryRunner qr = new QueryRunner(ds);

return qr;

 

}

}

 

实例一：

String sql = "update users set password=? where id=?";

String params[] = { newPassword, user.getId().toString() };

QueryRunner qr = DbHelper.getQueryRunner();

try {

qr.update(sql, params);

} catch (SQLException e) {

e.printStackTrace();

}

实例二：

String sql = "select * from users where username=? and password=?";

String params[] = { username, password };

Users user = null;

List list = null;

QueryRunner qr = DbHelper.getQueryRunner();

try {

list = (List) qr.query(sql, params, new BeanListHandler(Users.class));

} catch (SQLException e) {

e.printStackTrace();

}