使用JAVA连接池作的数据库增删改查

使用JAVA连接池作的数据库增删改查.txtゅ你不用一上线看见莪在线，就急着隐身，放心。莪不会去缠你。说好的不离不弃 现在反而自己却做不到╮ oralceUitlPool.java


package com.oneworld.util;

import java.sql.Connection;
import java.sql.DriverManager;

import javax.naming.InitialContext;
import javax.sql.DataSource;


/**
* @author mmode
*
*/
public class oralceUitlPool {
static Connection conn=null;
public static Connection getConnection(){

InitialContext initctx;
try{
initctx=new InitialContext();
DataSource ds=(DataSource)initctx.lookup("java:comp/env/jdbc/vodone");
conn=ds.getConnection();

}catch(Exception e){
e.printStackTrace();
}
return conn;

}

public static Connection ConnectToDB()
{
try
{
String oURL = "192.168.5.92";
String oPort = "1521";
String oService = "smsdb";
String oUser = "gtsms";
String oPassword = "gtsms";
String sdName = "oracle.jdbc.driver.OracleDriver";
Class.forName(sdName);
String connStr = "jdbc:oracle:thin:@" + oURL + ":" + oPort + ":"+ oService;
conn = DriverManager.getConnection(connStr, oUser,oPassword);
}
catch(Exception e)
{
System.out.println(e);
}
return conn;
}
public static void main(String[] args)
{
oralceUitlPool oup=new oralceUitlPool();
oup.getConnection();
}
}

DBUtil.java

package com.oneworld.util;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/******
* 使用连接池连接数据库,提供对数据库操作的各个接口
* @author mmode
*
*/
public class DBUtil {

private Connection conn=null;
private Statement stmt=null;
private ResultSet rs=null;

public DBUtil(){
// conn=oralceUitlPool.getConnection();
conn=oralceUitlPool.ConnectToDB();
try {
stmt=conn.createStatement();

} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}
/*************
* 数据库操作----增加
* @param sql:将要执行的SQL语句
* @return：执行成功了，返回true,执行不成功，返回false
*/
public boolean ExeInser(String sql){
boolean flag=true;
try{
stmt.execute(sql);
flag=true;
}catch(SQLException e){
flag=false;
e.printStackTrace();
}
return flag;
}
/********
* 数据库操作----删除
* @param sql:将要执行的SQL语句
* @return:执行成功，返回true，执行失败，返回false;
* @throws SQLException
*/
public boolean ExeDel(String sql) throws SQLException{
boolean flag=true;
try {
stmt.execute(sql);
flag=true;
} catch (SQLException e) {
flag=false;
e.printStackTrace();
}
return flag;
}

/************
* 数据库操作----修改
* @param sql:将要执行的SQL语句
* @return:执行成功,返回true,执行失败，返回false;
*/
public boolean ExeUpdate(String sql){
boolean flag=true;
try{
stmt.executeUpdate(sql);
flag=true;
}catch(SQLException e){
flag=false;
e.printStackTrace();
}
return flag;
}
/**********
* 数据库操作------查询
* @param sql:将要执行的SQL语句
* @return：执行成功，返回true,执行失败，返回false
*/
public boolean ExeSelect(String sql){
boolean flag=true;
try{
rs=stmt.executeQuery(sql);
flag=true;
}catch(SQLException e){
flag=false;
e.printStackTrace();
}
return flag;
}

public ResultSet getRS(){
return rs;
}
public static void main(String args[]) throws SQLException{
DBUtil dbc=new DBUtil();
boolean b=dbc.ExeSelect("select * from gtsms.image_group_item");
System.out.print(b);
}
}


标签: 学习充电(JAVA)