ITEEDU

3.3 第三步：编写javaBean.java

该函数封装了和数据库连接，数据库查询，修改等操作。为下边设计和编程其他页面做好基础。

package db;
import java.sql.*;
public class dbConn {
	??? String  sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	String  sConnStr = null;
	Connection conn = null;
	ResultSet  rs = null;
	public  dbConn() {
		try {
			Class.forName(sDBDriver);
		}  catch (java.lang.ClassNotFoundException e) {
			System.err.println(e.getMessage());
		}
	}
	public  ResultSet executeQuery(String sql) {
		try {
			conn = DriverManager.getConnection("jdbc:odbc:test");
			Statement stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
		}  catch (SQLException ex) {
			System.err.println(ex.getMessage());
		}
		return rs;
	}
	public  int executeUpdate(String sql) throws SQLException {
		int result = 0;
		conn = DriverManager.getConnection("jdbc:odbc:test");
		Statement stmt = conn.createStatement();
		result = stmt.executeUpdate(sql);
		return result;
	}
}