純java方式串連資料庫簡單操作

標籤：ext   ast   exec   ati   java資料庫連接   rman   static   純java   exe   

//JDBC全稱java datebese connection --java資料庫連接

package com.beiwo;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ResourceBundle;/*資料庫協助類*/public class DBUtils {   private static String driverClass;   private static String url;   private static String user;   private static String password;static{ResourceBundle rb=ResourceBundle.getBundle("jdbc");driverClass=rb.getString("driverClass");url=rb.getString("url");user=rb.getString("user");password=rb.getString("password");try {//載入驅動Class.forName(driverClass);} catch (Exception e) {   e.printStackTrace();}}public static Connection getConn() throws SQLException{return DriverManager.getConnection(url, user, password);}public static void closeAll(ResultSet rs,Statement stme,Connection conn){if (null!=rs) {try {rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}if (null!=rs) {try {stme.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}if (null!=rs) {try {conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}

package com.beiwo;import java.sql.Connection;import java.sql.ResultSet;import java.sql.Statement;public class MasterCurd {public static void findAll(){Connection conn=null;      Statement stme=null;      ResultSet rs=null;      String sql="SELECT * FROM master";  //載入驅動try {//Class.forName("com.mysql.jdbc.Driver");System.out.println("載入成功");conn=DBUtils.getConn();stme= conn.createStatement();rs= stme.executeQuery(sql);while (rs.next()) {System.out.println(rs.getObject(1));System.out.println(rs.getObject(2));System.out.println(rs.getObject(3));System.out.println(rs.getObject(4));System.out.println("=============================");}} catch (Exception e) {}finally{DBUtils.closeAll(rs, stme, conn);}}//插入public static void Insert (){    Connection conn=null;    Statement stme=null;  String sql="INSERT INTO master (name, password, money) VALUES (‘張政‘,‘123‘, 100)";   try {//獲得連線物件conn= DBUtils.getConn();System.out.println("串連成功"); //擷取Statement對象stme=conn.createStatement();//執行語句stme.execute(sql);} catch (Exception e) {e.printStackTrace();}finally{DBUtils.closeAll(null, stme, conn);}}//更新public static void Update(){    Connection conn=null;    Statement stme=null;    String sql="UPDATE master SET name=‘張軍‘,money=50 WHERE id=6";   try {//獲得連線物件conn= DBUtils.getConn();System.out.println("串連成功"); //擷取Statement對象stme=conn.createStatement();//執行語句stme.executeUpdate(sql);} catch (Exception e) {e.printStackTrace();}finally{DBUtils.closeAll(null, stme, conn);}}//刪除public static void Delete(){    Connection conn=null;    Statement stme=null;    String sql="DELETE FROM master WHERE id=7";   try {//獲得連線物件conn= DBUtils.getConn();System.out.println("串連成功"); //擷取Statement對象stme=conn.createStatement();//執行語句stme.executeUpdate(sql);} catch (Exception e) {e.printStackTrace();}finally{DBUtils.closeAll(null, stme, conn);}}}

 

package com.beiwo;/*import org.junit.Before;*/import org.junit.Test;public class TestMasterCrud {/*MasterCurd curd=null;@Before        在前面運行public void befor(){   curd=new MasterCurd();}*/@Test   public void testFindAll(){MasterCurd.findAll();}@Test   public void Insert(){MasterCurd.Insert();}@Test   public void Update(){MasterCurd.Update();}@Test   public void Delete(){MasterCurd.Delete();}}

 

} }

 

純java方式串連資料庫簡單操作