最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
JAVA:数据库操作封装
时间:2022-07-02 18:16:05 编辑:袖梨 来源:一聚教程网
package creator.common.db;
import java.io.InputStream;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
/**
*
*
*
*
*
* @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());
import java.io.InputStream;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
/**
*
*
Title: dbBean.java
*
Description:
*
Copyright: Copyright (c) 2004
*
Company:
* @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());
相关文章
- 恋与深空五星自选池心像标定 蓝券特别许愿池机制是什么 07-27
- 无限暖暖若生命如诗新版本 2.1活动传送点和逸事攻略 07-27
- 原神月之四新版本角色攻略 哥伦比娅天赋是什么详解 07-27
- 鹅鸭杀隐藏时装怎么获得 隐藏时装与隐藏表情获得方法介绍 07-27
- 龙族卡塞尔之门康斯坦丁技能是什么 康斯坦丁技能详细介绍 07-27
- 生存33天冰魔法师怎么打 冰魔法师打法教学详解 07-27