bean.java

来自「JSP自动出卷系统,界面简单,功能还需要进一步扩展」· Java 代码 · 共 44 行

package xyf;
import java.sql.*;
public class bean {
	String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	String sConnStr="jdbc:odbc:xyf";
	Connection connect=null;
	ResultSet rs=null;
	public bean(){
		try{
			Class.forName(sDBDriver);
		}
		catch(java.lang.ClassNotFoundException e){
			System.err.println(e.getMessage());
		}
	}
	public ResultSet executeQuery(String sql){
		try{
			connect=DriverManager.getConnection(sConnStr);
			Statement stmt=connect.createStatement();
			rs=stmt.executeQuery(sql);
		}
		catch(SQLException ex){
			System.err.println(ex.getMessage());
		}
		return rs;
	}
	public boolean executeUpdate(String sql){
		try{
			connect=DriverManager.getConnection(sConnStr);
			Statement stmt=connect.createStatement();
			stmt.executeUpdate(sql);
			return true;
		}
		catch(SQLException e1){
			System.err.println(e1.getMessage());
			return false;
		}
		
	}


}