package com.deo.javabean;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBAccess {
private String drv ="com.mysql.jdbc.Driver";//数据库驱动名private String url ="jdbc:mysql://localhost:3306/deo";
private String usr ="root";
private String pwd ="";
private Connection conn =null;
private Statement stm =null;
private ResultSet rs =null;
public String getDrv() {
return drv;
}
public void setDrv(String drv) {
this.drv = drv;
}
public String getUrl() {
return url;
}
public void setUrl(String url) {
this.url = url;
}
public String getUsr() {
return usr;
}
public void setUsr(String usr) {
r = usr;
}
public String getPwd() {
return pwd;
}
public void setPwd(String pwd) {
this.pwd = pwd;
}
public Connection getConn() {
return conn;
}
public void setConn(Connection conn) {
this.conn = conn;
}
public Statement getStm() {
return stm;
}
public void setStm(Statement stm) {
this.stm = stm;
}
public ResultSet getRs() {
return rs;
}
public void setRs(ResultSet rs) {
this.rs = rs;
}
public boolean createConn(){
boolean b =false;
try{
Class.forName(drv).newInstance();//在取得连接之前，要注册驱动程序，
//用该方法，显示的加载驱动程序类
conn=DriverManager.getConnection(url, usr, pwd);
b=true;
}catch(SQLException e){
}catch(ClassNotFoundException e){
}catch(InstantiationException e){
}catch(IllegalAccessException e){
}
return b;
}
public boolean update(String sql){
boolean b =false;
try{
stm = conn.createStatement();
stm.execute(sql);
b=true;
}catch(Exception e){}
return b;
}
public void query(String sql){
try{
stm=conn.createStatement();
rs=stm.executeQuery(sql);
}catch(Exception e){}
}
public boolean next(){
boolean b = false;
try{
if(rs.next())
b =true;
}catch (Exception e){}
return b;
}
public String getValue(String field){ String value = null;
try{
if(rs!=null)value=rs.getString(field); }catch(Exception e){}
return value;
}
public void closeRs(){
try{
if(rs!=null)
rs.close();
}catch(Exception e){}
}
public void closeStm(){
try{
if(stm!=null)
stm.close();
}catch(Exception e){}
}
public void closeConn(){ try{
if(conn!=null)
conn.close();
}catch(Exception e){} }
}。