【javaweb源码】JSP+Servlet+MySQL简单的登录_javaweb+myaql用户登录源代码-CSDN博客

本文链接：https://blog.csdn.net/liuhangbiao/article/details/16833355

JSP+Servlet+MySQL简单的登录

login.jsp
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="http://venusf.blog.163.com/blog/<%=basePath%>">
  </head>
  
  <body>
  
    <form action="LoginServlet" method="post">
     <table border="1" align="center">
      <tr>
       <td colspan="2"><h3 align="center">用户登录</h3></td>
      </tr>
      <tr>
       <td>username:</td>
       <td><input type="text" name="username"/></td>
      </tr>
      <tr>
       <td>password:</td>
       <td><input type="password" name="password"/></td>
      </tr>
      <tr>
       <td align="center" colspan="2"><input type="submit" value="提交"/>  
        <input type="reset" value="重置"/>
       </td>
      </tr>
</table>
    </form>
  </body>
</html>

LoginServelt.java
package com.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;

import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class LoginServlet extends HttpServlet {

 /**
  * Destruction of the servlet. <br>
  */
 
 Connection conn;
 public void destroy() {
  super.destroy(); // Just puts "destroy" string in log
  // Put your code here
 }

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

 public void doPost(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
  
  response.setContentType("text/html");
  request.setCharacterEncoding("UTF-8");
  response.setCharacterEncoding("UTF-8");
  String username = request.getParameter("username");
  String password = request.getParameter("password");
  
  if(conn!=null){
   String sql = " select * from tb_user where username = ? and password = ?";
   try {
    PreparedStatement ps = conn.prepareStatement(sql);
    ps.setString(1, username);
    ps.setString(2, password);
    ResultSet rs = ps.executeQuery();
    if(rs.next()){
//     ServletRequest session = null;;
//     session.getAttribute("username",username);
     PrintWriter out = response.getWriter();
     out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
     out.println("<HTML>");
     out.println("  <HEAD><TITLE>A Servlet</TITLE></HEAD>");
     out.println("  <BODY>");
     out.print("    This is login JSP");
     out.println(username+"登陆成功");
     out.println("  </BODY>");
     out.println("</HTML>");
     out.flush();
     out.close();
     
     
    }
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
  }
  
  
 }

 /**
  * Initialization of the servlet. <br>
  *
  * @throws ServletException if an error occurs
  */
 public void init() throws ServletException {
  super.init();
  try{
   Class.forName("com.mysql.jdbc.Driver");
   String url = "jdbc:mysql://localhost:3306/tb_test";
   conn = DriverManager.getConnection(url, "root", "admin");
   
  }catch(Exception e){
   e.printStackTrace();
   System.out.println("数据库连接失败");
  }
 }

}

在写Servelet的时候，如果简单考虑的话，是写doPost（）还是写doGet（）是没有多大影响的。有两种方法:

1.在jsp页面的提交方法mehtod是等于post还是get，然后写相应的方法

2.如果写了doPost（）方法，可以在doGet（）方法中加上doPost（request，response），反之亦然

在web.xml加上以下代码

<servlet>
    <servlet-name>LoginServlet</servlet-name>
    <servlet-class>com.servlet.LoginServlet</servlet-class>
  </servlet>

<servlet-mapping>
    <servlet-name>LoginServlet</servlet-name>
    <url-pattern>/LoginServlet</url-pattern>
  </servlet-mapping>