package?com.accp800.dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Timestamp;
import?java.util.ArrayList;
import?java.util.List;

import?com.microsoft.sqlserver.jdbc.SQLServerDriver;

public?class?BasicDao?{

	public?Connection?getConnection（）?throws?SQLException?{
		DriverManager.registerDriver（new?SQLServerDriver（））;
		conn?=?DriverManager.getConnection（URL?USER?PASSWORD）;
		?
		return?conn;
	}
	
	public?long?count（String?sql?object...?args）?throws?SQLException?{
		try?{
			getConnection（）;
			ResultSet?rs?=?executeQuery（sql?args）;
			if（rs.next（））?{
				return?rs.getLong（1）;
			}
				
			return?0;
		}?finally?{
			close（）;
		}
	}
	
	public?T?findById（String?sql?RowMapper?mapper?object?id）?throws?SQLException?{
		try?{
			getConnection（）;
			ResultSet?rs?=?executeQuery（sql?id）;
			if（rs.next（））?{
				return?mapper.mapRow（rs）;
			}?else?{
				return?null;
			}
		}?finally?{
			close（）;
		}
	}
	
	public?List?find（String?sql?RowMapper?mapper?object...?args）?throws?SQLException?{
		List?list?=?new?ArrayList（）;
		try?{
			getConnection（）;
			ResultSet?rs?=?executeQuery（sql?args）;
			while（rs.next（））?{
				list.add（mapper.mapRow（rs））;
			}
			
			return?list;
		}?finally?{
			close（）;
		}
	}
	
	public?ResultSet?executeQuery（String?sql?object...?args）?throws?SQLException?{
		setPreparedStatement（sql?args）;
		return?ps.executeQuery（）;
	}
	
	public?int?executeUpdate（String?sql?object...?args）?throws?SQLException?{
		try?{
			getConnection（）;
			setPreparedStatement（sql?args）;
			
			return?ps.executeUpdate（）;
		}?finally?{
			close（）;
		}
	}

	private?void?setPreparedStatement（String?sql?object...?args）
			throws?SQLException?{
		ps?=?conn.prepareStatement（sql）;
		
		for（int?i?=?0;?i?			if（args[i]?instanceof?String）?{
				ps.setString（i?+?1?（String）?args[i]）;
			}?else?if（args[i]?instanceof?Integer）?{
				ps.setInt（i?+?1?（Integer）?args[i]）;
			}?else?if（args[i]?instanceof?Double）?{
				ps.setDouble（i?+?1?（Double）?args[i]）;
			}?else?if（args[i]?instanceof?Timestamp）?{
				ps.setTimestamp（i?+?1?（Timestamp）?args[i]）;
			}?else?{
				ps.setobject（i?+?1?args[i]）;
			}
		}
	}
	
	public?void?close（）?throws?SQLException?{
		if（conn?!=?null）?{
			conn.close（）;
		}
	}
	
	
	
	private?Connection?conn;
	private?PreparedStatement?ps;
	public?static?final?String?DATAbase?=?“bbs“;
	public?static?final?String?USER?=?“sa“;
	public?static?final?String?PASSWORD?=?“123“;
	public?static?final?String?URL?=?“jdbc:sqlserver://localhost:1433;databaseName=“?+?DATAbase;
	
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????424??2010-04-29?14:16??jspbbs\.classpath

?????文件????????287??2010-07-29?13:18??jspbbs\.mymetadata

?????文件???????1412??2010-04-20?14:12??jspbbs\.project

?????文件????????496??2010-04-20?13:58??jspbbs\.settings\.jsdtscope

?????文件????????336??2010-04-20?13:58??jspbbs\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2010-04-20?13:58??jspbbs\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2010-04-20?13:58??jspbbs\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2786??2010-04-29?15:00??jspbbs\src\com\accp800\dao\BasicDao.java

?????文件???????1307??2010-05-04?17:14??jspbbs\src\com\accp800\dao\BoardDao.java

?????文件????????369??2010-04-23?17:05??jspbbs\src\com\accp800\dao\ITopicDao.java

?????文件???????1419??2010-07-29?13:25??jspbbs\src\com\accp800\dao\MessageDao.java

?????文件???????1366??2010-05-04?13:43??jspbbs\src\com\accp800\dao\ReplyDao.java

?????文件????????171??2010-04-23?16:20??jspbbs\src\com\accp800\dao\RowMapper.java

?????文件???????2182??2010-04-30?16:30??jspbbs\src\com\accp800\dao\TopicDao.java

?????文件???????2207??2010-05-07?16:14??jspbbs\src\com\accp800\dao\UserDao.java

?????文件???????1325??2010-01-11?15:45??jspbbs\src\com\accp800\model\Board.java

?????文件???????1761??2010-05-07?16:21??jspbbs\src\com\accp800\model\Message.java

?????文件???????1855??2010-01-18?15:53??jspbbs\src\com\accp800\model\Reply.java

?????文件????????602??2010-04-27?16:01??jspbbs\src\com\accp800\model\Student.java

?????文件???????1913??2010-01-18?15:54??jspbbs\src\com\accp800\model\Topic.java

?????文件???????1654??2010-01-14?14:10??jspbbs\src\com\accp800\model\User.java

?????文件???????2182??2010-07-29?17:21??jspbbs\src\com\accp800\test\Testframe.java

?????文件????????331??2010-04-27?17:10??jspbbs\src\com\accp800\util\BBSUtils.java

?????文件???????2201??2010-05-07?17:04??jspbbs\web\addmsg.jsp

?????文件????????335??2010-05-04?16:59??jspbbs\web\checkLogin.jsp

?????文件???????5063??2010-05-04?17:20??jspbbs\web\detail.jsp

?????文件????????615??2010-05-07?16:27??jspbbs\web\doAddMsg.jsp

?????文件????????969??2010-07-29?17:27??jspbbs\web\doLogin.jsp

?????文件????????149??2010-05-04?16:50??jspbbs\web\doLogout.jsp

?????文件????????693??2010-05-04?17:06??jspbbs\web\doPost.jsp

............此處省略89個(gè)文件信息