javaweb校园二手系统平台jsp+servlet
基于jsp+servlet技术的javaweb商城开发,
实现了登录注册,搜索商品,加购支付
以及管理员的管理商品,查看商城信息等功能。
背景:
目前,随着人们生活水平的提高,人们的生活物质更新速度也在不断地加快。
如今大学生的闲置物品繁多,尤其是毕业班的学生有很多闲置的物品需要处理,闲置没用的东西需要转手,怎么处置这些物品成了难题,而在这样的前提下,
受到互联网思维的影响,我想一个以服务于学生的二手交易平台的出现可以很好地解决现在大学生闲置物品的问题,同时资源可以得到重新地利用。
目前大学毕业生毕业时都会有许多物品诸如:书籍、电脑、自行车等因运输不便当做废品匆忙处理掉,尽管有的大四毕业生会在毕业前半个月采用摆摊的方式最大限度处理自己的物品,即使处理的价格极其低廉,
但在如此短的时间内卖出的商品只是冰山一角,大部分物品只得挥泪当做废品卖掉。
{
public static List catelogList()
{
List catelogList=new ArrayList();
String sql="select * from t_catelog where del='no'";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tcatelog catelog=new Tcatelog();
catelog.setId(rs.getInt("id"));
catelog.setName(rs.getString("name"));
catelogList.add(catelog);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
return catelogList;
}
public static String getUserName(String id)
{
String name="";
String sql="select * from t_user where id=?";
Object[] params={id};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
rs.next();
name=rs.getString("loginname");
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
return name;
}
public static Tgoods getGoods(int id)
{
Tgoods goods=new Tgoods();
String sql="select * from t_goods where id=?";
Object[] params={id};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
rs.next();
goods.setId(rs.getInt("id"));
goods.setCatelog_id(rs.getInt("catelog_id"));
goods.setNannvkuan(rs.getString("nannvkuan"));
goods.setBianhao(rs.getString("bianhao"));
goods.setMingcheng(rs.getString("mingcheng"));
goods.setJieshao(rs.getString("jieshao"));
goods.setPinpai(rs.getString("pinpai"));
goods.setFujian(rs.getString("fujian"));
goods.setShichangjia(rs.getInt("shichangjia"));
goods.setTejia(rs.getInt("tejia"));
goods.setShifoutejia(rs.getString("shifoutejia"));
goods.setKucun(rs.getInt("kucun"));
goods.setDel(rs.getString("del"));
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
return goods;
}
public static List goodsNew()
{
List goodsList=new ArrayList();
String sql="select * from t_goods where del='no' and shifoutejia='fou' order by id desc";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tgoods goods=new Tgoods();
goods.setId(rs.getInt("id"));
goods.setCatelog_id(rs.getInt("catelog_id"));
goods.setNannvkuan(rs.getString("nannvkuan"));
goods.setBianhao(rs.getString("bianhao"));
goods.setMingcheng(rs.getString("mingcheng"));
goods.setJieshao(rs.getString("jieshao"));
goods.setPinpai(rs.getString("pinpai"));
goods.setFujian(rs.getString("fujian"));
goods.setShichangjia(rs.getInt("shichangjia"));
goods.setTejia(rs.getInt("tejia"));
goods.setShifoutejia(rs.getString("shifoutejia"));
goods.setKucun(rs.getInt("kucun"));
goods.setDel(rs.getString("del"));
goodsList.add(goods);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
if(goodsList.size()>8)
{
goodsList=goodsList.subList(0, 8);
}
return goodsList;
}
public static List goodsPaihang4()
{
List goodsList=new ArrayList();
String sql="select sum(goods_quantity),goods_id from t_orderitem group by goods_id order by sum(goods_quantity) desc";
Object[] params={};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
goodsList.add(getGoods(rs.getInt(2)));
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
if(goodsList.size()>4)
{
goodsList=goodsList.subList(0, 4);
}
return goodsList;
}
public static List goodsByCatelog(int catelog_id)
{
List goodsList=new ArrayList();
String sql="select * from t_goods where del='no' and catelog_id=? order by id desc";
Object[] params={catelog_id};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tgoods goods=new Tgoods();
goods.setId(rs.getInt("id"));
goods.setCatelog_id(rs.getInt("catelog_id"));
goods.setNannvkuan(rs.getString("nannvkuan"));
goods.setBianhao(rs.getString("bianhao"));
goods.setMingcheng(rs.getString("mingcheng"));
goods.setJieshao(rs.getString("jieshao"));
goods.setPinpai(rs.getString("pinpai"));
goods.setFujian(rs.getString("fujian"));
goods.setShichangjia(rs.getInt("shichangjia"));
goods.setTejia(rs.getInt("tejia"));
goods.setShifoutejia(rs.getString("shifoutejia"));
goods.setKucun(rs.getInt("kucun"));
goods.setDel(rs.getString("del"));
goodsList.add(goods);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
return goodsList;
}
public static List goodsByKey(String key)
{
List goodsList=new ArrayList();
String sql="select * from t_goods where del='no' and mingcheng like '%"+key+"%' order by id desc";
System.out.println(key);
DB mydb=new DB();
try
{
mydb.doPstm(sql, null);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Tgoods goods=new Tgoods();
goods.setId(rs.getInt("id"));
goods.setCatelog_id(rs.getInt("catelog_id"));
goods.setNannvkuan(rs.getString("nannvkuan"));
goods.setBianhao(rs.getString("bianhao"));
goods.setMingcheng(rs.getString("mingcheng"));
goods.setJieshao(rs.getString("jieshao"));
goods.setPinpai(rs.getString("pinpai"));
goods.setFujian(rs.getString("fujian"));
goods.setShichangjia(rs.getInt("shichangjia"));
goods.setTejia(rs.getInt("tejia"));
goods.setShifoutejia(rs.getString("shifoutejia"));
goods.setKucun(rs.getInt("kucun"));
goods.setDel(rs.getString("del"));
goodsList.add(goods);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
return goodsList;
}
public static void saveOrder(Torder order)
{
String sql="insert into t_order(id,bianhao,shijian,zhuangtai,songhuodizhi,fukuanfangshi,jine,user_id) values(?,?,?,?,?,?,?,?)";
Object[] params={order.getId(),order.getBianhao(),order.getShijian(),order.getZhuangtai(),order.getSonghuodizhi(),order.getFukuanfangshi(),order.getJine(),order.getUser_id()};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
}
public static void saveOrderItem(String id,String order_id,int goods_id,int goods_quantity)
{
String sql="insert into t_orderitem(id,order_id,goods_id,goods_quantity) values(?,?,?,?)";
Object[] params={id,order_id,goods_id,goods_quantity};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
}
public static void updateGoodsKucun(int goods_id,int goods_quantity)
{
String sql="update t_goods set kucun=kucun-? where id=?";
Object[] params={goods_quantity,goods_id};
DB mydb=new DB();
mydb.doPstm(sql, params);
mydb.closed();
}
public static List orderList(String user_id,String name)
{
List orderList=new ArrayList();
String sql="select * from t_order where user_id="+user_id;
if(name!=null && name.trim().length()>0){
sql=sql+" and bianhao like '%"+name+"%'";
}
Object[] params=null;
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
Torder order=new Torder();
order.setId(rs.getString("id"));
order.setBianhao(rs.getString("bianhao"));
order.setShijian(rs.getString("shijian"));
order.setZhuangtai(rs.getString("zhuangtai"));
order.setSonghuodizhi(rs.getString("songhuodizhi"));
order.setFukuanfangshi(rs.getString("fukuanfangshi"));
order.setJine(rs.getInt("jine"));
order.setUser_id(rs.getString("user_id"));
orderList.add(order);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
return orderList;
}
public static List pingItemList(String order_id){
List pingitemList=new ArrayList();
String sql="select * from t_ping where order_id=?";
Object[] params={order_id};
DB mydb=new DB();
try {
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next()){
TpingItem pingItem=new TpingItem();
pingItem.setId(rs.getInt("id"));
pingItem.setOrder_id(rs.getString("order_id"));
pingItem.setOrderitem_id(rs.getString("orderitem_id"));
pingItem.setGoods_id(rs.getInt("goods_id"));
pingItem.setMingcheng(rs.getString("mingcheng"));
pingItem.setUser_id(rs.getString("user_id"));
pingItem.setLoginname(rs.getString("loginname"));
pingItem.setInfo(rs.getString("info"));
pingItem.setAdddate(rs.getString("adddate"));
pingItem.setGoods(getGoods(rs.getInt("goods_id")));
pingitemList.add(pingItem);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
mydb.closed();
return pingitemList;
}
public static List pingList(int goodsid){
List pingitemList=new ArrayList();
String sql="select * from t_ping where goods_id=? order by id desc";
Object[] params={goodsid};
DB mydb=new DB();
try {
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next()){
TpingItem pingItem=new TpingItem();
pingItem.setId(rs.getInt("id"));
pingItem.setOrder_id(rs.getString("order_id"));
pingItem.setOrderitem_id(rs.getString("orderitem_id"));
pingItem.setGoods_id(rs.getInt("goods_id"));
pingItem.setMingcheng(rs.getString("mingcheng"));
pingItem.setUser_id(rs.getString("user_id"));
pingItem.setLoginname(rs.getString("loginname"));
pingItem.setInfo(rs.getString("info"));
pingItem.setAdddate(rs.getString("adddate"));
pingItem.setGoods(getGoods(rs.getInt("goods_id")));
pingItem.setReply(rs.getString("reply"));
pingItem.setReplydate(rs.getString("replydate"));
pingitemList.add(pingItem);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
mydb.closed();
return pingitemList;
}
public static List orderItemList(String order_id)
{
List orderitemList=new ArrayList();
String sql="select * from t_orderitem where order_id=?";
Object[] params={order_id};
DB mydb=new DB();
try
{
mydb.doPstm(sql, params);
ResultSet rs=mydb.getRs();
while(rs.next())
{
TorderItem orderItem=new TorderItem();
orderItem.setId(rs.getString("id"));
orderItem.setGoods(getGoods(rs.getInt("goods_id")));
orderItem.setGoods_quantity(rs.getInt("goods_quantity"));
orderItem.setGoods_state(rs.getString("goods_state"));
orderitemList.add(orderItem);
}
rs.close();
}
catch(Exception e)
{
e.printStackTrace();
}
mydb.closed();
return orderitemList;
}
}