HTML+Servlet+JDBC

1.添加pom坐标如果复制点击下载

<!-- MySQL -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.30</version>
    </dependency>

点开pom文件,将上述代码复制入内,点击右边的下载

 2.java创建一个包,然后写BaseDAO类,

package utils;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class BaseDAO {
	private String url = "jdbc:mysql://192.168.2.19:3306/crm?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai";

	private String user = "";

	private String password = "";

	private String className = "com.mysql.cj.jdbc.Driver";
	private Connection connection;
	private PreparedStatement pst;
	private ResultSet rs;

	public Connection getConnection() {
		if (connection == null) {
			try {
				Class.forName(className);
				connection = DriverManager.getConnection(url, user, password);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return connection;

	}

	public PreparedStatement getPreparedStatement(String sql) {
		if (pst == null) {
			try {
				pst = getConnection().prepareStatement(sql);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return pst;
	}

	public int executeUpdate(String sql) {
		int count = 0;
		try {
			count = getPreparedStatement(sql).executeUpdate();
		} catch (Exception e) {
			// TODO: handle exception
		} finally {
			closeAll();
		}
		return count;
	}

	public ResultSet executeQuery(String sql) {
		try {
			rs = getPreparedStatement(sql).executeQuery();
		} catch (Exception e) {
			// TODO: handle exception
		}
		return rs;
	}

	public void closeAll() {
		try {
			if (rs != null) {
				rs.close();
				rs = null;
			}
			if (pst != null) {
				pst.close();
				pst = null;
			}
			if (connection != null) {
				connection.close();
				connection = null;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}

此处的user和

 

 com.mysql.cj.jdbc.Driver

 上面那行代码是固定代码,注意运行项目时一定要把数据库打开

以上就是全过程了(Win11用户系统自带防护可能会误删Tomcat,所以需要自备防护软件,运行报异常,解决方法需要重新安装Tomcat)