毕业论文目录及正文等(9)

毕业论文（设计）

list.add(product);

24

* 当前页数 * @return 显示产品的列表 */

public List showProductForPage(int page) {

List list = new ArrayList(); int number = 0; if (page > 1) { }

String sql = \

+ PAGE_NUM

+ \ productID not in ( select top \+ number

+ \productID from product order by productID desc ) order by productID number = PAGE_NUM * (page - 1);

desc\

try {

conn = this.getConn();

pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while (rs.next()) {

Product product = new Product();

product.setProductID(rs.getInt(\

product.setSerialNumber(rs.getString(\product.setName(rs.getString(\product.setBrand(rs.getString(\product.setModel(rs.getString(\product.setPrice(rs.getDouble(\product.setPicture(rs.getString(\product.setDescription(rs.getString(\

毕业论文（设计）

/**

* 添加产品信息 *

* @param product

* 封装了信息的产品对象 * @return 执行SQL语句所影响数据库的行数 */

public int insertProduct(Product product) {

25

} /**

}

}

e.printStackTrace(); this.closeAll(conn, pstmt, rs);

} catch (Exception e) { } finally {

return list;

* 根据产品ID删除相关产品信息 *

* @param productID * 产品ID

* @return 执行SQL语句影响数据库的行数 */

public int deleteProductByID(String productID) { }

String sql = \String[] param = new String[] { productID }; int count = this.executeSQL(sql, param); return count;

毕业论文（设计）

}

} /**

String sql = \

+ \

product.getName(), product.getBrand(), product.getModel(), product.getPicture(), product.getDescription() };

String[] param = new String[] { product.getSerialNumber(),

return this.executeSQL(sql, param);

* 根据商品ID和对象参数修改商品信息 * @param product封装了数据的商品对象 * @return 返回执行SQL语句，数据库影响行数 */

public int updateProduct(Product product) { }

String sql = \

+ product.getPrice()

+ \+ product.getProductID();

product.getName(), product.getBrand(), product.getModel(), product.getPicture(), product.getDescription() };

String[] param = new String[] { product.getSerialNumber(),

return this.executeSQL(sql, param);

（3）客户留言

在导航菜单中点击“客户留言”可链接到客户留言的功能模块．如图4.5所示

26

毕业论文（设计）

图 4.6 客户留言

代码实现如下： package s2jsp.bysj.dao;

import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List;

import s2jsp.bysj.entity.Message;

public class MessageDao extends BaseDao {

27

private Connection conn = null; private PreparedStatement pstmt = null; private ResultSet rs = null;

毕业论文（设计）

} return list;

28

public int insertMessage(Message message) { }

public List selectMessage() {

List list = new ArrayList();

String sql = \try {

conn = this.getConn();

pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while (rs.next()) { }

e.printStackTrace(); this.closeAll(conn, pstmt, rs);

Message message = new Message();

message.setMessageID(rs.getInt(\message.setTitle(rs.getString(\message.setContent(rs.getString(\message.setWriter(rs.getString(\message.setWriteDate(rs.getString(\message.setCount(rs.getInt(\list.add(message);

String sql = \String[] param = new String[] { message.getTitle(),

return this.executeSQL(sql, param);

message.getContent(), message.getWriter(), message.getWriteDate() };

} catch (Exception e) { } finally {