20170705

最新推荐文章于 2021-06-20 20:55:23 发布

噢灬燧先生

最新推荐文章于 2021-06-20 20:55:23 发布

阅读量170

点赞数 1

分类专栏： myeclipse 文章标签： myeclipse

本文链接：https://blog.csdn.net/qq_36066923/article/details/74457009

版权

myeclipse 专栏收录该内容

21 篇文章 0 订阅

订阅专栏

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String username=request.getParameter("username");
String password=request.getParameter("password");
Map<String,String> map=new HashMap<String, String>();
map.put("username", username);
map.put("password", password);

User user=UserDao.getInstance().getUserByMap(map);
request.setAttribute("username", username);
if (user!=null) {
request.getRequestDispatcher("/success.jsp").forward(request, response);
return;
} else {
request.getRequestDispatcher("/fail.jsp").forward(request, response);
return;
}

}

<body>
<a>${username} shibai</a>
</body>

<servlet-mapping>
<servlet-name>Firstservlet</servlet-name>
<url-pattern>/Firstservlet</url-pattern>
</servlet-mapping>
<servlet-mapping>
<servlet-name>Secencd</servlet-name>
<url-pattern>/Secencd</url-pattern>
</servlet-mapping>

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);

}

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.sendRedirect("/20170705/fail.jsp");
return;

}

以user为对象写添加 ::::::::::::::::::::::::::::::

public User getUserByMap(Map<String, String> map){
User user = null;

Connection conn = null;
PreparedStatement ps = null;

ResultSet rs = null;
String sql = "select * from jdbc where username = ? and password = ?";
try {
conn = DBconnectionUitl.getConnection();
ps = conn.prepareStatement(sql);
ps.setString(1, map.get("username"));
ps.setString(2, map.get("password"));

rs = ps.executeQuery();
while(rs.next()){
user = new User();
user.setUserId(rs.getInt("userId"));
user.setUsername(rs.getString("username"));
user.setSex(rs.getInt("sex"));
user.setPassword(rs.getString("password"));
user.setFlag(rs.getInt("flag"));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBconnectionUitl.closeAll(rs, ps, conn);
}
return user;
}
public User getUserByUsername(String username){
User user=null;

Connection conn = null;
PreparedStatement ps = null;

ResultSet rs = null;
String sql = "select * from jdbc where username = ?";
try {
conn = DBconnectionUitl.getConnection();
ps = conn.prepareStatement(sql);
ps.setString(1, username);

rs = ps.executeQuery();
while(rs.next()){
user = new User();
user.setUserId(rs.getInt("userId"));
user.setUsername(rs.getString("username"));
user.setSex(rs.getInt("sex"));
user.setPassword(rs.getString("password"));
user.setFlag(rs.getInt("flag"));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBconnectionUitl.closeAll(rs, ps, conn);
}
return user;

}