没什么技术含量,但很简短,在做其他项目时,用到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));
}
}
}