Jdbc连接数据库、封装通用增删改查

Jdbc连接数据库、封装通用增删改查

需要mysql-connector-java-5.1.45.jar驱动连接

<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.45</version>
        </dependency>

通用增删改查DBUtil访问数据库代码

public class DBUtil {
    private static String DRIVER = "com.mysql.jdbc.Driver";
    private static String USER = "root";
    private static String PWD = "password";
    private static String URL = "jdbc:mysql://localhost:3306/test";
    private static PreparedStatement pstmt = null;
    private static Connection connection = null;
    private static ResultSet rs = null;

	//获取连接
    public stati