dbbean.java

来自「投票管理系统.可以投票可以查看票数,也可以在后台管理」· Java 代码 · 共 57 行

package com.xujianyou;

import java.sql.*;

public class DbBean {
	
	private Connection con = null;
	private Statement stmt = null;
	
	String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
	String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=VoteSystem";
	String user = "xujianyou";
	String pwd = "xujianyou";
	
	public DbBean(){
		try {
			Class.forName(driver);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	
	public ResultSet executeQuery(String sql) {
		ResultSet rs = null;
		try {
			con = DriverManager.getConnection(url,user,pwd);
			stmt = con.createStatement();
			rs = stmt.executeQuery(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return rs;
	}
	
	public int executeUpdate(String sql) {
		int result = 0;
		try {
			con = DriverManager.getConnection(url,user,pwd);
			stmt = con.createStatement();
			result = stmt.executeUpdate(sql);
		} catch (SQLException e) {
			//e.printStackTrace();
		}
		return result;
	}
	
	public void close() {
		try {
			con.close();
			stmt.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
	}
}