jsp新代码第95课

最新推荐文章于 2022-09-20 17:42:20 发布

虾米大王

最新推荐文章于 2022-09-20 17:42:20 发布

阅读量273

点赞数

分类专栏： Java

本文链接：https://blog.csdn.net/modern358/article/details/123162754

版权

Java Servlet MySQL 用户验证 PreparedStatement HTTP请求

关键词由CSDN通过智能技术生成

Java 专栏收录该内容

1301 篇文章 5 订阅

订阅专栏

new95.java

package pack01;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class new95 
 */
@WebServlet(name="new95",urlPatterns = "/page01/pack01.new95")
public class new95 extends HttpServlet 
{
	private static final long serialVersionUID = 1L;
       
  
    public new95() 
    {
        super();
         
    }

 
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
	{
		String driverName = "com.mysql.jdbc.Driver";
		String user = "root";
		String pwd = "mysql123";
		String dbName = "test";
		String url = "jdbc:mysql://localhost:3306/" + dbName + "?&useUnicode=true&characterEncoding=utf-8";
		request.setCharacterEncoding("utf-8");
		
		String uName = request.getParameter("userName");
		String uPwd = request.getParameter("userPwd");
		RequestDispatcher dis = null;
		try
		{
			Class.forName(driverName);
			Connection conn = DriverManager.getConnection(url,user,pwd);
			String sql = "select * from user_b where uname=? and upassword=?";
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, uName);
			pstmt.setString(2, uPwd);
			ResultSet rs = pstmt.executeQuery();
			if(rs.next())
			{
				if(rs != null) rs.close();
				if(pstmt != null) pstmt.close();
				if(conn != null) conn.close();
				dis = request.getRequestDispatcher("new96.jsp");
				dis.forward(request, response);
			}
			else 
			{
				if(rs != null) rs.close();
				if(pstmt != null) pstmt.close();
				if(conn != null) conn.close();
				dis = request.getRequestDispatcher("new97.jsp");
				dis.forward(request, response);
			}
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
		 
	}

 
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
	{
 
		doGet(request, response);
	}

}