merchantstoregoodsdetaildao.java

基于struts的网上商店源码

//张建
package com.mole.struts.dao;

import java.sql.Connection;
import java.sql.ResultSet;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;

import com.mole.struts.bean.MerchantGoodsBean;

public class MerchantStoreGoodsDetailDAO {
	private Connection conn;

	public MerchantStoreGoodsDetailDAO() {
		try {
			Context ctx = new InitialContext();
			if (ctx == null)
				throw new Exception("Failed to initial context!");
			DataSource ds = (DataSource) ctx
					.lookup("java:comp/env/jdbc/crmdata");
			conn = ds.getConnection();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public MerchantGoodsBean getGoodsDetail(String gid) {
		MerchantGoodsBean bean = new MerchantGoodsBean();
		ResultSet rs = null;
		String sql = "SELECT [Name],[StoreName],[GoodsTypeName],[Price],[Description],[Amount],[TotalAmount],[Image] FROM [v_StoreGoods] WHERE [ID]="
				+ gid;
		try {
			rs = conn.prepareStatement(sql).executeQuery();
			if (rs.next()) {
				bean.setName(rs.getString(1));
				bean.setStoreName(rs.getString(2));
				bean.setGoodsTypeName(rs.getString(3));
				bean.setPrice(rs.getString(4));
				bean.setDescription(rs.getString(5).trim());
				bean.setAmount(rs.getString(6));
				bean.setTotalAmount(rs.getString(7));
				bean.setImage(rs.getString(8).trim());
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return bean;
	}

}