jdbconnection.java

有待完善

package DataBase;
import java.sql.*;
public class jdbconnection {
	private final String dbDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	private final String url="jdbc:microsoft:sqlserver://localhost:1433/MyCD";
	private final String userName="sa";
	private final String password="";
	private Connection con=null;
	private Statement stmt=null;
	private ResultSet rs=null;
	
    public boolean creatConnection(){
    	try{
    		Class.forName(dbDriver).newInstance();
    		con=DriverManager.getConnection(url, userName, password);
    	}
    	catch(SQLException e){
    		System.out.println(e.getMessage());
    	}
    	catch(ClassNotFoundException ex){
    		/**@todo Handle this exception*/;
    	}
    	catch(IllegalAccessException ex){
    		/**@todo Handle this exception*/;
    	}
    	catch(InstantiationException ex){
    		/**@todo Handle this exception*/;
    	}
    	return true;
    }
    
    public boolean executeUpdate(String sql){
    	if(con==null){
    		creatConnection();
    	}
    	try{
    		stmt=con.createStatement();
    		stmt.executeUpdate(sql);
    	}
    	catch(SQLException e){
    		System.out.println(e.getMessage());
    	}
    	return true;
    }
    
	public ResultSet executeQuery(String sql){
    	try{
    		if(con==null){
    			creatConnection();
    		}
    		stmt=con.createStatement();
    		try{
    			rs=stmt.executeQuery(sql);
    		}
    		catch(SQLException e){
    			return null;
    		}
    	}
    	catch(SQLException e){
    		System.out.println(e.getMessage());
    		return null;
    	}
    	return rs;
    }
	
    public boolean commit(){
    	try{
    		con.commit();
    	}
    	catch(SQLException e){
    		System.out.println(e.getMessage());
    	}
    	return true;
    }
    
    public void closeDBConnection(){
    	if(con!=null){
    		try{
    			con.close();
    		}
    		catch(SQLException e){
    			e.printStackTrace();
        		System.out.println(e.getMessage());
        	}
    		finally{
    			con=null;
    		}
    	}
    }
}