dbbean.java

jsp编写的新闻管理系统.各页面清析,大家支持一下

package com.xujianyou;

import java.sql.*;

public class DbBean {
	/**
	 * this driver default is sql
	 * "sun.jdbc.odbc.JdbcOdbcDriver"is Access Driver
	 */
	//private String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
	private String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
	
	/**
	 * this url default is sql'db=message'
	 * and "jdbc:odbc:*" is Access url
	 */
	//private String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=message";
	private String url = "jdbc:odbc:news";
	
	//private String user = "xujianyou";
	//private String pwd = "xujianyou";
	private String user = "";
	private String pwd = "";
	private Connection conn = null;
	private Statement stmt = null;
	private PreparedStatement pstm = null;
	
	public String getDriver() {
		return driver;
	}

	public void setDriver(String driver) {
		this.driver = driver;
	}

	public String getUrl() {
		return url;
	}

	public void setUrl(String url) {
		this.url = url;
	}

	public String getUser() {
		return user;
	}

	public void setUser(String user) {
		this.user = user;
	}

	public String getPwd() {
		return pwd;
	}

	public void setPwd(String pwd) {
		this.pwd = pwd;
	}
	
	public DbBean (){
		try {
			Class.forName(driver);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}

	public ResultSet executeQuery(String sql){
		ResultSet rs = null;
		try {
			conn = DriverManager.getConnection(url,user,pwd);
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return rs;
	}
	
	public int executeUpadte(String sql){
		int result = 0;
		try {
			conn = DriverManager.getConnection(url,user,pwd);
			stmt = conn.createStatement();
			result = stmt.executeUpdate(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return result;
	}
	
	public void close(){
		try {
			stmt.close();
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

	
}