今天看视频DAO设计模式,发现一个好东西:数据库链接类。
以前用.net时有个dbhelp.cs,每次我都去复制这个基类。
今天终于找到java的基类了。以后有的复制了~~~~~~~~~
以前用.net时有个dbhelp.cs,每次我都去复制这个基类。
今天终于找到java的基类了。以后有的复制了~~~~~~~~~
package cn.mldn.lxh.dbc ;
import java.sql.* ;
// 主要功能就是连接数据库、关闭数据库
public class DataBaseConnection
{
private final String DBDRIVER = "oracle.jdbc.driver.OracleDriver" ;
private final String DBURL = "jdbc:oracle:thin:@localhost:1521:MLDN" ;
private final String DBUSER = "scott" ;
private final String DBPASSWORD = "tiger" ;
private Connection conn = null ;
public DataBaseConnection()
{
try
{
Class.forName(DBDRIVER) ;
this.conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;
}
catch (Exception e)
{
}
}
// 取得数据库连接
public Connection getConnection()
{
return this.conn ;
}
// 关闭数据库连接
public void close()
{
try
{
this.conn.close() ;
}
catch (Exception e)
{
}
}
};
import java.sql.* ;
// 主要功能就是连接数据库、关闭数据库
public class DataBaseConnection
{
private final String DBDRIVER = "oracle.jdbc.driver.OracleDriver" ;
private final String DBURL = "jdbc:oracle:thin:@localhost:1521:MLDN" ;
private final String DBUSER = "scott" ;
private final String DBPASSWORD = "tiger" ;
private Connection conn = null ;
public DataBaseConnection()
{
try
{
Class.forName(DBDRIVER) ;
this.conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;
}
catch (Exception e)
{
}
}
// 取得数据库连接
public Connection getConnection()
{
return this.conn ;
}
// 关闭数据库连接
public void close()
{
try
{
this.conn.close() ;
}
catch (Exception e)
{
}
}
};