java登录跳转_JAVAWEB登陆跳转后台

该博客介绍了如何使用Java实现Web应用的登录验证功能,通过DAO层查询数据库比对用户输入的ID和密码,如果匹配成功则跳转到成功页面,否则跳转到失败页面。涉及关键类包括UserDao、User和AddServlet,以及数据库连接工具DBUtil。
摘要由CSDN通过智能技术生成

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("涓嶇┖");

}

}

}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值