链接数据库BaseDao
来源:互联网 发布:picsart素材软件 编辑:程序博客网 时间:2024/04/30 13:13
package com.check.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class BaseDao {
private final String DRIVER="oracle.jdbc.driver.OracleDriver";
private final String URL="jdbc:oracle:thin:@localhost:1521:orcl";
private final String USER="service";
private final String PWD="orcl";
private Connection conn=null;
private PreparedStatement pstm=null;
private ResultSet rs=null;
public Connection getConnection(){
try {
Class.forName(DRIVER);
conn=DriverManager.getConnection(URL,USER,PWD);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public int executeUpdate(String sql,Object[] params){
int ret=0;
conn=this.getConnection();
try {
pstm=conn.prepareStatement(sql);
this.setParams(pstm, params);
ret=pstm.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
return ret;
}
public int executeUpdate(String sql){
return executeUpdate(sql,null);
}
public ResultSet executeQuery(String sql,Object[] params){
conn=this.getConnection();
try {
pstm=conn.prepareStatement(sql);
this.setParams(pstm, params);
rs=pstm.executeQuery();
} catch (SQLException e) {
e.printStackTrace();
}//因为rs还要使用,所以不能close()
return rs;
}
public ResultSet executeQuery(String sql){
return executeQuery(sql,null);
}
private void setParams(PreparedStatement pstm,Object[] params) throws SQLException{
if(params!=null){
for(int i=0;i<params.length;i++){
pstm.setObject(i+1, params[i]);
}
}
}
public void closeStatement(){
try {
if(pstm!=null) pstm.close();
if(conn!=null) conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void closeAll(){
try {
if(rs!=null) rs.close();
if(pstm!=null) pstm.close();
if(conn!=null) conn.close();//取消引用
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class BaseDao {
private final String DRIVER="oracle.jdbc.driver.OracleDriver";
private final String URL="jdbc:oracle:thin:@localhost:1521:orcl";
private final String USER="service";
private final String PWD="orcl";
private Connection conn=null;
private PreparedStatement pstm=null;
private ResultSet rs=null;
public Connection getConnection(){
try {
Class.forName(DRIVER);
conn=DriverManager.getConnection(URL,USER,PWD);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public int executeUpdate(String sql,Object[] params){
int ret=0;
conn=this.getConnection();
try {
pstm=conn.prepareStatement(sql);
this.setParams(pstm, params);
ret=pstm.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
return ret;
}
public int executeUpdate(String sql){
return executeUpdate(sql,null);
}
public ResultSet executeQuery(String sql,Object[] params){
conn=this.getConnection();
try {
pstm=conn.prepareStatement(sql);
this.setParams(pstm, params);
rs=pstm.executeQuery();
} catch (SQLException e) {
e.printStackTrace();
}//因为rs还要使用,所以不能close()
return rs;
}
public ResultSet executeQuery(String sql){
return executeQuery(sql,null);
}
private void setParams(PreparedStatement pstm,Object[] params) throws SQLException{
if(params!=null){
for(int i=0;i<params.length;i++){
pstm.setObject(i+1, params[i]);
}
}
}
public void closeStatement(){
try {
if(pstm!=null) pstm.close();
if(conn!=null) conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void closeAll(){
try {
if(rs!=null) rs.close();
if(pstm!=null) pstm.close();
if(conn!=null) conn.close();//取消引用
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
0 0
- 链接数据库BaseDao
- baseDAO数据库链接
- basedao(连接数据库)
- JDBC连接数据库的BaseDao
- BaseDAO
- basedao
- BaseDao
- baseDao
- BaseDao
- BaseDao
- BaseDAO
- BaseDao
- BaseDao
- BaseDao
- BaseDao
- BaseDao
- BaseDao....
- BaseDao
- JAVA零基础入门
- Struts2中的OGNL详解
- 封装jQuery Validate扩展验证方法
- 短文本聚类方法
- Java泛型解析(04):约束和局限性
- 链接数据库BaseDao
- JAVA序列化的思考
- Leetcode分类-树
- Leetcode--Next Permutation
- 使用SAP标准程序:RMDATIND可直接输入物料主数据
- 修改Thinkpad在Windows 8下的充电阈值
- 关于bootstrap中的一些小技巧
- 精评“Protocol Buffers”,即protobuf
- 印刷标准光源要求