sceninfobean.java

这是jsp通用模块导航的程序原代码,里面有新闻,bbs等jsp与javabean结合的程序.

package com.wxpn.tutorial.ec.bean;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.wxpn.tutorial.db.ConnectionPool;
import com.wxpn.tutorial.db.DB;

/**
 * 描述: 描述信息管理类
 * 
 * @author 
 */

public class ScenInfoBean {

	

	public Scen getContent(String id) {
		// 创建数据库连接对象：
		ConnectionPool connPool = DB.getConnPool();
		Connection conn = connPool.getConnection();
		Statement stmt = null;
		ResultSet rs = null;
		try {
			// 创建数据记录集对象：
			stmt = conn.createStatement();

			// sql语句：
			String sql = "select * from scentable where scenid = '" + id + "'";
			// 执行sql语句：
			System.out.println(sql);
			rs = stmt.executeQuery(sql);
			Scen scen = null;
			if (rs.next()) {
				scen = new Scen();
				scen.setId(id);
				scen.setScenName(rs.getString("scenname"));
				scen.setCityId(rs.getInt("cityid"));
				scen.setContent(rs.getString("SCENCONTENT"));
				scen.setImage(rs.getString("IMAGE"));

				return scen;
			}
			return scen;
		} catch (SQLException sqlExc) {
			sqlExc.printStackTrace();
			return null;
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		} finally {
			// 关闭连接，释放数据库资源：
			try {
				if (stmt != null) {
					stmt.close();
				}
				connPool.freeConnection(conn);
			} catch (SQLException sqlExc) {
				sqlExc.printStackTrace();
			}
		}
	}

	
}