package?com.util;

import?java.sql.*;

import?javax.activation.DataSource;
import?java.sql.*;
import?javax.naming.Context;
import?javax.naming.InitialContext;

import?java.util.*;

public?class?DBO?{

	private?Connection?conn;
	private?Statement?stmt;
??	private?DataSource?ds;
	
	public?DBO（）
	{
		open（）;
	}

	/**
		打開數據庫
	*/
	public?void?open（）?
	{
		?String?driver?=?“com.mysql.jdbc.Driver“;?

		???
		????String?url?=?“jdbc:mysql://127.0.0.1:3306/jspxxjiaoliu?characterEncoding=gb2312&mysqlEncoding=gb2312“;

		????//?MySQL配置時的用戶名
		????String?user?=?“root“;?

		????//?MySQL配置時的密碼
		????String?password?=?“abc123“;?
		??
		????try?{
		????	?Class.forName（driver）;?
		????	?conn?=?DriverManager.getConnection（url?user?password）;?
	
			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?ResultSet?query（String?sql）?throws?SQLException
	{
		ResultSet?rs?=?null;
		System.out.println（sql）;

		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;
	}
	public?int?update（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（）;
	}
	public?static?void?main（String[]?args）?{
		DBO?con=?new?DBO（）;
		//con.open（）;
//		ResultSet?rs=null;
//		String?sql=“select?id?dd?from?didian“;
//		List?list=new??ArrayList（）;

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????455??2013-04-28?08:34??xxjiaoliu\.classpath

?????文件????????300??2013-04-27?21:56??xxjiaoliu\.mymetadata

?????文件???????1066??2013-04-27?21:56??xxjiaoliu\.project

?????文件????????330??2013-04-27?21:56??xxjiaoliu\.settings\org.eclipse.jdt.core.prefs

?????文件???????5489??2013-05-01?20:52??xxjiaoliu\jspxxjiaoliu.sql

?????文件????1327616??2013-05-11?20:50??xxjiaoliu\JSP家校交流系統論文.doc

?????文件???????2440??2013-04-27?22:07??xxjiaoliu\maker.sql

?????文件??????79636??2013-05-04?23:06??xxjiaoliu\pnWx.doc

?????文件????????314??2013-05-04?23:06??xxjiaoliu\pnWx.files\colorschememapping.xml

?????文件????????236??2013-05-04?23:06??xxjiaoliu\pnWx.files\filelist.xml

?????文件???????1717??2013-05-04?23:06??xxjiaoliu\pnWx.files\header.htm

?????文件???????3087??2013-05-04?23:06??xxjiaoliu\pnWx.files\themedata.thmx

?????文件???????6355??2013-04-27?23:13??xxjiaoliu\pnWx.xls

?????文件???????3283??2013-04-28?08:35??xxjiaoliu\src\com\util\DBO.java

?????文件???????1484??2012-02-28?20:09??xxjiaoliu\src\com\util\StaticMethod.java

?????文件???????1469??2010-04-08?21:31??xxjiaoliu\WebRoot\admin_top.html

?????文件???????4680??2013-04-29?13:35??xxjiaoliu\WebRoot\chengji\chengjiadd.jsp

?????文件????????820??2013-04-29?13:35??xxjiaoliu\WebRoot\chengji\chengjidelete.jsp

?????文件???????4680??2013-04-29?13:35??xxjiaoliu\WebRoot\chengji\chengjidetail.jsp

?????文件???????1046??2013-04-29?13:35??xxjiaoliu\WebRoot\chengji\chengjido.jsp

?????文件???????4838??2013-04-29?13:35??xxjiaoliu\WebRoot\chengji\chengjilist.jsp

?????文件???????1932??2013-04-29?13:31??xxjiaoliu\WebRoot\chengji\chengjimodify.jsp

?????文件???????5264??2013-04-29?13:35??xxjiaoliu\WebRoot\chengji\chengjiupdate.jsp

?????文件???????1116??2013-04-29?13:35??xxjiaoliu\WebRoot\chengji\chengji_update.jsp

?????文件???????4592??2013-04-28?11:21??xxjiaoliu\WebRoot\chengji\mylist.jsp

?????文件????????253??2010-04-23?11:02??xxjiaoliu\WebRoot\images\!.gif

?????文件???????1705??2010-04-23?11:02??xxjiaoliu\WebRoot\images\ad.gif

?????文件????????606??2010-04-23?11:02??xxjiaoliu\WebRoot\images\add.gif

?????文件????????213??2010-04-23?11:02??xxjiaoliu\WebRoot\images\back.gif

?????文件?????????73??2010-04-23?11:02??xxjiaoliu\WebRoot\images\bg.gif

............此處省略249個文件信息