java数据库操作框架有哪些_Java原生操作数据库（不使用框架）

https://mvnrepository.com/artifact/mysql/mysql-connector-java-->

mysql

mysql-connector-java

6.0.6

2.创建数据库连接类DBUtil.java用以连接与关闭数据库

//文件名：DBUtil.java

importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;public classDBUtil {static String user = "root";static String password = "root";static String url = "jdbc:mysql://localhost【数据库地址】:3306【端口】/【数据库名称】?serverTimezone=UTC";static{try{

Class.forName("com.mysql.cj.jdbc.Driver");

}catch(ClassNotFoundException e) {

e.printStackTrace();

}

}public staticConnection getConnection() {

Connection conn= null;try{

conn=DriverManager.getConnection(url, user, password);

}catch(SQLException e) {

e.printStackTrace();

}returnconn;

}public static voidcloseJDBC(ResultSet rs, Statement stmt, Connection conn) {if (rs != null) {try{

rs.close();

}catch(SQLException e) {

e.printStackTrace();

}

}if (stmt != null) {try{

stmt.close();

}catch(SQLException e) {

e.printStackTrace();

}

}if (conn != null) {try{

conn.close();

}catch(SQLException e) {

e.printStackTrace();

}

}

}

}

3.在java代码中对表进行操作

3.1 查，删，改类似

//查找table表重的 id和name

String sql = "select id,name from table";

Connection conn=DBUtil.getConnection();

PreparedStatement pstmt= null;try{

conn.setAutoCommit(false);

pstmt=conn.prepareStatement(sql);

ResultSet rs=pstmt.executeQuery();

json=ResultSetToJson.ResultSetToJsonArray(rs);

}catch(SQLException e){try{

conn.rollback();

}catch(SQLException e1){

e1.printStackTrace();

}

}finally{

DBUtil.closeJDBC(null, pstmt, conn);

}return json;

3.1 增

int basicinfoID = 0;

String sql= "INSERT INTO tb_resume_basicinfo("

+ "basicinfo_id, realname, gender, birthday, current_loc, "

+ "resident_loc, telephone, email, job_intension, job_experience, head_shot,applicant_id) "

+"VALUES(SEQ_ITOFFER_RESUMEBASICINFO.NEXTVAL,?,?,?,?,?,?,?,?,?,?,?)";

Connection conn=DBUtil.getConnection();

PreparedStatement pstmt= null;try{//关闭自动提交

conn.setAutoCommit(false);

pstmt=conn.prepareStatement(sql);

pstmt.setString(1, basicinfo.getRealName());

pstmt.setString(2, basicinfo.getGender());

pstmt.setTimestamp(3, basicinfo.getBirthday() == null ? null:newTimestamp(basicinfo.getBirthday().getTime()));

pstmt.setString(4, basicinfo.getCurrentLoc());

pstmt.setString(5, basicinfo.getResidentLoc());

pstmt.setString(6, basicinfo.getTelephone());

pstmt.setString(7, basicinfo.getEmail());

pstmt.setString(8, basicinfo.getJobIntension());

pstmt.setString(9, basicinfo.getJobExperience());

pstmt.setString(10, basicinfo.getHeadShot());

pstmt.setInt(11, applicantID);

pstmt.executeUpdate();

}catch(SQLException e) {try{//事务回滚

conn.rollback();

}catch(SQLException e1) {

e1.printStackTrace();

}

e.printStackTrace();

}finally{

DBUtil.closeJDBC(null, pstmt, conn);

}

Java原生操作数据库(不使用框架)

标签：工程   trace   ble   turn   array   sid   als   ima   off

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：https://www.cnblogs.com/zhouheblog/p/11044375.html