www.pudn.com > NewsAssurance.rar > BaseDAO.java

package com.newsassurace.dao; 
 
import java.sql.*; 
 
public class BaseDAO { 
	private Connection con=null; 
	private Statement st=null; 
	private ResultSet rs=null; 
	 
	public Connection openConnection() 
	{ 
		try { 
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
			 
	    } 
	    catch (ClassNotFoundException ex) { 
	    	System.out.println ("找不到驱动"); 
	    	ex.printStackTrace(); 
	    } 
	     
	    try { 
	    	con=DriverManager.getConnection("jdbc:odbc:accp"); 
	    } 
	    catch (Exception ex) { 
	    	System.out.println ("打不开连接"); 
	    	ex.printStackTrace(); 
	    } 
	    return con; 
	} 
	 
	public void closeConnection(Connection con,Statement st,ResultSet rs) 
	{ 
		if(rs!=null) 
		{ 
			try { 
				rs.close(); 
		    } 
		    catch (Exception ex) { 
		    	System.out.println ("rs关闭异常"); 
		    	ex.printStackTrace(); 
		    } 
		} 
		 
		if(st!=null) 
		{ 
			try { 
				st.close(); 
		    } 
		    catch (Exception ex) { 
		    	System.out.println ("st关闭异常"); 
		    	ex.printStackTrace(); 
		    } 
		} 
		 
		if(con!=null) 
		{ 
			try { 
				con.close(); 
		    } 
		    catch (Exception ex) { 
		    	System.out.println ("con关闭异常"); 
		    	ex.printStackTrace(); 
		    } 
		} 
	} 
	 
	public ResultSet executeQuery(String sql) 
	{ 
		try { 
			st=con.createStatement(); 
			rs=st.executeQuery(sql); 
	    } 
	    catch (Exception ex) { 
	    	System.out.println ("查询"+sql+"失败"); 
	    	ex.printStackTrace(); 
	    } 
	    return rs; 
	} 
	 
	public boolean executeUpdate(String sql) 
	{ 
		try { 
			st=con.createStatement(); 
			st.executeUpdate(sql); 
			return true; 
	    } 
	    catch (Exception ex) { 
	    	System.out.println ("更新"+sql+"失败"); 
	    	ex.printStackTrace(); 
	    } 
	    return false; 
	} 
}