database.java

来自「班级管理系统」· Java 代码 · 共 69 行

package lab.lab;
import java.sql.*;

/*连接数据库的类*/
public class Database {
	private Statement stmt = null;

	ResultSet rs = null;

	private Connection conn = null;

	String sql;

	String user = "sa";

	String password = "";

	String url = "jdbc:odbc:scmanage";

	Database() {

	}

	public void OpenConn() throws Exception {
		try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		conn = DriverManager.getConnection(url, user, password);
	}catch(Exception e4){}
	}
	public ResultSet executeQuery(String sql) throws Exception {
		stmt = null;
		rs = null;
		try{
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
				ResultSet.CONCUR_READ_ONLY);
		rs = stmt.executeQuery(sql);}
	catch(Exception e){}
		return rs;

	}

	public void executeUpdate(String sql) throws Exception {
		stmt = null;
		rs = null;
		stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
				ResultSet.CONCUR_READ_ONLY);
		stmt.executeUpdate(sql);
		conn.commit();

	}

	public void closeStmt() throws Exception {
	//	stmt.close();

	}

	public void closeConn() throws Exception {
	//	conn.close();
	}

	public static String toGBK(String str) throws Exception {
		if (str == null)
			str = "";
		else
			str = new String(str.getBytes("ISO-8859-1"), "GBK");
		return str;
	}
}