package?bbs.wanggan.db;
import?java.io.Reader;
import?java.io.StringReader;
import?java.sql.*;

import?org.apache.lucene.analysis.Analyzer;
import?org.apache.lucene.analysis.Token;
import?org.apache.lucene.analysis.TokenStream;
import?org.mira.lucene.analysis.IK_CAnalyzer;
public?class?DbConSql{
	
	public?Connection?getCon（）{
????????Connection?con?=?null;
	????try?{
		????	Class.forName（“com.microsoft.jdbc.sqlserver.SQLServerDriver“）;
	????}?catch?（ClassNotFoundException?e1）?{
	????		System.out.println（“驅動加載錯誤！“）;
	????		e1.printStackTrace（）;
	????}
????????
????????String?url=“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jbb“;?
???????
????????try?{
				con=?DriverManager.getConnection（url“sa““123456“）;
		}?catch?（SQLException?e）?{
				System.out.println（“數據連接錯誤！“）;
				e.printStackTrace（）;
		}
	??return?con;
	?}
				??
	
	?public??ResultSet?getQuery（String?sql）{
	?????Connection?conn=getCon（）;
		?Statement?stt=null;
		?ResultSet?rs?=?null;
		?try{
				?stt=conn.createStatement（）;
				?rs=stt.executeQuery（sql）;
		?}catch（Exception?e）{
				?e.printStackTrace（）;
		?}
		return?rs;
	??}
		?
	???
		
?????public??int?insert（String?sql）{
		?Connection?conn=getCon（）;
		?Statement?stt=null;
		?int?n=0;
		?try?{
				?conn.setAutoCommit（false）;
				?stt=conn.createStatement（）;
				?n=stt.executeUpdate（sql）;
				?conn.commit（）;
		?}?catch?（SQLException?e）?{
				?try?{
					conn.rollback（）;
				?}?catch?（SQLException?e1）?{
					e1.printStackTrace（）;
				?}
				?e.printStackTrace（）;
		?}finally{
				?try?{
					?stt.close（）;
					?conn.close（）;
				?}?catch?（SQLException?e）?{
					e.printStackTrace（）;
				?}
		??}

??????????return?n;?
	???}
?????
?????
?????public??void?delete（String[]?sql）{
		?Connection?conn=getCon（）;
		?Statement?stt=null;
		?try?{
				?conn.setAutoCommit（false）;
				?stt=conn.createStatement（）;
				?for（int?i=0;i				????stt.executeUpdate（sql[i]）;
				?}
				?conn.commit（）;
		?}?catch?（SQLException?e）?{
				?try?{
					conn.rollback（）;
				?}?catch?（SQLException?e1）?{
					e1.printStackTrace（）;
				?}
				?e.printStackTrace（）;
		?}finally{
				?try?{
					?stt.close（）;
					?conn.close（）;
				?}?catch?（SQLException?e）?{
					e.printStackTrace（）;
				?}
		??}

	???}
?????
?????
?????
?????public??int?update（String?sql）{
		?Connection?conn=getCon（）;
		?Statement?stt=null;
		?int?n=0;
		?try?{
				?conn.setAutoCommit（false）;
				?stt=conn.createStatement（）;
				?n=stt.executeUpdate（sql）;
				?conn.commit（）;
		?}?catch?（SQLException?e）?{
				?try?{
					conn.rollback（）;
				?}?catch?（SQLException?e1）?{
					e1.printStackTrace（）;
				?}
				?e.printStackTrace（）;
		?}finally{
				?try?{
					?stt.close（）;
					?conn.close（）;
				?}?catch?（SQLException?e）?{
					e.printStackTrace（）;
				?}
		??}

??????????return?n;?
	???}
?????
?????
?????
?????
?????
?????
?????

???
???}

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

?????文件????????991??2011-06-02?06:10??wanggan\.classpath

?????文件????????290??2011-06-07?01:55??wanggan\.mymetadata

?????文件???????1413??2011-06-07?01:55??wanggan\.project

?????文件????????500??2011-05-28?18:48??wanggan\.settings\.jsdtscope

?????文件????????169??2011-06-07?01:48??wanggan\.settings\org.eclipse.core.resources.prefs

?????文件????????137??2011-06-04?05:42??wanggan\.settings\org.eclipse.ltk.core.refactoring.prefs

?????文件?????????49??2011-05-28?18:48??wanggan\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2011-05-28?18:48??wanggan\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????3026??2011-06-07?01:47??wanggan\src\bbs\wanggan\db\DbConSql.java

?????文件????????438??2011-06-08?08:19??wanggan\src\bbs\wanggan\javabean\findZTZS.java

?????文件???????1205??2011-06-08?00:56??wanggan\src\bbs\wanggan\javabean\ListTie.java

?????文件????????969??2011-06-08?00:57??wanggan\src\bbs\wanggan\javabean\TieBean.java

?????文件???????2701??2011-06-08?01:00??wanggan\src\bbs\wanggan\javabean\TieManager.java

?????文件????????719??2011-06-08?02:37??wanggan\src\bbs\wanggan\javabean\UserBean.java

?????文件???????1670??2011-06-08?02:37??wanggan\src\bbs\wanggan\javabean\UserManager.java

?????文件???????1498??2011-06-07?01:48??wanggan\src\bbs\wanggan\servlet\FaTie.java

?????文件???????1817??2011-06-07?01:48??wanggan\src\bbs\wanggan\servlet\HuiTie.java

?????文件???????1416??2011-06-07?01:48??wanggan\src\bbs\wanggan\servlet\ListHuiTie.java

?????文件???????1518??2011-06-08?01:05??wanggan\src\bbs\wanggan\servlet\Login.java

?????文件???????1610??2011-06-08?02:23??wanggan\src\bbs\wanggan\servlet\Register.java

?????文件???????1846??2011-06-07?01:48??wanggan\src\bbs\wanggan\servlet\Topics.java

?????文件???????1149??2011-06-07?01:48??wanggan\src\bbs\wanggan\servlet\UpdateZT.java

?????文件???????1691??2011-06-08?01:12??wanggan\WebRoot\faTie.jsp

?????文件????????636??2011-06-06?09:42??wanggan\WebRoot\faTieCG.jsp

?????文件???????2286??2011-06-08?01:24??wanggan\WebRoot\home.jsp

?????文件????2629934??2011-06-04?05:04??wanggan\WebRoot\image\1.gif

?????文件???????3086??2011-06-08?02:49??wanggan\WebRoot\listTie.jsp

?????文件???????1483??2011-06-08?02:14??wanggan\WebRoot\login.jsp

?????文件?????????39??2008-12-14?14:51??wanggan\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1536??2011-06-08?02:29??wanggan\WebRoot\register.jsp

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