1.创建项目结构
2.在util包中编写连接数据库的工具类
package com.cyh.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JDBCUtil {
private static String driver="com.mysql.cj.jdbc.Driver";
private static String url="jdbc:mysql://localhost:3306/mydb";
private static String name="root";
private static String pwd="123";
private static Connection conn=null;
public static Connection getConn() {
//1.导入链接MySQL的驱动包
try {
//2.ͨ通过反射加载驱动包
Class.forName(driver);
//3.ͨ通过驱动管理器获取数据库的链接
conn=DriverMa