package?com.myProject.baidu;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.text.SimpleDateFormat;
import?java.util.Date;
import?java.util.List;

import?javax.servlet.jsp.jstl.sql.Result;
import?javax.servlet.jsp.jstl.sql.ResultSupport;



/**
?*?數(shù)據(jù)訪問公共類
?*?
?*?@author?韓析木
?*?
?*/
public?class?baseDao?{

	//?連接MSSQL?2005
	public?final?static?String?DRIVER?=?“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	public?final?static?String?URL?=?“jdbc:sqlserver://localhost:1433;DatabaseName=MyBaiDu“;
	public?final?static?String?DBNAME?=?“sa“;
	public?final?static?String?DBPASS?=?“sa“;

	
	?//?連接mysql5.0?
	??//public?final?static?String?DRIVER?=?“org.gjt.mm.mysql.Driver“;
	?//public?final?static?String?URL?=
	?//?“jdbc:mysql://localhost/workmanage?user=root&password=root&useUnicode=true&characterEncoding=gbk“;

	//?連接acces2003
	//?public?final?static?String?DRIVER?=?“sun.jdbc.odbc.JdbcOdbcDriver“;
	//?public?final?static?String?URL?=
	//?“jdbc:odbc:driver={Microsoft?Access?Driver?（*.mdb）};DBQ=D:\\Myeclipse\\Workspace\\accessDB\\passengerTicketingSystem.mdb“;
	//?常用變量
	private?Connection?executeConn?=?null;
	private?PreparedStatement?executePstmt?=?null;
	private?ResultSet?executeRes?=?null;
	private?int?result?=?0;

	/**
	?*?獲取連接
	?*?
	?*?@return
	?*/
	public?static?Connection?getConnection（）?{
		Connection?con?=?null;
		try?{
			Class.forName（DRIVER）;
			con?=?DriverManager.getConnection（URLDBNAMEDBPASS）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e1）?{
			e1.printStackTrace（）;
		}
		return?con;
	}

	/**
	?*?關閉
	?*?
	?*?@param?rs
	?*?@param?ps
	?*?@param?con
	?*/
	public?static?void?closeAll（ResultSet?rs?PreparedStatement?ps
			Connection?con）?{
		if?（rs?!=?null）?{
			try?{
				rs.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		if?（ps?!=?null）?{
			try?{
				ps.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		if?（con?!=?null）?{
			try?{
				con.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
	}

	/**
	?*?執(zhí)行sql語句，返回受影響的行數(shù)或者最新插入的自增列
	?*?
	?*?@param?sql
	?*?@param?paramList
	?*?@return?int
	?*/
	public??int?getAffectRow（String?sql?Listject>?paramsList）?{
		try?{
			executeConn?=?getConnection（）;//?獲得連接
			executePstmt?=?executeConn.prepareStatement（sql）;
			useParam（paramsList）;//?使用參數(shù)
			if?（sql.indexOf（“;“）?!=?-1）?{//?需要返回最新插入的自增列
				executeRes?=?executePstmt.executeQuery（）;
				if?（executeRes.next（））?{
					result?=?executeRes.getInt（1）;//?返回最新插入的自增列
				}
			}?else?{
				result?=?executePstmt.executeUpdate（）;//?返回受影響的行數(shù)
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?finally?{
			closeAll（executeRes?executePstmt?executeConn）;
		}
		retur

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

?????文件???????1485??2013-01-05?19:57??WebRoot\about.jsp

?????文件???????4242??2012-12-26?09:09??WebRoot\css\css.css

?????文件????????290??2012-12-24?15:59??WebRoot\images\bg_1.gif

?????文件????????169??2012-12-24?15:59??WebRoot\images\bg_2.gif

?????文件????????149??2012-12-24?15:59??WebRoot\images\bg_3.gif

?????文件????????676??2012-12-24?15:59??WebRoot\images\bg_6.gif

?????文件????????751??2012-12-24?15:59??WebRoot\images\bg_7.gif

?????文件????????305??2012-12-24?15:59??WebRoot\images\bg_8.gif

?????文件?????????50??2012-12-24?15:59??WebRoot\images\dian.gif

?????文件?????????50??2012-12-24?15:59??WebRoot\images\dian_2.gif

?????文件????????607??2012-12-24?15:59??WebRoot\images\i-1_0_0.png

?????文件???????5693??2012-12-24?15:59??WebRoot\images\img_1.gif

?????文件?????????54??2012-12-24?15:59??WebRoot\images\img_10.gif

?????文件?????????82??2012-12-24?15:59??WebRoot\images\img_11.gif

?????文件?????????91??2012-12-24?15:59??WebRoot\images\img_12.gif

?????文件????????172??2012-12-24?15:59??WebRoot\images\img_13.gif

?????文件????????117??2012-12-24?15:59??WebRoot\images\img_14.gif

?????文件??????58350??2012-12-24?15:59??WebRoot\images\img_2.gif

?????文件???????1284??2012-12-24?15:59??WebRoot\images\img_8.gif

?????文件???????1139??2012-12-24?15:59??WebRoot\images\img_9.gif

?????文件????????111??2012-12-24?15:59??WebRoot\images\more.gif

?????文件????????905??2012-12-24?15:59??WebRoot\images\title_3.gif

?????文件???????2647??2013-01-05?19:36??WebRoot\index.jsp

?????文件????????971??2012-12-24?15:59??WebRoot\js\meun.js

?????文件???????5947??2013-01-05?20:59??WebRoot\list.jsp

?????文件???????5047??2013-01-05?19:57??WebRoot\listen.jsp

?????文件?????????36??2012-12-20?10:11??WebRoot\meta-INF\MANIFEST.MF

?????文件???????4619??2013-01-05?19:07??WebRoot\WEB-INF\classes\com\myProject\baidu\baseDao.class

?????文件???????3245??2013-01-05?19:07??WebRoot\WEB-INF\classes\com\myProject\baidu\CommonMethod.class

?????文件???????2863??2013-01-05?19:07??WebRoot\WEB-INF\classes\com\myProject\baidu\SearchCrawler$ImgDownThread.class

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