Java串連Oracle資料庫

標籤：style   blog   color   os   java   使用   io   for   ar   

java想要串連資料庫首先要引入資料庫驅動包

 1 final static String drive = "oracle.jdbc.driver.OracleDriver"; 2 final static String oracleurl = "jdbc:oracle:thin:@xx.xxx.xx.xx:1521:orcl"; 3 final static String DBUSER="studio"; 4 final static String password="studio"; 5  6 public void excuteSearch(String str) 7 { 8    Connection conn = null;//表示資料庫連接 9    PreparedStatement  stmt= null;//這裡用PreparedStatement代替statement是防止Sql注入攻擊
10    Class.forName(drive);//使用class類來載入程式11    conn =DriverManager.getConnection(oracleurl,DBUSER,password);    //串連資料庫12    //PreparedStatement介面要通過connection介面來進行執行個體化操作13    stmt = conn.prepareStatement(SqlStr);14    stmt.setString(1, str);15    ResultSet resultset=stmt.executeQuery();17       while(resultset.next())18         {19            cod=new cordinate(resultset.getString("JD"),resultset.getString("WD"));20            system.out.println("JD:"+cod.getJD()+"   WD:"+cod.getWD());21         }22             stmt.close();23             conn.close();//關閉資料庫24 }

 

Java串連Oracle資料庫