package edu.jmi.servlet;
import java.io.IOException;
import java.sql.Connection;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import edu.jmi.dao.UserDao;
import edu.jmi.model.User;
/**
-
Servlet implementation class Update
*/
public class Update extends HttpServlet {
private static final long serialVersionUID = 1L;/**
- @see HttpServlet#HttpServlet() */ public Update() { super(); // TODO Auto-generated constructor stub }
/**
- @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub }
/**
- @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
System.out.println("update called");
Connection conn=null;
HttpSession session=request.getSession();
request.setCharacterEncoding("utf-8");
//2获取参数
String str=request.getParameter("empno");
System.out.println(str);
UserDao ud=new UserDao();
User user=new User();
user.setEmpno(str);
boolean res=ud.isUserExist(user); if(res){ session.setAttribute("msg1",res.getString(1)); session.setAttribute("msg2",res.getString(2)); session.setAttribute("msg3",res.getString(3)); session.setAttribute("msg4",res.getString(4)); session.setAttribute("msg5",res.getString(5)); session.setAttribute("msg6",res.getString(6)); session.setAttribute("empno", str); response.sendRedirect("update2.jsp"); }else{ session.setAttribute("errmsg", "用户名不存在"); response.sendRedirect("update.jsp"); } }
}
public boolean isUserExist(User user){
boolean bres=false;
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
try{
//获取数据库链接
System.out.println("start to do");
conn=DB.getConnection();
String sql="select * from emp where empno=?";
ps=conn.prepareStatement(sql);
ps.setString(1, user.getEmpno());
rs=ps.executeQuery();
bres=rs.next();
}catch(Exception e){
System.out.print(e);
}finally{
DB.close(rs, ps, conn);
}
System.out.println(bres);
return bres;
}
MVC模式写查询
session.setAttribute("msg1",res.getString(1));
session.setAttribute("msg2",res.getString(2));
session.setAttribute("msg3",res.getString(3));
session.setAttribute("msg4",res.getString(4));
session.setAttribute("msg5",res.getString(5));
session.setAttribute("msg6",res.getString(6));
把获取的值传到value里,res.getString(1)出错
错误提示Cannot invoke getString(int) on the primitive type boolean
