package com.wolf.pub;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
/**
*
* @author zhengbin
*/
public abstract class BaseDao {
protected Connection conn=null;
protected BaseDao(){
conn=localConnect.getConnection();
}
//回滚
protected void rollback() throws SQLException{
if(conn==null){
throw new SQLException();
} else{
conn.rollback();
}
}
//提交
protected void commit() throws SQLException{
if(conn==null){
throw new SQLException();
} else{
conn.commit();
}
}
//创建PreparedStatement
protected PreparedStatement PreparedStatement(String sql) throws SQLException{
if(conn==null){
throw new SQLException();
}else{
return conn.prepareStatement(sql);
}
}
//
public void close(){
if (conn!=null){
try{
conn.close();
}catch(SQLException e){
e.printStackTrace();
} }
}
}