package coreJava;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class TestDBConnection {
private String user = "oracle";
private String pwd = "oracle";
private String driver = "oracle.jdbc.driver.OracleDriver";
private String url = "jdbc:oracle:thin:@127.0.0.1:1521:oracle";
private Connection conn ;
private Statement stmt;
public void GetConnection(String sql) throws ClassNotFoundException, SQLException{
Class.forName(driver);
conn = DriverManager.getConnection(url, user, pwd);
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()){
String a = rs.getString(1);
String b = rs.getString(2);
String c = rs.getString(3);
System.out.println(rs);
}
conn.close();
stmt.close();
}
public static void main(String[] args) throws Exception, SQLException{
String sql = "select * from indv_basic_info";
TestDBConnection ts = new TestDBConnection();
ts.GetConnection(sql);
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class TestDBConnection {
private String user = "oracle";
private String pwd = "oracle";
private String driver = "oracle.jdbc.driver.OracleDriver";
private String url = "jdbc:oracle:thin:@127.0.0.1:1521:oracle";
private Connection conn ;
private Statement stmt;
public void GetConnection(String sql) throws ClassNotFoundException, SQLException{
Class.forName(driver);
conn = DriverManager.getConnection(url, user, pwd);
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()){
String a = rs.getString(1);
String b = rs.getString(2);
String c = rs.getString(3);
System.out.println(rs);
}
conn.close();
stmt.close();
}
public static void main(String[] args) throws Exception, SQLException{
String sql = "select * from indv_basic_info";
TestDBConnection ts = new TestDBConnection();
ts.GetConnection(sql);
}
}