while (rs.next())
{ //用户名
System.out.println(rs.getString(columnIndex));
}
//默认是从1开始编号的
}
public Connection getConnection(String ip,String port,String sid,String userName,String passWord )
{
String driverName="oracle.jdbc.driver.OracleDriver";// 连接oracle驱动包
String dbUrl="jdbc:oracle:thin:@"+ip+":"+port+":"+sid+"";
Connection conn=null;
// 从下面开始，和SQL Server一模一样
try {
Class.forName(driverName);
conn = DriverManager.getConnection(dbUrl, userName, passWord);
} catch (ClassNotFoundException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
//Connection conn;
return conn;
}
}
/**
* @author 东海 陈光剑 chenguangjian 2013-4-9上午10:42:40
* Email: universsky@126.com
* Blog: http://blog.sina.com.cn/universsky11
* http://blog.csdn.net/universsky
*/
package isword;
/**
* @author 东海 陈光剑 chenguangjian 2013-4-9上午10:42:40
* Email: universsky@126.com
* Blog: http://blog.sina.com.cn/universsky11
* http://blog.csdn.net/universsky
*/
/**
* @author 东海 陈光剑 chenguangjian 2013-4-9上午10:42:40
* Email: universsky@126.com
* Blog: http://blog.sina.com.cn/universsky11
* http://blog.csdn.net/universsky
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DBConnection {
/** * 获取数据连接
驱动：oracle.jdbc.driver.OracleDriverURL：jdbc:oracle:thin:@
jdbc:oracle:thin:@localhost:1521:orcl
注：machine_name：数据库所在的机器的名称ip；
port：端口号，默认是1521
username:默认是scott
password:默认是tiger
* @throws SQLException
* */
public static void main(String[]args) throws SQLException{
DBConnection dc=new DBConnection();
Connection ct=null;
String ip="10.137.5.61";//db ip
String port="1521";//
String sid="ora61";
String userName="ddsysdb";
String passWord="IVcbs33";
int columnIndex=2;
ct=dc.getConnection(ip, port, sid, userName, passWord);
// 从下面开始，和SQL Server一模一样
Statement sm = ct.createStatement();
ResultSet rs = sm.executeQuery("select * from cbe_policy where ATTACHPRICEPLANID=10");
while (rs.next())
{ //用户名
System.out.println(rs.getString(columnIndex));
}
//默认是从1开始编号的
}
public Connection getConnection(String ip,String port,String sid,String userName,String passWord )
{
String driverName="oracle.jdbc.driver.OracleDriver";// 连接oracle驱动包
String dbUrl="jdbc:oracle:thin:@"+ip+":"+port+":"+sid+"";
Connection conn=null;
// 从下面开始，和SQL Server一模一样
try {
Class.forName(driverName);
conn = DriverManager.getConnection(dbUrl, userName, passWord);
} catch (ClassNotFoundException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
//Connection conn;
return conn;
}
}