package?adms.conn;

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

public?class?baseDao?{
	public?final?static?String?DRIVER?=?“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
	public?final?static?String?URL?=?“jdbc:sqlserver://localhost:1433;databaseName=demo“;
	public?final?static?String?UNAME?=?“sa“;
	public?final?static?String?UPASS?=?“sa“;
	
	public?Connection?getConn（）{
	
	Connection?conn?=?null;
	try?{
	Class.forName（DRIVER）;
	conn?=?DriverManager.getConnection（URLUNAMEUPASS）;
	
	}?catch?（ClassNotFoundException?e）?{
	System.out.println（“注冊驅動異常.“）;
	e.printStackTrace（）;
	
	}?catch?（SQLException?e）?{
	
	System.out.println（“連接數據庫異常.“）;
	e.printStackTrace（）;
	}
	return?conn;
	}
	
	/**
	?*?關閉數據庫連接
	?*/
	public?void?closeAll（Connection?connPreparedStatement?psmtResultSet?rs）{
	
	try?{
	if（rs!=null）{
	rs.close（）;
	}
	if（psmt!=null）{
	psmt.close（）;
	}
	if（conn!=null）{
	conn.close（）;
	}
	}?catch?（SQLException?e）?{
	e.printStackTrace（）;
	}
	}
	/**
	?*?增/刪/改?的方法
	?*/
	public?int?executeSQL（String?sqlobject[]?getValues）{
	
	int?result?=?0;//?結果集
	Connection?conn?=?null;
	PreparedStatement?psmt?=?null;
	
	try?{
	
	conn?=?getConn（）;//?獲取數據庫連接
	psmt?=?conn.prepareStatement（sql）;?//?傳過來的SQL語句
	
	if（getValues!=null）{
	
	for?（int?i?=?0;?i?		
	psmt.setobject（i+1?getValues[i]）;
	
	}
	}
	result?=?psmt.executeUpdate（）;//?執行sql語句
	}?catch?（Exception?e）?{
	System.out.println（“executeSQL方法異常.“）;
	e.printStackTrace（）;
	}finally{
		this.closeAll（conn?psmt?null）;
	}
	return?result;
	}
	public?ResultSet?execiutQuery（String?sqlString[]?getValues）{
		ResultSet?rs=null;
		Connection?conn?=?null;
		PreparedStatement?psmt?=?null;
		try?{
			conn=this.getConn（）;
			psmt=conn.prepareStatement（sql）;?
			if（getValues!=null）{
				for（int?i=0;i					psmt.setString（i+1?getValues[i]）;
				}
			}
			rs=psmt.executeQuery（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?rs;
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-02-19?16:55??demo\
?????文件????????1267??2013-02-19?16:55??demo\.classpath
?????目錄???????????0??2013-02-28?09:12??demo\.myeclipse\
?????文件?????????285??2013-02-25?10:28??demo\.mymetadata
?????文件?????????240??2013-02-19?16:55??demo\.mystrutsdata
?????文件????????1493??2013-02-19?16:55??demo\.project
?????目錄???????????0??2013-02-16?09:33??demo\.settings\
?????文件?????????500??2013-02-16?09:33??demo\.settings\.jsdtscope
?????文件?????????330??2013-02-16?09:33??demo\.settings\org.eclipse.jdt.core.prefs
?????文件??????????49??2013-02-16?09:33??demo\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2013-02-16?09:33??demo\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2013-02-26?10:49??demo\WebRoot\
?????目錄???????????0??2013-02-16?09:33??demo\WebRoot\meta-INF\
?????文件??????????36??2013-02-16?09:33??demo\WebRoot\meta-INF\MANIFEST.MF
?????文件????????1021??2013-02-27?11:44??demo\WebRoot\Vote.jsp
?????目錄???????????0??2013-02-16?09:33??demo\WebRoot\WEB-INF\
?????目錄???????????0??2013-02-26?09:08??demo\WebRoot\WEB-INF\classes\
?????目錄???????????0??2013-02-26?09:08??demo\WebRoot\WEB-INF\classes\adms\
?????目錄???????????0??2013-02-26?09:08??demo\WebRoot\WEB-INF\classes\adms\conn\
?????文件????????2938??2013-02-26?09:08??demo\WebRoot\WEB-INF\classes\adms\conn\baseDao.class
?????目錄???????????0??2013-02-26?09:08??demo\WebRoot\WEB-INF\classes\adms\dao\
?????文件????????4373??2013-02-26?09:08??demo\WebRoot\WEB-INF\classes\adms\dao\NewsDao.class
?????文件????????1999??2013-02-26?09:08??demo\WebRoot\WEB-INF\classes\adms\dao\VoteDao.class
?????目錄???????????0??2013-02-26?09:08??demo\WebRoot\WEB-INF\classes\adms\dao\impl\
?????文件?????????398??2013-02-26?09:08??demo\WebRoot\WEB-INF\classes\adms\dao\impl\NewsDaoImpl.class
?????文件?????????278??2013-02-26?09:08??demo\WebRoot\WEB-INF\classes\adms\dao\impl\VoteDaoImpl.class
?????目錄???????????0??2013-02-26?09:08??demo\WebRoot\WEB-INF\classes\adms\pro\
?????文件????????1071??2013-02-26?09:08??demo\WebRoot\WEB-INF\classes\adms\pro\News.class
?????文件?????????922??2013-02-26?09:08??demo\WebRoot\WEB-INF\classes\adms\pro\Vote.class
?????目錄???????????0??2013-02-26?09:08??demo\WebRoot\WEB-INF\classes\adms\servlet\
?????文件????????2601??2013-02-26?09:08??demo\WebRoot\WEB-INF\classes\adms\servlet\addNews.class
............此處省略83個文件信息