做练习的Jsp 连接 MySql 小实例

public class LoginServlet extends HttpServlet {


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

doPost(request, response);

}


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

String name = request.getParameter("username");

String passwd=request.getParameter("passwd");

boolean correctTF = false;

String DriverName = "com.mysql.jdbc.Driver";

String DBuser = "root";

String DBpasswd = "root";

String DBUrl = "jdbc:mysql://localhost:3306/appuser";

try {

// 加载驱动

Class.forName(DriverName);

// 创建与数据库链接

Connection conn = (Connection) DriverManager.getConnection(DBUrl,DBuser, DBpasswd);

// 创建语句对象

Statement stmt = (Statement) conn.createStatement();

// 创建SQL查询

String sql = "select * from `user` WHERE username='" + name + "' and `password`='"+passwd+"' ";

// 执行语句

ResultSet rs = stmt.executeQuery(sql);

if (rs.next()) {

correctTF = true;

//设置Session

HttpSession session=request.getSession();

session.setAttribute("User", name);

rs.close();

stmt.close();

conn.close();

} else {

correctTF = false;

rs.close();

stmt.close();

conn.close();

}// 没有记录关闭链接

} catch (Exception e) {

e.printStackTrace();

}

if (correctTF == true) {

RequestDispatcher reqD = request.getRequestDispatcher("Index.jsp");

reqD.forward(request, response);

} else {

response.sendRedirect("LoginError.jsp");

}

}

}