jdbc

package Driver;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class TestD {
private static String driverName = 
"oracle.jdbc.driver.OracleDriver";


private static String url = 


"jdbc:oracle:thin:@192.168.1.150:1521:xxx";


private static String username = "xxx";


private static String pwd = "xxx";

public static void main(String[] args){
Connection conn = null;
Statement stat = null;
ResultSet rst = null;
try {
Class.forName(driverName);
conn = DriverManager.getConnection(
url,username,pwd);
stat = conn.createStatement();
rst = stat.executeQuery(
"select * from students");
while(rst.next()){
int id = rst.getInt(1);
String username = rst.getString(2);
String pwd = rst.getString(3);
String age = rst.getString(4);
System.out.println("id:" + id 
+ " username:" + username 
+ " pwd:" + pwd + " age:" + age);
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}finally{
try{
if(rst != null){
rst.close();
}
if(stat != null){
rst.close();
}
if(conn != null){
rst.close();
}
}catch(Exception e){
e.printStackTrace();
}
}
}
}