basejdbcdao.java

Struts实现的增删改查Demo

package com.accp.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class BaseJdbcDao 
{
    //private String url="jdbc:oracle:thin:@127.0.0.1:1521:accp";  
	//private String driver="oracle.jdbc.driver.OracleDriver";
    //private String userName="system";
    //private String password="manager";

	private String driver="sun.jdbc.odbc.JdbcOdbcDriver";
	private String url="jdbc:odbc:lei";  
    public Connection conn;
    public PreparedStatement pstmt;
    public ResultSet rs;  
   //连接数据库
   public Connection getConnection()
   {
	   try 
	   {
		Class.forName(driver);
		conn = DriverManager.getConnection(url);
		return conn;
	    } 
	   catch (Exception e)
	   {
		System.out.print("数据库连接失败了");
		e.printStackTrace();
	   }   
	   return null;
   }
   
   //关闭连接
   public void closeConnection()
   {
	   if(rs!=null)
	   {
		try 
		{
			rs.close();
		} catch (SQLException e)
		{		
			e.printStackTrace();
		}   
	   }
	   if(pstmt!=null)
	   {
		try 
		{
			pstmt.close();
		} catch (SQLException e)
		{		
			e.printStackTrace();
		}   
	   }
	   if(conn!=null)
	   {
		try 
		{
			conn.close();
		} catch (SQLException e)
		{		
			e.printStackTrace();
		}   
	   }
   }

}