dbconn.java

来自「JSP初级入门程序」· Java 代码 · 共 63 行

package reg;

import java.sql.*;
public class dbconn{
	String sDBDriver="sun.odbc.JdbcOdbcDriver";
	String sConnStr="jdbc:odbc:reg";
	Connection conn=null;
	ResultSet rs=null;
	int result;
	Statement stmt=null;
	
	public dbconn(){
		try{
			Class.forName(sDBDriver);
		}catch(java.lang.ClassNotFoundException e){
			System.err.println("Class dbconnect not found!"+e.getMessage());
			
		}
	}
	
	public ResultSet query(String sql){
		try{
			conn=DriverManager.getConnection(sConnStr);
			stmt=conn.createStatement();
			rs=stmt.executeQuery(sql);
			System.out.println(sql);
			System.out.println("ok 1");
			
		}catch(SQLException ex){
			System.err.println(ex.getMessage());
		}
		System.out.println("ok 2");
		return rs;
	}
	public void executeUpdate(String sql){
		rs=null;
		try{
			conn=DriverManager.getConnection(sConnStr);
			stmt=conn.createStatement();
			result=stmt.executeUpdate(sql);
		}catch(SQLException ex){
			System.err.println(ex.getMessage());
		}
		finally{
			if(stmt!=null){
				try{
					stmt.close();
					stmt=null;
				}catch(SQLException ex){
					System.err.println(ex.getMessage());
				}
			}
			if(conn!=null){
				try{
				conn.close();
				conn=null;
			    }catch(SQLException ex){
				    System.err.println(ex.getMessage());
				}
			}
		}
	}
}