package?bean;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

public?class?DBO?{
	private?Connection?conn;
	private?Statement?stmt;
	
	public?DBO（）
	{
	}

	/**
		打開數據庫
	*/
	public?void?open（）?
	{
		try?
		{
			//Class.forName（“sun.jdbc.odbc.jdbcodbcdriver“）;
			Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;???//加載數據庫驅動?//JDBC連接方式????????
			conn?=?DriverManager.getConnection（“jdbc:sqlserver://localhost:1433;databasename=JSPJFGL““sa““123“）;
			//conn?=?DriverManager.getConnection（“jdbc:odbc:aaa“）;
				stmt=conn.createStatement（）;
			System.out.println（“打開數據庫連接“）;
		}?
		catch?（Exception?ex）?
		{
		System.err.println（“打開數據庫時出錯:?“?+?ex.getMessage（））;
		}
	}

	/**
		關閉數據庫，將連接返還給連接池
	*/
	public?void?close（）?
	{
		try?
		{
		
				
		//	connMgr.freeConnection（“java“?conn）;
			conn.close（）;
			System.out.println?（“釋放連接“）;
		}?
		catch?（SQLException?ex）?
		{
			System.err.println（“返還連接池出錯:?“?+?ex.getMessage（））;
		}
	}

	/**
		執行查詢
	*/
	public?ResultSet?executeQuery（String?sql）?throws?SQLException
	{
		ResultSet?rs?=?null;
		

		rs?=?stmt.executeQuery（sql）;
		System.out.println?（“執行查詢“）;
		return?rs;
	}

	/**
		執行增刪改
	*/
	public?int?executeUpdate（String?sql）?throws?SQLException
	{
		int?ret?=?0;
		
	
		ret?=?stmt.executeUpdate（sql）;
	
		System.out.println?（“執行增刪改“）;
		return?ret;
	}

	/**
		將SQL語句加入到批處理
	*/
	public?void?addBatch（String?sql）?throws?SQLException?
	{
		stmt.addBatch（sql）;
	}

	/**
		執行批處理
	*/
	public?int?[]?executeBatch（）?throws?SQLException?
	{
		boolean?isAuto=conn.getAutoCommit（）;
		
		conn.setAutoCommit（false）;
		int?[]?updateCounts?=?stmt.executeBatch（）;
		
//		conn.commit（）;
		
//		conn.setAutoCommit（isAuto）;
		//conn.setAutoCommit（true）;
		return?updateCounts;
	}
	public?boolean?getAutoCommit（）?throws?SQLException
	{
		return?conn.getAutoCommit（）;
	}
	public?void?setAutoCommit（boolean?auto）??throws?SQLException?
	{
		conn.setAutoCommit（auto）;
	}
	
	public?void?commit（）?throws?SQLException?
	{
		conn.commit（）;
//		this.close（）;
	}
	public?void?rollBack（）?throws?SQLException?
	{
		conn.rollback（）;
//		this.close（）;
	}
	
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-01-10?13:25??JSP7?機房管理系統\
?????目錄???????????0??2014-01-10?13:10??JSP7?機房管理系統\JSPJFGL\
?????文件?????????340??2008-05-25?13:44??JSP7?機房管理系統\JSPJFGL\.classpath
?????目錄???????????0??2014-01-11?09:49??JSP7?機房管理系統\JSPJFGL\.myeclipse\
?????文件?????????294??2013-04-07?09:26??JSP7?機房管理系統\JSPJFGL\.mymetadata
?????文件????????1225??2008-05-25?13:44??JSP7?機房管理系統\JSPJFGL\.project
?????目錄???????????0??2014-01-10?14:47??JSP7?機房管理系統\JSPJFGL\WebRoot\
?????目錄???????????0??2014-01-10?13:10??JSP7?機房管理系統\JSPJFGL\WebRoot\meta-INF\
?????文件??????????39??2008-05-25?13:44??JSP7?機房管理系統\JSPJFGL\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2014-01-10?13:10??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\
?????目錄???????????0??2014-01-10?13:10??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\classes\
?????目錄???????????0??2014-01-10?13:10??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\classes\bean\
?????文件????????3683??2013-04-07?09:26??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\classes\bean\AddManager.class
?????文件????????5001??2013-04-07?09:26??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\classes\bean\Collage.class
?????文件????????7880??2013-04-07?09:26??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\classes\bean\CollageBean.class
?????文件????????2899??2013-04-07?09:26??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\classes\bean\DBO.class
?????文件????????2368??2013-04-07?09:26??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\classes\bean\Login.class
?????文件????????6971??2013-04-07?09:26??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\classes\bean\LoginBean.class
?????文件????????1401??2013-04-07?09:26??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\classes\bean\LoginOut.class
?????文件????????3594??2013-04-07?09:26??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\classes\bean\Machine.class
?????文件???????12738??2013-04-07?09:26??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\classes\bean\MachineBean.class
?????文件????????4634??2013-04-07?09:26??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\classes\bean\ZhiBan.class
?????目錄???????????0??2014-01-10?13:10??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\lib\
?????文件??????286707??2002-11-21?16:40??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\lib\msbase.jar
?????文件???????67024??2002-11-21?16:40??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\lib\mssqlserver.jar
?????文件???????58903??2002-11-21?16:40??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\lib\msutil.jar
?????文件??????540852??2007-10-05?05:11??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\lib\mysql-connector-java-5.0.8-bin.jar
?????文件??????583286??2012-04-01?23:34??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\lib\sqljdbc.jar
?????文件????????5557??2008-05-25?13:44??JSP7?機房管理系統\JSPJFGL\WebRoot\WEB-INF\web.xml
?????目錄???????????0??2014-01-10?14:47??JSP7?機房管理系統\JSPJFGL\WebRoot\admin\
?????文件????????9520??2008-05-25?13:44??JSP7?機房管理系統\JSPJFGL\WebRoot\admin\addManager.jsp
............此處省略148個文件信息