public class DBOperation {
Connection conn = null; // Database Connection
ResultSet rs = null; // Search ResultSet
String ip = "";
String dbname = ""; public DBOperation(String ip,String dbname) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
this.ip = ip;
this.dbname= dbname;
String con= "";
con = "jdbc:oracle:thin:@"+ip+":1521:"+dbname;
conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.10.80:1521:ultrasms","aradmin","ar#admin#"); }
catch (Exception ex) {} } public void finalize(){
try {
if(rs != null) rs.close();
if(conn != null) conn.close();
}
catch (Exception ex) {}
} public static void main(String[] args) {
DBOperation db = new DBOperation("192.168.10.80","ultrasms");
String s = "select * from t67 ";
ResultSet r = null;
r = db.executeQuery(s);
try {
while (r.next()){
System.out.println(r.getString(1)+" :"+r.getString(2));
}
}
catch (Exception ex) {} }}
当我在eclipse中分步执行时
每当运行到这句时 conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.10.80:1521:ultrasms","aradmin","ar#admin#");
就会跳到 Integer.class的throw new NumberFormatException("null");这句,不知什么原因,程序还能正常向下运行,高人指点以下,郁闷啊!
Connection conn = null; // Database Connection
ResultSet rs = null; // Search ResultSet
String ip = "";
String dbname = ""; public DBOperation(String ip,String dbname) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
this.ip = ip;
this.dbname= dbname;
String con= "";
con = "jdbc:oracle:thin:@"+ip+":1521:"+dbname;
conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.10.80:1521:ultrasms","aradmin","ar#admin#"); }
catch (Exception ex) {} } public void finalize(){
try {
if(rs != null) rs.close();
if(conn != null) conn.close();
}
catch (Exception ex) {}
} public static void main(String[] args) {
DBOperation db = new DBOperation("192.168.10.80","ultrasms");
String s = "select * from t67 ";
ResultSet r = null;
r = db.executeQuery(s);
try {
while (r.next()){
System.out.println(r.getString(1)+" :"+r.getString(2));
}
}
catch (Exception ex) {} }}
当我在eclipse中分步执行时
每当运行到这句时 conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.10.80:1521:ultrasms","aradmin","ar#admin#");
就会跳到 Integer.class的throw new NumberFormatException("null");这句,不知什么原因,程序还能正常向下运行,高人指点以下,郁闷啊!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货