package com.isoftstone.jack.database;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class TestJdbc
{
public void createConnection()
{
Statement stmt = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@10.41.16.88:1521:ora";
String username = "umcpmgt";
String password = "icd";
Connection con = DriverManager.getConnection(url, username, password);
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from t_bss_accountinfo");
while(rs.next())
{
System.out.println("userNo = " + rs.getString("AREA_CODE"));
}
}
catch (SQLException e)
{
e.printStackTrace();
}
catch (ClassNotFoundException e)
{
System.out.println("ClassNotFoundException");
}
catch (Exception e)
{
System.out.println("Exception");
}
finally
{
try
{
stmt.close();
}
catch (SQLException e) {
// TODO: handle exception
System.out.println("stmt.close() SQLException");
}
}
}
/**
* @param args
*/
public static void main(String[] args)
{
TestJdbc tj = new TestJdbc();
tj.createConnection();
}
}