📄 loginservlet.java
字号:
package servlet;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import dbconn.*;
import java.sql.*;
public class LoginServlet extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";
//Initialize global variables
public void init() throws ServletException {
}
//Process the HTTP Get request
public void doGet(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
HttpSession session = request.getSession();
String userName = request.getParameter("userName");
String userPass = request.getParameter("userPass");
if((userName==null)||(userPass==null)){
response.sendRedirect("admin/error.jsp");
}
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
con = Dbcon.getCon();
try{
String sql = "select * from userTbl where userName=? and userPass=?";
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
if(rs.next()){
session.setAttribute("userName",userName);
response.sendRedirect("admin/index.jsp");
}else{
response.sendRedirect("admin/error.jsp");
}
}catch(Exception err){
System.err.println(err.getMessage().toString());
response.sendRedirect("admin/error.jsp");
}
out.close();
}
//Process the HTTP Post request
public void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
doGet(request, response);
}
//Clean up resources
public void destroy() {
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -