constants.java

网上商城

package com.witbridge.netstore.dao.impl;

public class Constants {
	 static final String SELECT_CUSTOMER="select * from customers";
	 static final String SELECT_CUSTOMER_KEY2="select * from customers where NAME=? and PASSWORD=?";
	 static final String SELECT_CUSTOMER_KEY1="select * from customers where ID=?";
	 static final String ADD_CUSTOMER="insert into customers(ID,NAME,PASSWORD,EMAIL) values(?,?,?,?)";
	 static final String DELETE_CUSTOMER="delete from customers where ID=?";
	 static final String UPDATE_CUSTOMER="update customers set NAME=?,PASSWORD=?,EMAIL=? where ID=?";
	 
	 static final String SELECT_ITEM_KEY="select * from items where ID=?";
	 static final String SELECT_ITEM="select * from items";
	 static final String DELECT_ITEM="delete from items where ID=?";
	 static final String UPDATE_ITEM="update items set NAME=? where ID=?";
	 static final String ADD_ITEM="insert into items(ID,NAME,MODEL_NUMBER,DESCRIPTION,FEATURE,SMALL_IMAGE_URL,LARGE_IMAGE_URL,BASE_PRICE)" +
	 							"values(?,?,?,?,?,?,?,?)";

	 
	 static final String INSERT_LINEITEM="insert into lineitems (ORDER_NUMBER,ITEM_ID,QUANTITY) values(?,?,?)";
	 static final String  DELECT_LINEITEM="delete from lineitems where ITEM_ID=? and ORDER_NUMBER=?";
	 
	 static final String DELECT_ODER="delete from orders where ORDER_NUMBER=?";
	 static final String IINSERT_ODER="insert into orders(ORDER_NUMBER,CUSTOMER_ID,TOTAL_PRICE,STATE,CITY,STREET,POSTALCODE,PHONE)" +
	 		"values(?,?,?,?,?,?,?,?)";
	 
	 public static final String SESSION_CONTANER_KEY="SessionContaner";
	 public static final String SESSIONCONTAINER_NULL="购物车是空的，不能生成订单，<a href="+"/netstore/welcome.jsp"+">请购物</a>！！";

}