merchantstorebulletindao.java

基于struts的网上商店源码

package com.mole.struts.dao;

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

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

public class MerchantStoreBulletinDAO {
	private Connection conn;

	public MerchantStoreBulletinDAO() {
		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();
			conn.setAutoCommit(true);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public String[] getBulletin(String bid) {
		String[] str = new String[3];
		ResultSet rs = null;
		String sql = "SELECT [Name],CONVERT(char(20),[CreateDate],120),[Content] FROM [MerchantBulletin] WHERE [ID]="
				+ bid;
		try {
			rs = conn.prepareStatement(sql).executeQuery();
			if (rs.next()) {
				str[0] = rs.getString(1);
				str[1] = rs.getString(2);
				str[2] = rs.getString(3);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return str;
	}

}