java数据库 java数据库 java数据库

package test; import java.sql.DriverManager; import java.sql.SQLException; import com.mysql.jdbc.Connection; import com.mysql.jdbc.PreparedStatement; public class DB { //创建数据库连接类。 private String dbUrl="jdbc:mysql://localhost:3306/student?useUnicode=true&characterEncoding=utf-8"; private String dbUser="root"; private String dbPwd="123"; private Connection conn=null; private PreparedStatement stmt=null; public DB() { try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { e.printStackTrace(); } } public Connection getConn() //获取数据库的连接对象。 { try { conn=(Connection) DriverManager.getConnection(dbUrl, dbUser, dbPwd); } catch (SQLException e) { e.printStackTrace(); } return conn; } public boolean addStudent(studentBean sb){ //添加学生信息的方法。 String sno=sb.getSno(); String sname=sb.getSname(); try { conn=this.getConn(); conn.setAutoCommit(false); stmt=(PreparedStatement) conn.prepareStatement("INSERT INTO studentinfor(sno,sname) VALUES (?,?)"); stmt.setString(1,sno); stmt.setString(2,sname); stmt.execute(); conn.commit(); return true; } catch (SQLException e) { e.printStackTrace(); try { conn.rollback(); } catch (SQLException e1) { e1.printStackTrace(); } }finally{ try { conn.close(); stmt.close(); } catch (SQLException e) { e.printStackTrace(); } } return false; } }