package colbean;
/**
* 手机详细信息表业务操作的 Bean
* @author 唐昕、王高国
* 检验人:王欢、毛小叶、张兵
*/
import java.sql.*;
import java.util.*;
import db.*;
import showbean.*;
public class ColTelType {
/**
* 缺货商品信息
* @return ArrayList list
*/
public List searchLittleTel(){
List list=null;
DBConn db = DBConn.getInstance();
ResultSet rs=null;
try {
rs=db.executesql("select * from teltype where telcount=0");
if(rs!=null){
list=new ArrayList();
while(rs.next()){
TelType t=new TelType();
t.setDate(rs.getString("prodate"));
t.setCount(rs.getInt("telcount"));
t.setDvid(rs.getInt("camera"));
t.setGuiseid(rs.getInt("guise"));
t.setId(rs.getInt(1));
t.setInterid(rs.getInt("intertypeid"));
t.setOsid(rs.getInt("telos"));
t.setPath(rs.getString("picture"));
t.setPrice(rs.getDouble("price"));
t.setRingid(rs.getInt("ring"));
t.setScreenid(rs.getInt("screencolor"));
t.setTelid(rs.getInt("telid"));
t.setTypename(rs.getString(2));
t.setUserprice(rs.getDouble("userprice"));
t.setBuycount(rs.getInt("buycount"));
list.add(t);
}
}
} catch (Exception ex) {
ex.printStackTrace();
}
return list;
}
/**
* 更新手机记录
* @param tt
* @return boolean 值
*/
public boolean updateTel(TelType tt){
boolean b=false;
DBConn db = DBConn.getInstance();
String sql="update teltype set typename='"+tt.getTypename()
+"',telid="+tt.getTelid()+",price="+tt.getPrice()+
",userprice="+tt.getUserprice()
+",intertypeid="+tt.getInterid()+",prodate='"+tt.getDate()
+"',picture='"+tt.getPath()+"',telcount="+tt.getCount()
+",screencolor="+tt.getScreenid()+",telos="+tt.getOsid()
+",camera="+tt.getDvid()+",guise="+tt.getGuiseid()
+",ring="+tt.getRingid()+" where typeid="+tt.getId();
System.out.println("updatesql="+sql);
b=db.execute(sql);
return b;
}
/**
* 获得所有特价商品信息
* @return ArrayList list
*/
public List<TelType> getCheapShopping(){
List<TelType> list=null;
DBConn db = DBConn.getInstance();
ResultSet rs=null;
try {
rs=db.executesql("select * from teltype where userprice<=1000");
if(rs!=null){
list=new ArrayList<TelType>();
while(rs.next()){
TelType t=new TelType();
t.setDate(rs.getString("prodate"));
t.setCount(rs.getInt("telcount"));
t.setDvid(rs.getInt("camera"));
t.setGuiseid(rs.getInt("guise"));
t.setId(rs.getInt(1));
t.setInterid(rs.getInt("intertypeid"));
t.setOsid(rs.getInt("telos"));
t.setPath(rs.getString("picture"));
t.setPrice(rs.getDouble("price"));
t.setRingid(rs.getInt("ring"));
t.setScreenid(rs.getInt("screencolor"));
t.setTelid(rs.getInt("telid"));
t.setTypename(rs.getString(2));
t.setUserprice(rs.getDouble("userprice"));
t.setBuycount(rs.getInt("buycount"));
list.add(t);
}
}
} catch (Exception ex) {
ex.printStackTrace();
}
return list;
}
/**
* 最新商品信息
* @return ArrayList list
*/
public List<TelType> getNewShopping(){
List<TelType> list=null;
DBConn db = DBConn.getInstance();
GregorianCalendar calendar=new GregorianCalendar();
int year=calendar.get(Calendar.YEAR);
String sql="select * from TelType where prodate>='"+year+"'";
System.out.println("sql++++++"+sql);
ResultSet rs=db.executesql(sql);
try {
if(rs!=null){
list=new ArrayList<TelType>();
while(rs.next()){
TelType t=new TelType();
t.setDate(rs.getString("prodate"));
t.setCount(rs.getInt("telcount"));
t.setDvid(rs.getInt("camera"));
t.setGuiseid(rs.getInt("guise"));
t.setId(rs.getInt(1));
t.setInterid(rs.getInt("intertypeid"));
t.setOsid(rs.getInt("telos"));
t.setPath(rs.getString("picture"));
t.setPrice(rs.getDouble("price"));
t.setRingid(rs.getInt("ring"));
t.setScreenid(rs.getInt("screencolor"));
t.setTelid(rs.getInt("telid"));
t.setTypename(rs.getString(2));
t.setUserprice(rs.getDouble("userprice"));
t.setBuycount(rs.getInt("buycount"));
list.add(t);
}
}
} catch (Exception ex) {
ex.printStackTrace();
}
return list;
}
/**
* 获得热销商品信息
* @return ArrayList list
*/
public List<TelType> getGrade(){
List<TelType> list=null;
DBConn db = DBConn.getInstance();
ResultSet rs=db.executesql("select * from teltype where buycount!=0 order by buycount desc ");
try{
if (rs != null) {
list=new ArrayList<TelType>();
while (rs.next()) {
TelType t=new TelType();
t.setDate(rs.getString("prodate"));
t.setCount(rs.getInt("telcount"));
t.setDvid(rs.getInt("camera"));
t.setGuiseid(rs.getInt("guise"));
t.setId(rs.getInt(1));
t.setInterid(rs.getInt("intertypeid"));
t.setOsid(rs.getInt("telos"));
t.setPath(rs.getString("picture"));
t.setPrice(rs.getDouble("price"));
t.setRingid(rs.getInt("ring"));
t.setScreenid(rs.getInt("screencolor"));
t.setTelid(rs.getInt("telid"));
t.setTypename(rs.getString(2));
t.setUserprice(rs.getDouble("userprice"));
t.setBuycount(rs.getInt("buycount"));
list.add(t);
}
}
}catch(Exception e){
e.printStackTrace();
}
return list;
}
/**
* 高级搜索商品信息
* @param tt
* @param dvfrom
* @param yto
* @param page
* @return ArrayList list
*/
public List advanceSearch(TelType tt, int dvfrom, int yto, int page) {
List<TelType> list = null;
DBConn db = DBConn.getInstance();
String sql = "select top 4 * from teltype where typename like '%" +
tt.getTypename() +
"%' and prodate >='" + tt.getDate() + "' and prodate <= '" +
yto + "' and userprice >= " + tt.getPrice()
+ " and userprice <=" + tt.getUserprice() +
" and intertypeid =" + tt.getInterid()
+ " and camera >=" + tt.getDvid() + " and camera <=" +
dvfrom;
ResultSet rs = null;
if (tt.getGuisei
用servlet+jsp编写的一个手机网站项目 （674个子文件） 
BackgroundC.bmp 3KB BackgroundC.bmp 3KB Pic_Player_BG_Left.bmp 1KB
ColTelType.class 19KB ColOrders.class 7KB ColUsers.class 5KB UpdateTelInfo.class 5KB AddTel.class 5KB AdvanceSearch.class 5KB TelType.class 4KB OrderUpdate.class 4KB RegServlet.class 3KB Imagecheck.class 3KB ColPurchase.class 3KB SearchTel.class 3KB UpdateUsers.class 3KB OrdersBean.class 3KB OrderManager.class 3KB ModifyShop.class 3KB Buyservlet.class 3KB UsersBean.class 3KB ListOrder.class 3KB Login.class 3KB OrdersManager.class 3KB ShowHasDealOrders.class 3KB ColTelCompany.class 3KB CheapShopping.class 3KB NewShopping.class 3KB Message.class 3KB ShopGrade.class 3KB SearchTelType.class 2KB PageServlet.class 2KB ShowOutOfStock.class 2KB SearchCom.class 2KB UpdateTelType.class 2KB ColMessage.class 2KB AllUserInfo.class 2KB PageMessage.class 2KB TelTypeValue.class 2KB AdminLogin.class 2KB ShowShops.class 2KB AddTelCompany.class 2KB ManageShowShop.class 2KB ModifUsers.class 2KB ColPayType.class 2KB Pay.class 2KB OrderDeal.class 2KB TelPro.class 2KB SetCharFilter.class 2KB AlterUsers.class 2KB ColInterType.class 2KB ColScreenType.class 2KB ColGuise.class 2KB DBConn.class 2KB ColRings.class 2KB ExitServlet.class 2KB ColTelOs.class 2KB DeleteMessage.class 2KB AdminExit.class 1KB Purchase.class 1KB MessageBean.class 1KB ColAdmin.class 1KB PayType.class 918B Admin.class 880B GuiseBean.class 743B ScreenType.class 734B InterType.class 728B TelCompany.class 725B RingBean.class 722B TelOsBean.class 719B .classpath 764B css.css 1KB css.css 1KB Thumbs.db 762KB Thumbs.db 113KB Thumbs.db 7KB Entries 13KB Entries 2KB Entries 1KB Entries 1001B Entries 590B Entries 557B Entries 492B Entries 476B Entries 377B Entries 301B Entries 226B Entries 157B Entries 151B Entries 70B Entries 41B Entries 34B Entries 34B
shopv8.gif 26KB logo2.gif 23KB user.gif 22KB 56097_allkeji750x90_sina_.gif 20KB top_img01.gif 18KB vendor_img.gif 18KB N1101-122-122.gif 11KB共 674 条
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 1
- 2
- 3
前往页