orderdaoimpl.java

JSP的网上商城的代码。只是小部分。希望大家能够多看看。一起学习。

package com.eshop.daoImpl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

import com.eshop.database.dbconn;
import com.eshop.dao.OrderDao;
import com.eshop.dto.Order;

public class OrderDaoImpl implements OrderDao {
	
	public Vector selectAll() throws SQLException{
		Vector list = new Vector();
		dbconn conn = new dbconn();
		String sql = "select * from orders ";
		ResultSet rs = null;
		rs = conn.executeQuery(sql);
		while(rs.next())
		{
			Order o= new Order();
			o.setCarryType(rs.getString("carrytype"));
			o.setDate(rs.getString("date"));
			o.setEnforce(rs.getString("enforce"));
			o.setGid(rs.getInt("gid"));
			o.setId(rs.getInt("id"));
            o.setuserName(rs.getString("username"));
			o.setMount(rs.getInt("mount"));
            o.setPrice(rs.getDouble("price"));
            o.setTotle(rs.getDouble("totle"));
			list.add(o);			
		}
		return list;
	}

	public Vector FindunEnforce() throws SQLException {
		Vector list = new Vector();
		dbconn conn = new dbconn();
		String sql = "select * from orders where enforce = 'no'";
		ResultSet rs = null;
		rs = conn.executeQuery(sql);
		while(rs.next())
		{
			Order o= new Order();
			o.setCarryType(rs.getString("carrytype"));
			o.setDate(rs.getString("date"));
			o.setEnforce(rs.getString("enforce"));
			o.setGid(rs.getInt("gid"));
			o.setId(rs.getInt("id"));
			o.setuserName(rs.getString("username"));
			o.setMount(rs.getInt("mount"));
            o.setPrice(rs.getDouble("price"));
            o.setTotle(rs.getDouble("totle"));
			list.add(o);			
		}
		return list;
	}

	public int insert(Order g) throws SQLException {
		String sql = 
		    "insert into orders (gid,username,mount,price,totle,carrytype)  values ("
			+g.getGid()+",'"+g.getuserName()+"',"+g.getMount()+","+g.getPrice()
		    +","+g.getTotle()+",'"+g.getCarryType()+"')";
		dbconn conn = new dbconn();
        int flag = 0;
		flag = conn.excuteUpdate(sql);
		return flag;
	}
   public int setEnforce(int id) throws SQLException{
        	String sql = "update orders set enforce = 'yes' ,date = curdate() where id ="+id;
            dbconn conn = new dbconn();
            int flag = 0;    
            flag = conn.excuteUpdate(sql);
            conn.close();
            return flag;     	
        }
   public Vector membercheck(String username) throws SQLException{
	   Vector list = new Vector();
		dbconn conn = new dbconn();
		String sql = "select * from orders where username='"+username+"'";
		ResultSet rs = null;
		rs = conn.executeQuery(sql);
		while(rs.next())
		{
			Order o= new Order();
			o.setCarryType(rs.getString("carrytype"));
			o.setDate(rs.getString("date"));
			o.setEnforce(rs.getString("enforce"));
			o.setGid(rs.getInt("gid"));
			o.setId(rs.getInt("id"));
			o.setMount(rs.getInt("mount"));
            o.setPrice(rs.getDouble("price"));
            o.setTotle(rs.getDouble("totle"));
			list.add(o);			
		}
		return list;
	   
   }

}