?? gooddao.java
字號:
package com.shopping.dao;
import java.sql.*;
import java.util.*;
import com.comm.db.*;
import com.comm.vo.*;
public class GoodDao {
public void add(GenericVO gvo) throws SQLException {
String goodsId = gvo.getItemStr("GOODS_ID");
String item = gvo.getItemStr("ITEM");
String sql = "INSERT INTO good (goods_id, item) VALUES (?, ?)";
Vector param = new Vector();
param.addElement(goodsId);
param.addElement(item);
DBFactory.getDBI().execute(sql, param);
}
public void delete(int goodId) throws SQLException {
String sql = "DELETE FROM good WHERE good_id=" + goodId;
DBFactory.getDBI().execute(sql);
}
public Vector getByItem(String item) throws SQLException {
String sql =
"SELECT gs.*, g.good_id, b.logo1, gt.goodstype_id, gt.typename " +
"FROM good g, goods gs, brand b, goodstype gt " +
"WHERE gs.brand_id=b.brand_id AND gs.goodstype_id2=gt.goodstype_id " +
"AND g.goods_id=gs.goods_id AND g.item='" +
item + "' ORDER BY g.good_id DESC";
return DBFactory.getDBI().getResult(sql);
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -