package?db;
import?java.sql.*;

public?class?db?{
	
	private?String?dbDriver=“com.mysql.jdbc.Driver“;

	private?String?sConnStr?=?“jdbc:mysql://localhost:3306/lvxingshe?useUnicode=true&characterEncoding=gb2312“;?
	?
	//private?String?dbDriver=“com.microsoft.sqlserver.jdbc.SQLServerDriver“;//sql2005?????
//??private?String?sConnStr?=?“jdbc:sqlserver://localhost:1433;databaseName=jspmodule“;?//sql2005?
?//?private?String?dbDriver=“com.microsoft.jdbc.sqlserver.SQLServerDriver“;//sql2000
//	?private?String?sConnStr?=?“jdbc:microsoft:sqlserver://localhost:1433;databasename=jspmodule“;?//sql2000
	?
	?
	??public?Connection?connect?=?null;
	??public?ResultSet?rs=null;
	??public?db（）?{
	????try?{
	?????
	??????Class.forName（dbDriver）.newInstance（）;?
	?????
	??????connect?=?DriverManager.getConnection（sConnStr“root““root“）;?
	?????
	????}
	????catch?（Exception?ex）?{
	??????System.out.println（“12121“）;
	????}
	??}
	
	??
	??public?ResultSet?executeQuery（String?sql）?{
			try{
				connect=DriverManager.getConnection（sConnStr“root““root“）;
				Statement?stmt=connect.createStatement（）;
				rs=stmt.executeQuery（sql）;
			}catch（SQLException?ex）{
				System.err.println（ex.getMessage（））;
			}
			return?rs;
		}
	??public?void?executeUpdate（String?sql）
	????{
	????	
	????	Statement?stmt=null;
	????	rs=null;
	????	try
	????	{???connect=DriverManager.getConnection（sConnStr“root““root“）;
	????		stmt=connect.createStatement（）;
	????		stmt.executeUpdate（sql）;
	????		stmt.close（）;
	????		connect.close（）;
	????		
	????	
	????	}
	????	catch（SQLException?ex）
	????	{
	????		System.err.println（ex.getMessage（））;
	????		
	????		
	????	}
	????
	????	
	????}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-07-20?18:59??jsp121光明旅行社網(wǎng)站mysql\
?????目錄???????????0??2017-07-20?18:57??jsp121光明旅行社網(wǎng)站mysql\數(shù)據(jù)庫(kù)\
?????文件???????28069??2016-04-08?00:43??jsp121光明旅行社網(wǎng)站mysql\數(shù)據(jù)庫(kù)\lvxingshe.sql
?????目錄???????????0??2017-07-20?18:57??jsp121光明旅行社網(wǎng)站mysql\程序\
?????文件?????????673??2016-04-06?15:25??jsp121光明旅行社網(wǎng)站mysql\程序\.classpath
?????文件?????????300??2016-04-05?01:58??jsp121光明旅行社網(wǎng)站mysql\程序\.mymetadata
?????文件????????1415??2016-04-05?04:56??jsp121光明旅行社網(wǎng)站mysql\程序\.project
?????目錄???????????0??2017-07-20?18:57??jsp121光明旅行社網(wǎng)站mysql\程序\.settings\
?????文件?????????500??2016-04-05?20:07??jsp121光明旅行社網(wǎng)站mysql\程序\.settings\.jsdtscope
?????文件??????????49??2016-04-08?00:53??jsp121光明旅行社網(wǎng)站mysql\程序\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-04-06?13:02??jsp121光明旅行社網(wǎng)站mysql\程序\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-07-20?18:57??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\
?????文件????????2140??2016-04-05?22:35??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\CSS.css
?????目錄???????????0??2017-07-20?18:57??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\meta-INF\
?????文件??????????39??2016-04-05?09:15??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2017-07-20?18:57??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\WEB-INF\
?????目錄???????????0??2017-07-20?18:57??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\WEB-INF\classes\
?????目錄???????????0??2017-07-20?18:57??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\WEB-INF\classes\db\
?????文件????????1991??2016-04-05?17:06??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\WEB-INF\classes\db\db.class
?????目錄???????????0??2017-07-20?18:57??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\WEB-INF\lib\
?????文件???????14334??2016-04-04?09:26??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\WEB-INF\lib\jspsmartupload.jar
?????文件??????284752??2016-04-07?15:16??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\WEB-INF\lib\msbase.jar
?????文件???????64856??2016-04-06?18:07??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\WEB-INF\lib\mssqlserver.jar
?????文件???????59865??2016-04-06?18:17??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\WEB-INF\lib\msutil.jar
?????文件??????495944??2016-04-06?01:58??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\WEB-INF\lib\mysql-connector-java-5.0.4-bin.jar
?????文件??????583286??2016-04-07?06:28??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\WEB-INF\lib\sqljdbc.jar
?????文件??????422699??2016-04-08?04:47??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\WEB-INF\lib\sqljdbc4.jar
?????文件?????????284??2016-04-06?17:40??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\WEB-INF\web.xml
?????目錄???????????0??2017-07-20?18:59??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\admin\
?????文件????????7328??2017-07-20?18:59??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\admin\login.jsp
?????文件????????3969??2016-04-08?04:27??jsp121光明旅行社網(wǎng)站mysql\程序\WebRoot\dx_detail.jsp
............此處省略59個(gè)文件信息