一个重要的笔试问题。。在线求答。。
南瓜三三 2010-11-18 04:41:25 在daoimpl包中的
//查找 id
public Hashtable findByID(int id) {
Hashtable Map_users= new Hashtable();
int p=0;
PreparedStatement pstmt = null;
ResultSet rs = null;
Dbutil Dbutil = null;
String sql = "select * from user where id=?";
try {
pstmt = Dbutil.getConn().prepareStatement(sql);
pstmt.setInt(1, id);
rs=pstmt.executeQuery();
while(rs.next()){
user u=new user();
u.setId(rs.getInt("id"));
u.setName(rs.getString("name"));
u.setPassword(rs.getString("password"));
u.setStatus(rs.getInt("status"));
Map_users.put(p, u);
p++;
}
}catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return Map_users;
}
在servlet中写的
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String id = request.getParameter("id");
userDao userDao =new userDaoImpl();
user u=new user();
//怎么在hashTable 把值取出来啊,,,求高手附码
request.getRequestDispatcher("/show.jsp").forward(request, response);
}