Java Connection to Oracle database

Java wants to connect to a database first to introduce a database driver package

1 Final StaticString drive = "Oracle.jdbc.driver.OracleDriver";2 Final StaticString Oracleurl = "Jdbc:oracle:thin: @xx. Xxx.xx.xx:1521:orcl";3 Final StaticString dbuser= "Studio";4 Final StaticString password= "Studio";5 6  Public voidExcutesearch (String str)7 {8Connection conn =NULL;//represents a database connection9PreparedStatement stmt=NULL;//Use PreparedStatement instead of statement to prevent SQL injection attacks
TenClass.forName (drive);//use class to load programs OneConn =drivermanager.getconnection (Oracleurl,dbuser,password);//connecting to a database A    //preparedstatement interface to be instantiated via the connection interface -stmt =conn.preparestatement (SQLSTR); -Stmt.setstring (1, str); theResultSet resultset=stmt.executequery (); -        while(Resultset.next ()) -         { +Cod=NewCordinate (resultset.getstring ("JD"), Resultset.getstring ("WD"))); -System.out.println ("JD:" +COD.GETJD () + "WD:" +COD.GETWD ()); +         } A stmt.close (); atConn.close ();//Close the database -}

Java Connection to Oracle database