datadaoimpl.java

学生选课系统-java做的学生选课系统

package com.hotdon.men;

import java.sql.*;

import javax.swing.JOptionPane;

import com.hotdon.men.dataDAO;

public class dataDAOImpl implements dataDAO {
    private String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
    private String sConnStr="jdbc:odbc:StudentMSDB";
    private Connection conn=null;
    private Statement sqlStamt=null;
    ResultSet rs=null;
    public dataDAOImpl(){
       try{
    		Class.forName(sDBDriver);
    	}catch(Exception e){
    		System.err.println(""+e.getMessage());
    	}
    }
	public void close() throws SQLException {	
        try{
        	sqlStamt.close();
        	conn.close();
        }catch(SQLException e){
        	e.printStackTrace();
        }
	}

	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 {
		// TODO Auto-generated method stub
        int iResult;
		try{
        	conn=DriverManager.getConnection(sConnStr);
			conn.setAutoCommit(true);
        	//sqlStamt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);			
			sqlStamt=conn.createStatement();
			iResult=sqlStamt.executeUpdate(strSql);
		   //conn.commit();
			//System.out.println(iResult);
		    close(); //注意一定要关闭，否则不能够“真正”保持到数据库中！	
        }catch(SQLException ex){        	
			throw new SQLException(ex.toString());
			
		}
	}

	/**
	 * @param args
	 */
	

}