JAVA: Database Operations Encapsulation
Last Update:2017-02-28
Source: Internet
Author: User
Encapsulation | data | database package creator.common.db;
Import Java.io.InputStream;
Import java.sql.*;
Import javax.sql.*;
Import javax.naming.*;
/**
*
* <p>Title:dbBean.java</p>
* <p>description: </p>
* <p>copyright:copyright (c) 2004</p>
* <p>company: </p>
* @author Tanbo
* @version 1.0
*/
public class Dbbean {
public Java.sql.Connection conn = null; Connection object
public ResultSet rs = null; ResultSet Object
Public Statement stmt = null; Statement Object
public PreparedStatement prepstmt = null; PreparedStatement Object
Private String drivers = null; Connection Parameter:drivers
Private String URL = null; Connection Parameter:url
Private String user = null; Connection Parameter:user
Private String password = null; Connection Parameter:password
Private String jndi_name = null; Connection Pool Parameter:jndi Name
/**
* INIT ()
*/
Public Dbbean () {
try{
Parameter init
Drivers = creator.config.ConfigBundle.getString ("Drivers");
url = creator.config.ConfigBundle.getString ("url");
user = creator.config.ConfigBundle.getString ("user");
Password = creator.config.ConfigBundle.getString ("password");
Jndi_name = creator.config.ConfigBundle.getString ("Jndi_name");
DB connection Pool Init
InitialContext env = new InitialContext ();
Javax.sql.DataSource pool = (javax.sql.DataSource) env.lookup (jndi_name);
conn = Pool.getconnection ();
DB connection Init
Class.forName (drivers);
conn = Drivermanager.getconnection (Url,user,password);
DB Statement Init
stmt = Conn.createstatement ();
}catch (Exception e) {
System.out.println ("Dbbean:init error!") +e.tostring ());
}
}
/**
* @function preparestatement
* @param SQL String
* @throws SQLException
*/
public void preparestatement (String sql) throws SQLException {
prepstmt = conn.preparestatement (sql);
}
/**
* @function preparestatement
* @param SQL String
* @param ResultsetType int
* @param resultsetconcurrency int
* @throws SQLException
*/
public void Preparestatement (String sql, int resultsettype, int resultsetconcurrency)
Throws SQLException {
prepstmt = conn.preparestatement (sql, ResultsetType, resultsetconcurrency);
}
/**
* @function ExecuteQuery
* @param SQL String
* @throws SQLException
* @return ResultSet
*/
Public ResultSet executequery (String sql) throws SQLException {
if (stmt!= null) {
return stmt.executequery (SQL);
}else return null;
}
/**
* @function ExecuteQuery
* @throws SQLException
* @return ResultSet
*/
Public ResultSet executequery () throws SQLException {
if (prepstmt!= null) {
return Prepstmt.executequery ();
}else return null;
}
/**
* @function executeupdate
* @param SQL String
* @throws SQLException
*/
public void executeupdate (String sql) throws SQLException {
if (stmt!= null)
Stmt.executeupdate (SQL);
}
/**
* @function executeupdate
* @throws SQLException
*/
public void Executeupdate () throws SQLException {
if (prepstmt!= null)
Prepstmt.executeupdate ();
}
/**
* @function executeupdate
* @throws SQLException
*/
public void ExecuteBatch () throws SQLException {
if (prepstmt!= null)
Prepstmt.executebatch ();
}
/**
* @function Addbatch
* @param value String
* @throws SQLException
*/
public void Addbatch (String value) throws SQLException {
Prepstmt.addbatch (value);
}
/**
* @function setstring
* @param index int
* @param value String
* @throws SQLException
*/
public void setstring (int index,string value) throws SQLException {
Prepstmt.setstring (index, value);
}
/**
* @function Setint
* @param index int
* @param value int
* @throws SQLException
*/
public void Setint (int index,int value) throws SQLException {
Prepstmt.setint (Index,value);
}
/**
* @function SetBoolean
* @param index int
* @param value Boolean
* @throws SQLException
*/
public void SetBoolean (int index,boolean value) throws SQLException {
Prepstmt.setboolean (Index,value);
}
/**
* @function setdate
* @param index int
* @param value Date
* @throws SQLException
*/
public void setdate (int index,date value) throws SQLException {
Prepstmt.setdate (Index,value);
}
/**
* @function Setlong
* @param index int
* @param value Long
* @throws SQLException
*/
public void Setlong (int index,long value) throws SQLException {
Prepstmt.setlong (Index,value);
}
/**
* @function SetFloat
* @param index int
* @param value Float
* @throws SQLException
*/
public void setfloat (int index,float value) throws SQLException {
Prepstmt.setfloat (Index,value);
}
/**
* @function SetBytes
* @param index int
* @param value byte[]
* @throws SQLException
*/
public void setbytes (int index,byte[] value) throws sqlexception{
Prepstmt.setbytes (Index,value);
}
/**
* @function Setbinarystream
* @param index int
* @param value InputStream
* @param len Int
* @throws SQLException
*/
public void Setbinarystream (int index,inputstream value,int len) throws sqlexception{
Prepstmt.setbinarystream (Index,value,len);
}
/**
* @function Settimestamp
* @param index int
* @param timestamp timestamp
* @throws SQLException
*/
public void Settimestamp (int index,timestamp Timestamp) throws SQLException {
Prepstmt.settimestamp (index, timestamp);
}
/**
* @function Setautocommit
* @param value Boolean
* @throws SQLException
*/
public void Setautocommit (Boolean value) throws sqlexception{
if (this.conn!= null)
This.conn.setAutoCommit (value);
}
/**
* @function Commit
* @throws SQLException
*/
public void Commit () throws sqlexception{
This.conn.commit ();
}
/**
* @function rollback
* @throws SQLException
*/
public void rollback () throws sqlexception{
This.conn.rollback ();
}
/**
* @function Close
* @throws Exception
*/
public void Close () {
try{
if (Rs!= null) {
Rs.close ();
rs = null;
}
}catch (Exception e) {
System.out.println ("Dbbean close Rs error!");
}finally{
try{
if (stmt!= null) {
Stmt.close ();
stmt = null;
}
}catch (Exception e) {
System.out.println ("Dbbean close stmt error!");
}finally{
try{
if (prepstmt!= null) {
Prepstmt.close ();
prepstmt = null;
}
}catch (Exception e) {
System.out.println ("Dbbean close prepstmt error!");
}finally{
try{
IF (conn!= null) {
Conn.close ();
conn = null;
}
}catch (Exception e) {
System.out.println ("Dbbean close conn error!");
}
}
}
}
}
}