tomcat servlet mysql_Servlet+Mysql+tomcat实现登录操作

1.首先，建立一个Web项目

2.导入mysql驱动包

3.创建数据库工具类ConnectionManage

package com.servlet;

import java.sql.*;

public class ConnectionManage {

//定义数据库驱动字符串

private static final String Driver_CLASS="com.mysql.jdbc.Driver";

//定义数据库连接字符串

private static final String DATABASE_URL="jdbc:mysql://localhost:3306/manage";

//登录数据库用户名

private static final String DATABASE_USER="root";

//登录数据库密码

private static final String DATABASE_PASSWORD="123";

public static Connection getConnection(){

Connection dbConnection=null;

try {

Class.forName(Driver_CLASS);

dbConnection=DriverManager.getConnection(DATABASE_URL,

DATABASE_USER,DATABASE_PASSWORD);

} catch (Exception e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

return dbConnection;

}

public static void closeConnection(Connection con){

try {

con.close();

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

}

public static void closeStatement(Statement st){

try {

st.close();

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

}

public static void closeResultSet(ResultSet rs){

try {

rs.close();

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

}

public static void main(String[] args) {

System.out.println(getConnection());

}

}

4.创建处理登录请求servlet LoginServlet

package com.servlet;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class LoginServlet extends HttpServlet {

private Connection con=null;

private PreparedStatement pstmt=null;

private ResultSet rs;

public LoginServlet() {

super();

}

public void destroy() {

super.destroy(); // Just puts "destroy" string in log

// Put your code here

}

public void doDelete(HttpServletRequest request,

HttpServletResponse response) throws ServletException, IOException {

// Put your code here

}

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

response.setContentType("text/html");

PrintWriter out = response.getWriter();

out.println(""-//W3C//DTD HTML 4.01 Transitional//EN\">");

out.println("");

out.println("

A Servlet");

out.println("

");

out.print(" This is ");

out.print(this.getClass());

out.println(", using the GET method");

out.println(" ");

out.println("");

out.flush();

out.close();

}

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

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

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

try {

String sql="SELECT * FROM admin WHERE username=? and password=?";

con=ConnectionManage.getConnection();

pstmt=con.prepareStatement(sql);

pstmt.setString(1, username);

pstmt.setString(2,password);

rs=pstmt.executeQuery();

if(rs.next()){

request.getRequestDispatcher("/success.jsp").forward(request, response);

}else{

request.getRequestDispatcher("/index.jsp").forward(request, response);

}

} catch (SQLException e) {

// TODO 自动生成的 catch 块

e.printStackTrace();

}

}

public void init() throws ServletException {

// Put your code here

}

}

5.自动生成web.xml获取URL地址

xmlns="http://java.sun.com/xml/ns/javaee"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd">

This is the description of my J2EE component

This is the display name of my J2EE component

LoginServlet

com.servlet.LoginServlet

LoginServlet

/loginservlet

6.创建登录界面

管理员登录

用户名

密码