dbmanager.java

基于J2EE的门诊划价系统 目 录 第1章 绪论 1 1.1 引言 1 1.2 概述 2 1.2.1 简要概述 2 1.2.2 目标 3 1.2.3 条件或限制 3 1.3 J2EE

package MyWeb.db;

import java.sql.Connection;
import javax.sql.DataSource;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DBManager {
	 private Connection con = null;
	    private Statement stmt = null;
	    private ResultSet rs = null;
	    private DataSource ds;
	    public void init()
	    {
	        try
	        {
	        	Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
	            //加载驱动程序
	            con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=HospitalNT","sa","");
	            //创建连接
	        }catch(Exception e){}
	    }
	 
	    //获取连接
	    public Connection getConnection()
	    {
	        if(con == null)
	           init();
	        return con;
	    }
	    
	    //执行有结果集的查询
	    public int executeUpdate(String sql) throws SQLException
	    {
	        stmt = getConnection().createStatement();
	        return stmt.executeUpdate(sql);
	    }
	    public ResultSet executeQuery(String sql) throws SQLException
	    {  
	    	
	        stmt = getConnection().createStatement();
	        return stmt.executeQuery(sql);
	    }
	    
	    public void close()
	    {
	        if(rs!=null)
	            try {
	                rs.close();
	            } catch (SQLException e) {          }
	        if(stmt!=null)
	            try {
	                stmt.close();
	            } catch (SQLException e) {          }
	        if(con!=null)
	            try {
	                con.close();
	            } catch (SQLException e) {          }
	 
	    }
	    
}