JDBC模板

没什么技术含量，但很简短,在做其他项目时，用到JDBC操作，就直接复制这个代码，然后在依赖加上java连接对应版本数据库的jar包,就可以用了。

package test;

import java.sql.*;

public class JDBC {
    private Connection conn;

    public JDBC(String url, String user, String pass){
        try {
            Class.forName("com.mysql.jdbc.Driver");

            conn = DriverManager.getConnection(url,user,pass);
        } catch (SQLException | ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    public ResultSet Query(String sql) throws SQLException {
        PreparedStatement preparedStatement = conn.prepareStatement(sql);
        return preparedStatement.executeQuery();
    }

    public int update(String sql) throws SQLException {
        PreparedStatement preparedStatement = conn.prepareStatement(sql);
        return preparedStatement.executeUpdate();
    }
}

测试代码

package test;

import java.sql.*;


public class testJDBC {

    public static void main(String[] args) throws SQLException {
        String url="jdbc:mysql://localhost:3306/mydatabase?"+ "useUnicode=true&characterEncoding=UTF8";//防止乱码
        String user="root";
        String pass="123456";
        JDBC jdbc = new JDBC(url,user,pass);

        String insertsql = "insert into studentlist(id, name, password, sex) VALUES (3,'小帅',654321,'男')";
        System.out.println(jdbc.update(insertsql));
        String deletesql = "delete from studentlist where id = 3";
        System.out.println(jdbc.update(deletesql));
        String updatesql = "update studentlist set name = '李四' where id = 2";
        System.out.println(jdbc.update(updatesql));
        String querysql = "select * from studentlist";
        ResultSet resultSet = jdbc.Query(querysql);
        while (resultSet.next())
        {
            System.out.println(resultSet.getString(1)+resultSet.getString(2)+resultSet.getString(3)+resultSet.getString(4));
        }
    }

}