jdbc串連mysql

標籤：

要匯入相應的包]

 1 public class ConnDB { 2     private Connection ct = null; 3    //驅動程式名 4     String driver = "com.mysql.jdbc.Driver"; 5     // URL指向要訪問的資料庫名scutcs 6     String url = "jdbc:mysql://127.0.0.1:3306/develop"; 7     // MySQL配置時的使用者名稱 8     String user = "root"; 9     // Java串連MySQL配置時的密碼

10     String password = "wzy123";

11 12     public Connection getConn(){13         try{14             Class.forName(driver);    15             ct = DriverManager.getConnection(url, user, password);16         }17         catch(Exception e){18             e.printStackTrace();19         }20         return ct;21     }22 }

 

public int add(String day,String time,String volname,String volclass,String voltel,String volemail){Connection con = DbConnect.this.getConn();int num = -1;try {java.sql.Statement statement = con.createStatement(); num = statement.executeUpdate( "insert into tb_volinfo(day,time,volname,volclass,voltel,volemail) "+ "values(‘"+day+"‘,‘"+time+"‘,‘"+volname+"‘,‘"+volclass+"‘,‘"+voltel+"‘,‘"+volemail+"‘)");if(statement!=null){statement.close();}if(con!=null){con.close();//關閉資料庫連接}} catch (Exception e) {e.printStackTrace();}return num;}public boolean SelectVal(String volname,String voltel){Connection con1 = DbConnect.this.getConn();ResultSet result =null;try {java.sql.Statement statement = con1.createStatement();    result = statement.executeQuery("select * from tb_volinfo where volname=‘"+volname+"‘ and voltel=‘"+voltel+"‘;");while(result.next()){return true;}    if(statement!=null){statement.close();}if(con1!=null){con1.close();//關閉資料庫連接}} catch (Exception e) {e.printStackTrace();}return false;}

　　

jdbc串連mysql