?? favoritedao.java
字號:
package com.shopping.dao;
import java.sql.*;
import java.util.*;
import com.comm.db.*;
import com.comm.vo.*;
public class FavoriteDao {
public void add(GenericVO gvo) throws SQLException {
String userId = gvo.getItemStr("USER_ID");
String goods_id = gvo.getItemStr("GOODS_ID");
Vector param = new Vector();
String sql = "INSERT INTO favorite (user_id, goods_id) VALUES (?, ?)";
param.addElement(userId);
param.addElement(goods_id);
DBFactory.getDBI().execute(sql, param);
}
public void delete(int favoriteId) throws SQLException {
String sql = "DELETE FROM favorite WHERE favorite_id=" + favoriteId;
DBFactory.getDBI().execute(sql);
}
public ListVO search(GenericVO gvo) throws SQLException {
String userId = gvo.getItemStr("USER_ID");
Vector param = new Vector();
StringBuffer sb = new StringBuffer();
sb.append("SELECT f.*, gs.name, gs.price2, gs.sphoto, b.logo1 " +
"FROM favorite f, goods gs, brand b " +
"WHERE f.goods_id=gs.goods_id AND gs.brand_id=b.brand_id ");
if (userId.length() > 0) {
sb.append(" AND user_id = ? ");
param.addElement(userId);
}
sb.append(" ORDER BY favorite_id DESC");
return DBFactory.getDBI().getResult(sb.toString(), param,
gvo.getListVO());
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -