package ex3;
import java.sql.*;
import java.util.*;public class Dbconn {
private static Connection m_Conn = null;
public void DbClose()throws Exception{
if(m_Conn != null){
try{
m_Conn.close();
}
catch(Exception ex){
throw new Exception(ex);
}
}
}
public void print(){
System.out.println("db is connected");
}
public static void main(String[]args){
Dbconn conn = new Dbconn();
String st = null;
try {
st = "select login_name from dloginmsg where login_no='kf0077'";
System.out.println(st);
Class.forName("oracle.jdbc.driver.OracleDriver");
m_Conn = DriverManager.getConnection("jdbc:oracle:thin:@172.16.6.237:1521:crmtest","ccadm","ccadm");
if(m_Conn.isClosed()==true){
System.out.println("db id close");
}
else{
Statement smt1 = m_Conn.createStatement();
ResultSet rs1 = smt1.executeQuery(st);
ResultSetMetaData msmd1 = rs1.getMetaData();
int ColumnNum = msmd1.getColumnCount();
while(rs1.next()){
String strData = "";
for(int i=1;i<ColumnNum;i++){
strData = strData + rs1.getString(i)+"\t";
System.out.println(strData);
}
}
}
} catch (Exception e) {
e.printStackTrace();
}
try {
conn.DbClose();
} catch (Exception e) {
e.printStackTrace();
}
}}
import java.sql.*;
import java.util.*;public class Dbconn {
private static Connection m_Conn = null;
public void DbClose()throws Exception{
if(m_Conn != null){
try{
m_Conn.close();
}
catch(Exception ex){
throw new Exception(ex);
}
}
}
public void print(){
System.out.println("db is connected");
}
public static void main(String[]args){
Dbconn conn = new Dbconn();
String st = null;
try {
st = "select login_name from dloginmsg where login_no='kf0077'";
System.out.println(st);
Class.forName("oracle.jdbc.driver.OracleDriver");
m_Conn = DriverManager.getConnection("jdbc:oracle:thin:@172.16.6.237:1521:crmtest","ccadm","ccadm");
if(m_Conn.isClosed()==true){
System.out.println("db id close");
}
else{
Statement smt1 = m_Conn.createStatement();
ResultSet rs1 = smt1.executeQuery(st);
ResultSetMetaData msmd1 = rs1.getMetaData();
int ColumnNum = msmd1.getColumnCount();
while(rs1.next()){
String strData = "";
for(int i=1;i<ColumnNum;i++){
strData = strData + rs1.getString(i)+"\t";
System.out.println(strData);
}
}
}
} catch (Exception e) {
e.printStackTrace();
}
try {
conn.DbClose();
} catch (Exception e) {
e.printStackTrace();
}
}}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货