public ArrayList<User> query() throws Exception{ { ArrayList<User> list=new ArrayList<User>(); String sql="select * from users where name like ?"; Connection conn=null; PreparedStatement pstm=null; ResultSet rs=null; try{ conn=DB.getConn();
pstm=(PreparedStatement) conn.prepareStatement(sql); while(rs.next()){ User user = new User(); user.setUsername(rs.getString("1")); user.setPassword(rs.getString("password")); pstm.executeUpdate(); }
public ArrayList<User> query() throws Exception{ { ArrayList<User> list=new ArrayList<User>(); String sql="select * from users where name like ?"; Connection conn=null; PreparedStatement pstm=null; ResultSet rs=null; try{ conn=DB.getConn();
pstm=(PreparedStatement) conn.prepareStatement(sql); while(rs.next()){ User user = new User(); user.setUsername(rs.getString("1")); user.setPassword(rs.getString("password")); pstm.executeUpdate(); }
{
ArrayList<User> list=new ArrayList<User>();
String sql="select * from users where name like ?";
Connection conn=null;
PreparedStatement pstm=null;
ResultSet rs=null;
try{
conn=DB.getConn();
pstm=(PreparedStatement) conn.prepareStatement(sql);
while(rs.next()){
User user = new User();
user.setUsername(rs.getString("1"));
user.setPassword(rs.getString("password"));
pstm.executeUpdate();
}
}catch (SQLException e) {
e.printStackTrace();
}
return list;
}
}
这是我的代码
{
ArrayList<User> list=new ArrayList<User>();
String sql="select * from users where name like ?";
Connection conn=null;
PreparedStatement pstm=null;
ResultSet rs=null;
try{
conn=DB.getConn();
pstm=(PreparedStatement) conn.prepareStatement(sql);
while(rs.next()){
User user = new User();
user.setUsername(rs.getString("1"));
user.setPassword(rs.getString("password"));
pstm.executeUpdate();
}
}catch (SQLException e) {
e.printStackTrace();
}
return list;
}
}
这是我的代码