finalconstants.java~37~

这是一个用Struts做出来的网上商城的源代码

package com.tool;

//需要调用的SQL语句
public final class FinalConstants {
  //后台管理员表的操作
  public static final String manager_select =
      "select * from tb_manager order by id DESC"; //全部管理员查询
  public static final String manager_selectOne =
      "select * from tb_manager where id=?"; //以数据库流水号为条件查询管理员信息
  public static final String manager_insert =
      "insert into tb_manager values (?,?,?,?)";
  public static final String manager_updatePassword =
      "update tb_manager set password=? where account=?"; //修改管理员密码
  public static final String manager_delete =
      "delete from tb_manager where id=?"; //以数据库流水号为条件删除表中的信息
  public static final String manager_selectPassword =
      "select * from tb_manager where account=?"; //以管理员账号为条件查询管理员信息
  public static final String manager_update =
      "update tb_manager set account=?,password=?,name=? where id=?";
  //超级管理员修改其他管理信息

  //=============================================================================
  //对公告信息表的操作
  public static final String affiche_select =
      "select * from tb_affiche order by id DESC"; //对公告信息全部查询操作
  public static final String affice_insert =
      "insert into tb_affiche values (?,?,getDate())"; //对公告信息的添加
  public static final String affice_update =
      "update tb_affiche set name=?,content=? where id=?"; //以数据库流水号为条件公告信息的修改
  public static final String affice_delete =
      "delete from tb_affiche where id=?"; //以数据库流水号为条件删除表中的信息
  public static final String affice_selectOne =
      "select * from tb_affiche where id=?"; //以数据库流水号为条件查询表中的信息

//===============================================================================
  //对友情连接表的操作
  public static final String link_select =
      "select * from tb_link order by id DESC"; //对全部查询操作
  public static final String link_insert =
      "insert into tb_link values (?,?,?,getDate())"; //添加信息
  public static final String link_delete =
      "delete from tb_link where id=?"; //以数据库流水号为条件删除表中的信息
  public static final String link_selectOne =
      "select * from tb_link where id=?"; //以数据库流水号为条件查询表中的信息
  public static final String link_selectAddress =
      "select * from tb_link where linkAddress=?"; //以网站地址为条件为条件查询表中的信息
  public static final String link_selectName =
      "select * from tb_link where linkName=?"; //以网站名称为条件为条件查询表中的信息

  //================================================================================
  //对商品大类别表的操作
  public static final String big_select =
      "select * from tb_bigType order by id DESC"; //对全部查询操作
  public static final String big_insert =
      "insert into tb_bigType values (?,getDate())"; //添加信息
  public static final String big_delete =
      "delete from tb_bigType where id=?"; //以数据库流水号为条件删除表中的信息
  public static final String big_selectOne =
      "select * from tb_bigType where id=?"; //以数据库流水号为条件查询表中的信息
  public static final String big_update =
      "update tb_bigType set bigName=? where id=?"; //以数据库流水号为条件修改表中的信息

  //================================================================================
  //对商品小类别表的操作
  public static final String small_select =
      "select * from tb_smallType order by id DESC"; //对全部查询操作
  public static final String small_insert =
      "insert into tb_smallType values (?,?,getDate())"; //添加信息
  public static final String small_delete =
      "delete from tb_smallType where id=?"; //以数据库流水号为条件删除表中的信息
  public static final String small_selectOne =
      "select * from tb_smallType where id=?"; //以数据库流水号为条件查询表中的信息
  public static final String small_update =
      "update tb_smallType set bigId=?,smallName=? where id=?"; //以数据库流水号为条件修改表中的信息
  public static final String small_selectBigId =
      "select * from tb_smallType where bigId=?"; //以外键编号为条件查询表中的信息

  //================================================================================
  //对商品表的操作
  public static final String goods_select =
      "select * from tb_goods order by id DESC"; //全部查询操作
  public static final String goods_selectBig =
      "select * from tb_goods where bigId=? order by id DESC"; //以商品的大类别为编号查询信息
  public static final String goods_selectSmall =
      "select * from tb_goods where smallId=? order by id DESC"; //以商品的小类别为条件查询信息
  public static final String goods_selectMark =
      "select * from tb_goods where mark=? order by id DESC"; //以商品是否特价为条件查询信息
  public static final String goods_selectOne =
      "select * from tb_goods where id=? order by id DESC"; //以商品的编号为条件查询信息
  public static final String goods_insert =
      "insert into tb_goods values (?,?,?,?,?,getDate(),?,?,?,?,?)"; //添加信息
  public static final String goods_delete = "delete from tb_goods where id=?"; //删除表中的信息
  public static final String goods_updatePirce =
      "update tb_goods set freePrice=?,mark=? where id=?"; //设置特价价格

  public static final String goods_updateNumber =
      "update tb_goods set number=number+? where id=?";
  //根据商品的ID修改购买数量

  //================================================================================
  //对前台会员表的操作
  public static final String member_select =
      "select * from tb_member order by id DESC"; //全部查询操作
  public static final String member_insert =
      "insert into tb_member values (?,?,?,?,?,?,?,?)"; //添加信息
  public static final String member_delete = "delete from tb_member where id=?"; //删除表中的信息
  public static final String member_update = "update tb_member set name=?,password=?,reallyName=?,age=?,profession=?,email=?,question=?,result=? where id=?"; //以数据库流水号为条件修改信息
  public static final String member_selectOne =
      "select * from tb_member where id=?"; //以数据库流水号为条件查询信息
  public static final String member_selectName =
      "select * from tb_member where name=?"; //以名称为条件查询信息
  public static final String member_selectFind =
      "select * from tb_member where name=? and result=?"; //找回密码用的SQL语句
  public static final String member_updatePassword =
      "update tb_member set password=? where id=?"; //修改会员密码

  //================================================================================
  //对前台会员订货表的操作
  public static final String order_insert =
      "insert into tb_order values (?,?,?,?,?,?,?,?,?,getDate())"; //添加操作
  public static final String order_selectSign =
      "select * from tb_order where sign=?"; //以订货标记为条件查询信息

  //================================================================================
  //对前台会员订货明仔细表的操作
  public static final String orderDetail_insert =
      "insert into tb_orderDetail values (?,?,?,?)"; //添加操作
  public static final String orderDetail_selectNumber =
      "select * from tb_orderDetail where number=?"; //以订货编号为条件查询信息
}