goodsmodel.java

网上商城源码,功能包括商品管理,订单管理,用户管理等

package com.shop.model;

import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collection;

import com.shop.common.Dbconn;
import com.shop.view.GoodsVo;

public class GoodsModel {
	Dbconn db;

	public void insertGoods(GoodsVo vo) {
		db = new Dbconn();
		PreparedStatement ps = null;
		String sql = "insert into shop_goods(goods_type,goods_name,goods_price,goods_number,goods_info,goods_surl,goods_burl,goods_forgoodid,goods_date) values(?,?,?,?,?,?,?,?,?)";
		try {
			ps=db.getConn().prepareStatement(sql);
			ps.setString(1, vo.getType());
			ps.setString(2, vo.getName());
			ps.setFloat(3, vo.getPrice());
			ps.setInt(4, vo.getNumber());
			ps.setString(5, vo.getInfo());
			ps.setString(6, vo.getSurl());
			ps.setString(7, vo.getBurl());
			ps.setInt(8, vo.getForgoodid());
			ps.setDate(9, new Date(new java.util.Date().getTime()));
			ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	public int selforkey(String goods_type){
		int i=0;
		db=new Dbconn();
		Statement sta=null;
		ResultSet rs=null;
		String sql="select goodstype_id from shop_goodstype where goodstype_name='"+goods_type+"' ";
		try {
			sta=db.getConn().createStatement();
			rs=sta.executeQuery(sql);
			while (rs.next()) {
				i=rs.getInt(1);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return i;
	}
	public Collection selGoodsAll() {
		Collection c=new ArrayList();
		db=new Dbconn();
		Statement sta=null;
		ResultSet rs=null;
		String sql="select * from shop_goods order by goods_date desc";
		
		try {
			sta=db.getConn().createStatement();
			rs=sta.executeQuery(sql);
			while (rs.next()) {
				GoodsVo vo=new GoodsVo();
				vo.setId(rs.getInt(1));
				vo.setType(rs.getString(2));
				vo.setName(rs.getString(3));
				vo.setPrice(rs.getFloat(4));
				vo.setNumber(rs.getInt(5));
				vo.setInfo(rs.getString(6));
				vo.setSurl(rs.getString(7));
				vo.setBurl(rs.getString(8));
				vo.setForgoodid(rs.getInt(9));
				vo.setDate(rs.getDate(10));
				c.add(vo);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return c;
	}
	public void deleteGoods(int id) {
		db=new Dbconn();
		Statement sta=null;
		String sql="delete from shop_goods where goods_id="+id;
		try {
			sta=db.getConn().createStatement();
			sta.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	public GoodsVo selGoodsOne(int id) {
		GoodsVo vo=null;
		db=new Dbconn();
		Statement sta=null;
		ResultSet rs=null;
		String sql="select * from shop_goods where goods_id="+id;
		
		try {
			sta=db.getConn().createStatement();
			rs=sta.executeQuery(sql);
			while (rs.next()) {
				vo=new GoodsVo();
				vo.setId(rs.getInt(1));
				vo.setType(rs.getString(2));
				vo.setName(rs.getString(3));
				vo.setPrice(rs.getFloat(4));
				vo.setNumber(rs.getInt(5));
				vo.setInfo(rs.getString(6));
				vo.setSurl(rs.getString(7));
				vo.setBurl(rs.getString(8));
				vo.setForgoodid(rs.getInt(9));
				vo.setDate(rs.getDate(10));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return vo;
	}
	public void updateGoods(GoodsVo vo) {
		db = new Dbconn();
		PreparedStatement ps = null;
		String sql = "update shop_goods set goods_type=?,goods_name=?,goods_price=?,goods_number=?,goods_info=?,goods_surl=?,goods_burl=?,goods_forgoodid=?,goods_date=? where goods_id="+vo.getId();
		try {
			ps=db.getConn().prepareStatement(sql);
			ps.setString(1, vo.getType());
			ps.setString(2, vo.getName());
			ps.setFloat(3, vo.getPrice());
			ps.setInt(4, vo.getNumber());
			ps.setString(5, vo.getInfo());
			ps.setString(6, vo.getSurl());
			ps.setString(7, vo.getBurl());
			ps.setInt(8, vo.getForgoodid());
			ps.setDate(9, new Date(new java.util.Date().getTime()));
			ps.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public Collection selGoods(String goods_type,String goods_name) {
		Collection c=new ArrayList();
		db=new Dbconn();
		Statement sta=null;
		ResultSet rs=null;
		String sql="select * from shop_goods where goods_type='"+goods_type+"' and goods_name like '%"+goods_name+"%'";
		System.out.println(sql);
		try {
			sta=db.getConn().createStatement();
			rs=sta.executeQuery(sql);
			while (rs.next()) {
				GoodsVo vo=new GoodsVo();
				vo.setId(rs.getInt(1));
				vo.setType(rs.getString(2));
				vo.setName(rs.getString(3));
				vo.setPrice(rs.getFloat(4));
				vo.setNumber(rs.getInt(5));
				vo.setInfo(rs.getString(6));
				vo.setSurl(rs.getString(7));
				vo.setBurl(rs.getString(8));
				vo.setForgoodid(rs.getInt(9));
				vo.setDate(rs.getDate(10));
				System.out.println(rs.getString(3));
				c.add(vo);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return c;
	}
}