package?com.jjy.shop.dao;

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

import?com.jjy.shop.dao.mapper.AddressMapper;
import?com.jjy.shop.dao.mapper.AdminMapper;
import?com.jjy.shop.entity.Address;
import?com.jjy.shop.entity.Admin;
import?com.jjy.shop.util.JdbcTemplate;

public?abstract?class?AddressDao?extends?baseDao?{

	@Override
	public?Long?insert（T?entity）?throws?SQLException?{
		//?TODO?Auto-generated?method?stub
		String?sql=“INSERT?INTO?‘address‘?VALUES?（???????????????）“;
		Address?address?=?（Address）?entity;
		long?addressId?=?JdbcTemplate.excuteUpdate（sql??address.getId（）?address.getUser_id（）
				address.getShouhuorenname（）address.getSuozaidizhi（）address.getXiangxidizhi（）address.getYouzhengbianma（）address.getDianhua（）address.getShoujihao（））;
		return?addressId;
	}

	@Override
	public?List?queryAll（）?throws?SQLException?{
		//?TODO?Auto-generated?method?stub
		return?null;
	}

	@Override
	public?T?queryById（long?id）?throws?SQLException?{
		//?TODO?Auto-generated?method?stub
		String?sql?=?“select?*?from?address?where?id=??“;
		List?list?=?JdbcTemplate.excuteQuery（sql?new?AddressMapper（）?id）;
		if?（list.size（）?			return?null;
		}?else?{
			return?list.get（0）;
		}

	}

	@Override
	public?void?deleteById（long?id）?throws?SQLException?{
		//?TODO?Auto-generated?method?stub
		
	}

	@Override
	public?Long?update（T?entity）?throws?SQLException?{
		//?TODO?Auto-generated?method?stub
		return?null;
	}
	public?abstract?List?queryByUserId（long?userId）?throws?SQLException;
}

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

?????文件????????725??2017-03-12?16:34??Shopping\.classpath

?????文件???????1041??2017-03-12?16:34??Shopping\.project

?????文件????????567??2017-03-12?16:34??Shopping\.settings\.jsdtscope

?????文件????????228??2017-03-12?16:34??Shopping\.settings\org.eclipse.core.resources.prefs

?????文件????????364??2017-03-12?16:34??Shopping\.settings\org.eclipse.jdt.core.prefs

?????文件????????476??2017-03-12?16:34??Shopping\.settings\org.eclipse.wst.common.component

?????文件????????305??2017-03-12?16:34??Shopping\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-03-12?16:34??Shopping\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-03-12?16:34??Shopping\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????2477??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\AddressDao.class

?????文件???????3434??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\AdminDao.class

?????文件????????786??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\baseDao.class

?????文件???????2981??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\CartDao.class

?????文件???????2290??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\CommentDao.class

?????文件???????1111??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\impl\AddressDaoImpl.class

?????文件???????1611??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\impl\AdminDaoImpl.class

?????文件???????1277??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\impl\CartDaoImpl.class

?????文件???????1068??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\impl\CommentDaoImpl.class

?????文件???????1292??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\impl\OrderDaoImpl.class

?????文件???????2392??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\impl\ProductDaoImpl.class

?????文件????????520??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\impl\ProductType2DaoImpl.class

?????文件???????1111??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\impl\ProductTypeDaoImpl.class

?????文件????????478??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\impl\SlideDaoImpl.class

?????文件???????1577??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\impl\UserDaoImpl.class

?????文件???????1272??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\mapper\AddressMapper.class

?????文件???????1146??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\mapper\AdminMapper.class

?????文件???????1254??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\mapper\CartMapper.class

?????文件???????1138??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\mapper\CommentMapper.class

?????文件???????1035??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\mapper\OrderMapper.class

?????文件???????2086??2017-03-12?16:34??Shopping\build\classes\com\jjy\shop\dao\mapper\ProductMapper.class

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