jsp mysql_jsp连接MySQL实现登录

packageme.letterwish.servlet;importjava.io.IOException;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importjavax.servlet.http.HttpSession;importcom.mysql.jdbc.Connection;importcom.mysql.jdbc.Statement;/*** Servlet implementation class LoginServlet*/@WebServlet("/LoginServlet")public class LoginServlet extendsHttpServlet {private static final long serialVersionUID = 1L;/***@seeHttpServlet#HttpServlet()*/

publicLoginServlet() {super();//TODO Auto-generated constructor stub

}/***@seeHttpServlet#doGet(HttpServletRequest request, HttpServletResponse

* response)*/

protected voiddoGet(HttpServletRequest request, HttpServletResponse response)throwsServletException, IOException {//TODO Auto-generated method stub

response.getWriter().append("Served at: ").append(request.getContextPath());

}/***@seeHttpServlet#doPost(HttpServletRequest request, HttpServletResponse

* response)*/

protected voiddoPost(HttpServletRequest request, HttpServletResponse response)throwsServletException, IOException {//TODO Auto-generated method stub

response.setContentType("text/html;charset=utf-8");

request.setCharacterEncoding("utf-8");

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

String pwd= request.getParameter("pwd");try{

Class.forName("com.mysql.jdbc.Driver");

}catch(ClassNotFoundException e) {

e.printStackTrace();

System.out.println("找不到驱动 ");

}//连接URL 服务器地址 端口号 数据库名

String url = "jdbc:mysql://120.25.248.101:3306/letterwish";

Connection conn= null;

Statement stmt= null;

ResultSet rs= null;try { //数据可的登录名 登录密码

conn = (Connection) DriverManager.getConnection(url, "root", "root");

stmt=(Statement) conn.createStatement();//SQL语句

String sql = "select * from users where account='" + username + "' and pwd= '" + pwd + "'";

rs= stmt.executeQuery(sql);//返回查询结果

} catch(SQLException e) {

e.printStackTrace();

}

HttpSession session=request.getSession();

session.setAttribute("username", username);try{if(rs.next()) {//如果记录集非空，表明有匹配的用户名和密码，登陆成功

response.sendRedirect("home.jsp");

}else{

session.setAttribute("message", "用户名或密码不匹配。");

System.out.println("XXXXXXXXXX");

}

}catch(SQLException e) {

e.printStackTrace();

}

}

}