packagedao;importjava.sql.Connection;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importentry.user;importutil.DBUtil;
@SuppressWarnings("unused")public classuserDao {//
public static booleanid(String id,String pwd) {boolean f = false;
String sql= "select * from user3 where id = '" + id + "' and password = '"+pwd+"'";// Connection conn =DBUtil.getConn();
Statement state= null;
ResultSet rs= null;try{
state=conn.createStatement();
rs=state.executeQuery(sql);if(rs.next()) {
f= true;
}
}catch(SQLException e) {
e.printStackTrace();
}finally{
DBUtil.close(rs, state, conn);
}returnf;
}
}packageentry;public classuser {privateString id;privateString password;publicString getId() {returnid;
}public voidsetId(String id) {this.id =id;
}publicString getPassword() {returnpassword;
}public voidsetPassword(String password) {this.password =password;
}publicuser(){}publicuser( String password) {this.password =password;
};publicuser(String id, String password) {super();this.id =id;this.password =password;
}
}packageservlet;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importdao.userDao;/*** Servlet implementation class AddServlet*/@WebServlet("/AddServlet")public class AddServlet extendsHttpServlet {private static final long serialVersionUID = 1L;/***@seeHttpServlet#HttpServlet()*/
protected void service(HttpServletRequest request, HttpServletResponse response) throwsServletException, IOException {
request.setCharacterEncoding("utf-8");//鑾峰彇鏁版嵁
String id = request.getParameter("id");
String password= request.getParameter("password");
System.out.println(id);
System.out.println(password);if(userDao.id(id,password)) {
request.setAttribute("message", "登录成功");
request.getRequestDispatcher("chenggong.jsp").forward(request,response);
}else{
request.setAttribute("message", "登录失败");
request.getRequestDispatcher("houtai.jsp").forward(request,response);
}
}protected void doPost(HttpServletRequest request, HttpServletResponse response) throwsServletException, IOException {
doGet(request, response);
}/***@seeHttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)*/
protected void doGet(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)*/}packageutil;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;/** 鏁版嵁搴撹繛鎺ュ伐鍏�*/
public classDBUtil {public static String db_url = "jdbc:mysql://localhost:3306/user?useSSL=false";public static String db_user = "root";public static String db_pass = "root";public staticConnection getConn () {
Connection conn= null;try{
Class.forName("com.mysql.jdbc.Driver");//鍔犺浇椹卞姩
conn =DriverManager.getConnection(db_url, db_user, db_pass);
}catch(Exception e) {
e.printStackTrace();
}returnconn;
}/*10鍏抽棴杩炴帴*/
public static voidclose (Statement state, Connection conn) {if (state != null) {try{
state.close();
}catch(SQLException e) {
e.printStackTrace();
}
}if (conn != null) {try{
conn.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
}public static voidclose (ResultSet rs, Statement state, Connection conn) {if (rs != null) {try{
rs.close();
}catch(SQLException e) {
e.printStackTrace();
}
}if (state != null) {try{
state.close();
}catch(SQLException e) {
e.printStackTrace();
}
}if (conn != null) {try{
conn.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
}public static void main(String[] args) throwsSQLException {
Connection conn=getConn();
PreparedStatement pstmt= null;
ResultSet rs= null;
String sql="select * from user";
pstmt=conn.prepareStatement(sql);
rs=pstmt.executeQuery();if(rs.next()){
System.out.println("绌�");
}else{
System.out.println("涓嶇┖");
}
}
}