package ejb;
import java.util.*;
import java.io.*;
import java.sql.*;
import javax.naming.*;
import javax.sql.DataSource;
public class DBConnection implements Serializable{
protected Connection con=null;
private String user = "db2admin" ;
private String pass = "db2admin" ;
public DBConnection() { }
public void dbOpen() throws java.lang.Exception{
try
{
if (con == null || con.isClosed()) {
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
Properties p=new Properties();
p.put("user",user);
p.put("password",pass);
System.out.println("DB OPEN");
} else {
System.out.println("OPENED DB");
}
} catch (Exception e)//数据源不存在
{
con=DriverManager.getConnection("jdbc:db2:db_sdbc",p); System.out.println("连接数据库异常:"+e.toString());
} } public void dbClose() {
try {
if (con != null && !con.isClosed()) {
con.rollback();
con.close();
System.out.println("DB CLOSE");
} else {
System.out.println("CLOSED DB");
}
}
catch (Exception e) {
System.out.println("关闭数据库异常:"+e.toString());
}
finally {
con = null;
}
}
}
import java.util.*;
import java.io.*;
import java.sql.*;
import javax.naming.*;
import javax.sql.DataSource;
public class DBConnection implements Serializable{
protected Connection con=null;
private String user = "db2admin" ;
private String pass = "db2admin" ;
public DBConnection() { }
public void dbOpen() throws java.lang.Exception{
try
{
if (con == null || con.isClosed()) {
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
Properties p=new Properties();
p.put("user",user);
p.put("password",pass);
System.out.println("DB OPEN");
} else {
System.out.println("OPENED DB");
}
} catch (Exception e)//数据源不存在
{
con=DriverManager.getConnection("jdbc:db2:db_sdbc",p); System.out.println("连接数据库异常:"+e.toString());
} } public void dbClose() {
try {
if (con != null && !con.isClosed()) {
con.rollback();
con.close();
System.out.println("DB CLOSE");
} else {
System.out.println("CLOSED DB");
}
}
catch (Exception e) {
System.out.println("关闭数据库异常:"+e.toString());
}
finally {
con = null;
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货