50,528
社区成员
发帖
与我相关
我的任务
分享
String str="select *from user where username=?";
String sql3 = str;//SQL语句
db1 = new DBHelper(sql3);//创建DBHelper对象
db1.pst.setString(1, test);
ResultSet rs = db1.pst.executeQuery(sql3);//
ResultSet rs = db1.pst.executeQuery();//
public void chaxun(){
try {
String str="select * from user where username= ?";
String sql3 = str;//SQL语句
db1 = new DBHelper(sql3);//创建DBHelper对象
db1.pst.setString(1, "12333");
ResultSet rs = db1.pst.executeQuery();//
while (rs.next()) {
String uid = rs.getString(1);
String ufname = rs.getString(2);
String ulname = rs.getString(3);
System.out.println(uid + "\t" + ufname + "\t" + ulname + "\t" );
}//显示数据
} catch (SQLException e) {
e.printStackTrace();
}
}