package com.drp.jdbc.util;
import java.sql.*;
public class JdbcBean{
public static void main(String[] args){
JdbcBean.getConnection();
}
JdbcBean(){ try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
System.out.println("ClassNotFoundException");
e.printStackTrace();
} }
public static Connection getConnection(){
Connection conn = null;
try{
conn=DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.106:1521:orcl", "system", "admin");
}catch(SQLException e){
System.out.println(e+"======out");
} return conn;
}
public static void closeConn(Connection conn){
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
conn=null;
}
public static void closeResultSet(ResultSet rs){
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
rs=null;
}
public static void closePreparedStatement(PreparedStatement ps){
if(ps!=null){
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
ps=null;
}
}
getConnection()方法有异常,但不明白是怎么回事啊
import java.sql.*;
public class JdbcBean{
public static void main(String[] args){
JdbcBean.getConnection();
}
JdbcBean(){ try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
System.out.println("ClassNotFoundException");
e.printStackTrace();
} }
public static Connection getConnection(){
Connection conn = null;
try{
conn=DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.106:1521:orcl", "system", "admin");
}catch(SQLException e){
System.out.println(e+"======out");
} return conn;
}
public static void closeConn(Connection conn){
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
conn=null;
}
public static void closeResultSet(ResultSet rs){
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
rs=null;
}
public static void closePreparedStatement(PreparedStatement ps){
if(ps!=null){
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
ps=null;
}
}
getConnection()方法有异常,但不明白是怎么回事啊
try{
conn=DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.106:1521:orcl", "system", "admin");
}catch(SQLException e){
System.out.println(e+"======out");
}
这里调用e.printStackXXX打印报错信息,是否用户名密码不正确?还是驱动没加载?
看看是不是扩展jar了?