accessdb_bean.java

学生信息管理系统 java + access

/**
 访问数据库
 **/
  
 package com.javaseries.java.component;
 import java.sql.*;
 
 public class AccessDB_Bean
 {
 	String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
 	String sConnStr="jdbc:odbc:students";
 	Connection connect =null;
 	Statement stmt=null;
 	ResultSet rs=null;
 	
 	public AccessDB_Bean()
 		throws SQLException,ClassNotFoundException
 	{
 		Class.forName(sDBDriver);
 		connect=DriverManager.getConnection(sConnStr);
 		stmt =connect.createStatement();
 		/*	System.out.println("AccessDB is create over");
 			if(stmt == null)
 				System.out.println("stmt is null");
 			else
 				System.out.println("stmt is not null"); */		
 	}
 	public ResultSet executeSelect(String sql)
 		throws SQLException
 		{
 		//	System.out.println("come in executeSelect");
 			rs=null;
 		//	System.out.println("over rs=null");
 			rs=stmt.executeQuery(sql);
 		/*	System.out.println("over rs=stmt.....");
 			if(rs == null)
 				System.out.println("null");
 			else
 				System.out.println("notNull");*/
 			return rs;
 		}
 	
 	
 			
 	public void executeDML(String sql)
 		throws SQLException
 		{
 		
 			stmt.execute(sql);
 			
 		}
 }