Packagecom.test;Importjava.sql.Connection;ImportJava.sql.DriverManager;Importjava.sql.PreparedStatement;ImportJava.sql.ResultSet;Importjava.sql.SQLException; Public classDbconn { Public StaticConnection Getconn (String db) {string drivername=""; String Dburl=""; String UserName= ""; String userpwd = "";if(Db.equals ("SQL Server") ) {drivername= "Com.microsoft.sqlserver.jdbc.SQLServerDriver"; Dburl= "jdbc:sqlserver://192.168.0.1:1444; Databasename=test "; UserName= ""; Userpwd= ""; }Else if(Db.equals ("Oracle") ) {drivername= "Oracle.jdbc.driver.OracleDriver"; Dburl= "Jdbc:oracle:thin:@192.168.0.1:1521:test"; UserName= ""; Userpwd= ""; }Else if(Db.equals ("MySQL") ) {drivername= "Com.mysql.jdbc.Driver"; Dburl= "Jdbc:mysql://192.168.0.1:3306/test"; UserName= ""; Userpwd= ""; } Connection dbconn=NULL; Try{class.forname (drivername); Dbconn=drivermanager.getconnection (Dburl, UserName, userpwd); } Catch(Exception e) {e.printstacktrace (); } returnDbconn; } Public Static voidMain (string[] args) {Connection dbconn=dbconn.getconn ("Oracle"); System.out.println (Dbconn); String SQL= "SELECT id from table"; PreparedStatement PS; Try{PS=dbconn.preparestatement (SQL); ResultSet RS=Ps.executequery (); while(Rs.next ()) System.out.println (Rs.getint ("id")); } Catch(SQLException e) {e.printstacktrace (); } }}
JDBC Connection Database (mysql,sqlserver,oracle)