import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class TestDemo
{
private static String url="jdbc:oracle:thin:@localhost:1521:orcl";
private static String user="system";
private static String password="manager";
private static Connection conn;
private Statement statement = null;
private ResultSet rs = null;
public void getConnection(){
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection(url, user, password);
statement = conn.createStatement();
} catch (Exception e) {
e.printStackTrace();
}
}
public ResultSet executeQuery(String sql){
try{
rs=statement.executeQuery(sql);
}
catch (SQLException e){
e.printStackTrace();
}
return rs;
}
public void close(){
try{
rs.close();
statement.close();
conn.close();
}
catch (Exception e){
e.printStackTrace();
}
}
public static void main(String[] args){
ResultSet rs;
TestDemo testDemo = new TestDemo();
testDemo.getConnection();
rs=testDemo.executeQuery("select * from test");
try{
while (rs.next()){
//do something
}
}catch(Exception e){
e.printStackTrace();
}
testDemo.close();
}
}