package com.zzhoujsp_jbean.javabean;
import java.sql.*;
public class DBAccess
{
private String drv="com.mysql.jdbc.Driver";
private String url="jdbc:mysql://localhost:3306/demo";
private String usr="root";
private String pwd="120120";
private Connection conn=null;
private Statement stm=null;
private ResultSet rs=null;
public boolean createConn(){
boolean b=false;
try{
Class.forName(drv).newInstance();
conn=DriverManager.getConnection(url,usr,pwd);
b=true;
}
catch(Exception 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){}
}
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) {
this.usr = 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;
}
}