package?sunyang.dao;

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

import?sunyang.domain.Account;
import?sunyang.util.DBConnector;

public?class?AccountDAO?{
	private?Connection?c;

	public?AccountDAO（）?{
		c?=?DBConnector.getConnection（）;
	}

	public?boolean?save（Account?a）?{
		String?saveSql?=?“insert?into?account?（useridaddresspostcodeaccountcodeaccountdateexecute）?values（??????）“;
		PreparedStatement?ps;
		try?{
			ps?=?c.prepareStatement（saveSql）;
			ps.setInt（1?a.getUserid（））;
			ps.setString（2?a.getAddress（））;
			ps.setString（3?a.getPostcode（））;
			ps.setString（4?a.getAccountcode（））;
			ps.setString（5a.getAccountdate（））;
			ps.setInt（6?a.getExecute（））;
			ps.executeUpdate（）;
		}?catch?（SQLException?e）?{
			System.out.println（“SQL異常“）;
			e.printStackTrace（）;
			return?false;
		}
		return?true;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-03-20?21:25??購物車\
?????文件????????2460??2008-12-08?16:48??購物車\account.jsp
?????文件?????????249??2008-12-05?16:42??購物車\accountOver.jsp
?????文件?????????413??2008-12-05?09:04??購物車\addSCSuccess.jsp
?????文件?????????305??2008-12-03?15:30??購物車\cleared.jsp
?????目錄???????????0??2013-03-20?21:25??購物車\CSS\
?????文件????????4273??2008-12-08?16:38??購物車\CSS\style.css
?????文件?????????333??2008-12-03?14:45??購物車\errors.jsp
?????目錄???????????0??2013-03-20?21:25??購物車\goodsPhoto\
?????文件???????40720??2008-12-03?14:00??購物車\goodsPhoto\1.jpg
?????文件???????51160??2008-12-03?14:00??購物車\goodsPhoto\10.jpg
?????文件???????50792??2008-12-03?14:00??購物車\goodsPhoto\11.jpg
?????文件???????61268??2008-12-03?14:00??購物車\goodsPhoto\12.jpg
?????文件???????42114??2008-12-03?14:00??購物車\goodsPhoto\13.jpg
?????文件???????54289??2008-12-03?14:00??購物車\goodsPhoto\14.jpg
?????文件???????52417??2008-12-03?14:00??購物車\goodsPhoto\15.jpg
?????文件???????58592??2008-12-03?14:00??購物車\goodsPhoto\16.jpg
?????文件???????48520??2008-12-03?14:00??購物車\goodsPhoto\17.jpg
?????文件???????43373??2008-12-03?14:00??購物車\goodsPhoto\18.jpg
?????文件???????46522??2008-12-03?14:00??購物車\goodsPhoto\19.jpg
?????文件???????33391??2008-12-03?14:00??購物車\goodsPhoto\2.jpg
?????文件???????60352??2008-12-03?14:00??購物車\goodsPhoto\20.jpg
?????文件???????51725??2008-12-03?14:00??購物車\goodsPhoto\21.jpg
?????文件????????9683??2008-12-03?14:00??購物車\goodsPhoto\22.jpg
?????文件???????16226??2008-12-03?14:00??購物車\goodsPhoto\23.jpg
?????文件???????11818??2008-12-03?14:00??購物車\goodsPhoto\24.jpg
?????文件????????4313??2008-12-03?14:00??購物車\goodsPhoto\25.jpg
?????文件????????7985??2008-12-03?14:00??購物車\goodsPhoto\26.jpg
?????文件????????5074??2008-12-03?14:00??購物車\goodsPhoto\27.jpg
?????文件???????10533??2008-12-03?14:00??購物車\goodsPhoto\28.jpg
?????文件???????29840??2008-12-03?14:00??購物車\goodsPhoto\29.jpg
............此處省略82個文件信息