datadaoimpl.java

一个网吧登录系统

package com.hotdon.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.hotdon.mem.dataDAO;

public class dataDAOImpl implements dataDAO{
	private String sDBDrive="sun.jdbc.odbc.JdbcOdbcDriver";
	private String sConnStr="jdbc:odbc:Access";
	private Connection conn=null;
	private Statement sqlStamt=null;
	ResultSet rs=null; 
	public dataDAOImpl(){
		try{
			Class.forName(sDBDrive);
		}
		catch(Exception e){
			System.err.println(""+e.getMessage());
		}
	}
	public ResultSet getData(String strSql)throws SQLException{
		try{
			conn=DriverManager.getConnection(sConnStr);
			sqlStamt=conn.createStatement();
			rs=sqlStamt.executeQuery(strSql);
			
		}
		catch(SQLException ex){
			throw new SQLException(ex.toString());
			
		}
		return rs;
	}
	public void updateData(String strSql)throws SQLException{
		try{
			conn=DriverManager.getConnection(sConnStr);
		    sqlStamt=conn.createStatement();
		    sqlStamt.executeUpdate(strSql);
		    	
		}
		catch (SQLException ex){
			throw new SQLException(ex.toString());
		}
	}
	public void close() throws SQLException{
		try{
			sqlStamt.close();
			conn.close();
			
		}
		catch(SQLException e){
			e.printStackTrace();
		}
	}	
}