basedao.java

用myeclipse编写的一个简单新闻发布

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;
	}
}