package?dao;

import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;

import?vo.addr;
/**
?*?*?
title:?addrDao

*?
Description:?數(shù)據(jù)訪問(wèn)層

*?@author?與其終
*?@date?下午2:47:26
?*/
public?class?addrDao?extends?baseDao{
//	添加
	public?boolean?insertAddr（int?addId?String?addName?String?addSex?int?addAge?String?addTel?String?addEmail
			String?addAddr）?throws?ClassNotFoundException?SQLException?{
		String?sql?=?“insert?into?addr?values（???????）“;
		boolean?flag?=?false;
		int?i=?0;
		preStmt?=?this.createPreStmt（sql）;
		//?設(shè)置參數(shù)
		preStmt.setInt（1?addId）;
		preStmt.setString（2?addName）;
		preStmt.setString（3?addSex）;
		preStmt.setInt（4?addAge）;
		preStmt.setString（5?addTel）;
		preStmt.setString（6?addEmail）;
		preStmt.setString（7?addAddr）;
		
		//?發(fā)送sql語(yǔ)句到sql引擎執(zhí)行
		i?=?preStmt.executeUpdate（）;
		if（i>0）{
			flag?=?true;
		}
		this.close（）;
		return?flag;
	}
//	刪除一條
	public?int?deleteAddr（int?id）?throws?ClassNotFoundException?SQLException?{
		String?sql?=?“delete?from?addr?where?id?=??“;
		preStmt?=?this.createPreStmt（sql）;
		//?設(shè)置參數(shù)
		preStmt.setInt（1?id）;
		
		int?i?=?0;
		i?=?preStmt.executeUpdate（）;
		this.close（）;
		return?i;
	}
//	查詢(xún)所有
	public?List?findAll（）?throws?ClassNotFoundException?SQLException?{
		List?list?=?null;
		String?sql?=?“select?*?from?addr“;

		preStmt?=?this.createPreStmt（sql）;?
		//?接受查詢(xún)語(yǔ)句返回的結(jié)果集
		rs?=?preStmt.executeQuery（）;
		list?=?new?ArrayList（）;

		while?（rs.next（））?{
			addr?a?=?new?addr（）;
			a.setId（rs.getInt（“id“））;
			a.setName（rs.getString（“name“））;?????
			a.setSex（rs.getString（“sex“））;
			a.setAge（rs.getInt（“age“））;
			a.setTel（rs.getString（“tel“））;
			a.setEmail（rs.getString（“email“））;
			a.setAddress（rs.getString（“address“））;
			
			list.add（a）;
			System.out.println（“-----------addrDao:“+a）;
		}
		this.close（）;
		return?list;
	}
//	//刪除所有
//	public?Boolean?deleteAll（）?throws?ClassNotFoundException?SQLException?{
//		String?sql?=?“delete?from?store“;
//		boolean?flag=false;
//		preStmt=this.createPreStmt（sql）;
//		int?i?=?preStmt.executeUpdate（）;
//		if（i>0）?{
//			flag?=?true;
//			System.out.println（“刪除成功“）;
////			conn.commit（）;
//		}else{
//			flag?=?false;
//			System.out.println（“刪除失敗“）;
////			conn.rollback（）;
//		}
//		this.close（）;
//		return?flag;
//	}
//	

//	修改
	public?void?updateAddr（int?id?String?nameString?sexint?ageString?telString?email?String?address）?throws?ClassNotFoundException?SQLException{
		String?sql?=?“update?addr?set?id?=??name?=??sex?=??age?=??tel?=??email?=??address?=???where?id?=??“;
		preStmt?=?this.createPreStmt（sql）;

		preStmt.setInt（1?id）;
		preStmt.setString（2?name）;
		preStmt.setString（3?sex）;
		preStmt.setInt（4?age）;
		preStmt.setString（5?tel）;
		preStmt.setString（6?email）;
		preStmt.setString（7?address）;
		preStmt.setInt（8?id）;
		
		boolean?flag=false;
		int?i?=?preStmt.executeU

?屬性????????????大小?????日期????時(shí)間???名稱(chēng)
-----------?---------??----------?-----??----
?????目錄???????????0??2019-11-21?12:16??addressListSys\
?????文件?????????808??2019-11-21?12:14??addressListSys\.classpath
?????文件????????1047??2019-11-21?12:14??addressListSys\.project
?????目錄???????????0??2019-11-21?12:14??addressListSys\.settings\
?????文件?????????567??2019-11-21?12:14??addressListSys\.settings\.jsdtscope
?????文件?????????124??2019-11-21?12:14??addressListSys\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2019-11-21?12:14??addressListSys\.settings\org.eclipse.jdt.core.prefs
?????文件?????????494??2019-11-21?12:14??addressListSys\.settings\org.eclipse.wst.common.component
?????文件?????????305??2019-11-21?12:14??addressListSys\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2019-11-21?12:14??addressListSys\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2019-11-21?12:14??addressListSys\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2019-11-21?12:14??addressListSys\build\
?????目錄???????????0??2019-11-21?12:14??addressListSys\build\classes\
?????目錄???????????0??2019-11-21?12:14??addressListSys\build\classes\dao\
?????文件????????4136??2019-11-21?12:14??addressListSys\build\classes\dao\addrDao.class
?????文件????????1950??2019-11-21?12:14??addressListSys\build\classes\dao\baseDao.class
?????目錄???????????0??2019-11-21?12:14??addressListSys\build\classes\servlet\
?????文件????????2617??2019-11-21?12:14??addressListSys\build\classes\servlet\AddServlet.class
?????文件????????2043??2019-11-21?12:14??addressListSys\build\classes\servlet\DeleteServlet.class
?????文件????????2298??2019-11-21?12:14??addressListSys\build\classes\servlet\ShowServlet.class
?????文件????????2911??2019-11-21?12:14??addressListSys\build\classes\servlet\UpdateServlet.class
?????目錄???????????0??2019-11-21?12:14??addressListSys\build\classes\vo\
?????文件????????2029??2019-11-21?12:14??addressListSys\build\classes\vo\addr.class
?????目錄???????????0??2019-11-21?12:14??addressListSys\src\
?????目錄???????????0??2019-11-21?12:14??addressListSys\src\dao\
?????文件????????3951??2019-11-21?12:14??addressListSys\src\dao\addrDao.java
?????文件????????1895??2019-11-21?12:14??addressListSys\src\dao\baseDao.java
?????目錄???????????0??2019-11-21?12:14??addressListSys\src\servlet\
?????文件????????2179??2019-11-21?12:14??addressListSys\src\servlet\AddServlet.java
?????文件????????1261??2019-11-21?12:14??addressListSys\src\servlet\DeleteServlet.java
?????文件????????1393??2019-11-21?12:14??addressListSys\src\servlet\ShowServlet.java
............此處省略39個(gè)文件信息