dbaccess.java

来自「用jsp+javabean+servlet写的留言板」· Java 代码 · 共 141 行

package com.mybook.javabean;
import java.sql.*;

public class DBAccess {
	private String drv="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	private String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=mybook";
	private String usr="sa";
	private String pwd="19860315";
	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) {
		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;
	}

	public boolean createConn(){
		boolean b=false;
		try{
			Class.forName(drv).newInstance();
			conn=java.sql.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 int getIntValue(String field){
		int value=0;
		try{
			if(rs!=null)value=rs.getInt(field);
		}catch(Exception e){
			
		}
		return value;
	}
	
	public void closeRs(){
		try{
			if(rs!=null)rs.close();
		}catch(SQLException e){
			
		}
	}
	public void closeStm(){
		try{
			if(stm!=null)stm.close();
		}catch(SQLException e){
			
		}
	}
	public void closeConn(){
		try{
			if(conn!=null)conn.close();
		}catch(SQLException e){
			
		}
	}
	
	

}