parameterbo.java

利用MVC在WEB页面中实现参数的增加,删除,查询,更新.

package com.hwadee.business;


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

import com.hwadee.datasource.DBConnection;
import com.hwadee.datasource.DBUtil;
import com.hwadee.javabean.ParameterBean;

public class ParameterBO {

	public int insertByParameter(ParameterBean parameter) {
		String sql = "insert into parameter (name,writedate,fvalue) values (?,?,?)";

		Connection con = DBConnection.getConnection();
		PreparedStatement pstmt = null;

		int count = 0;
		try {
			pstmt = con.prepareStatement(sql);

			pstmt.setString(1, parameter.getName());
			pstmt.setDate(2, parameter.getWritedate());
			pstmt.setFloat(3, parameter.getFvalue());

			count = pstmt.executeUpdate();

			DBUtil.close(pstmt);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(con);
		}
		return count;
	}

	public int updateParameter(ParameterBean parameter) {
		String sql = "update parameter set name=?,writedate=?,fvalue=? where id=? ";

		Connection con = DBConnection.getConnection();
		PreparedStatement pstmt = null;
		int count = 0;
		try {
			pstmt = con.prepareStatement(sql);

			pstmt.setString(1, parameter.getName());
			pstmt.setDate(2, parameter.getWritedate());
			pstmt.setFloat(3, parameter.getFvalue());
			pstmt.setInt(4, parameter.getId());

			count = pstmt.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(pstmt);
			DBUtil.close(con);
		}

		return count;
	}

	public int deleteByID(int id) {
		String sql = "delete from parameter where id=? ";

		Connection con = DBConnection.getConnection();
		PreparedStatement pstmt = null;

		int count = 0;
		try {
			pstmt = con.prepareStatement(sql);

			pstmt.setInt(1, id);

			count = pstmt.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(pstmt);
			DBUtil.close(con);
		}

		return count;
	}

	public ParameterBean selectParameterById(int id) {
		String sql = "select id,name,fvalue,writedate from parameter where id=?";

		Connection con = DBConnection.getConnection();
		PreparedStatement pstmt = null;
		ParameterBean pdBean = null;
		try {
			pstmt = con.prepareStatement(sql);

			pstmt.setInt(1, id);

			ResultSet rs = pstmt.executeQuery();

			if (rs.next()) {
				pdBean = new ParameterBean();

				pdBean.setId(rs.getInt("id"));
				pdBean.setName(rs.getString("name"));
				pdBean.setFvalue(rs.getFloat("fvalue"));
				pdBean.setWritedate(rs.getDate("writedate"));
			}
			DBUtil.close(rs);
			

		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(pstmt);
			DBUtil.close(con);
		}

		return pdBean;
	}
	
	public List selectAllParameter() {
		String sql = "select id,name,fvalue,writedate from parameter ";

		Connection con = DBConnection.getConnection();
		PreparedStatement pstmt = null;
		List list = new ArrayList();
		
		try {
			pstmt = con.prepareStatement(sql);

			ResultSet rs = pstmt.executeQuery();
			while (rs.next()) {
				ParameterBean pdBean = new ParameterBean();

				pdBean.setId(rs.getInt("id"));
				pdBean.setName(rs.getString("name"));
				pdBean.setFvalue(rs.getFloat("fvalue"));
				pdBean.setWritedate(rs.getDate("writedate"));
				
				list.add(pdBean);
			}
			DBUtil.close(rs);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.close(pstmt);
			DBUtil.close(con);
		}

		return list;
	}

	
	public static void main(String[] args) {
		ParameterBean bean = new ParameterBean();
		bean.setName("demo1");
		bean.setWritedate(java.sql.Date.valueOf("2008-01-02"));
		bean.setFvalue(1.1f);

		ParameterBO bo = new ParameterBO();
		int count = bo.insertByParameter(bean);
		System.out.println("count: " + count);
		
//		bean.setId(1);
//		ParameterBO bo = new ParameterBO();
//		int count = bo.updateParameter(bean);
//		System.out.println("count: " + count);
		
//		ParameterBO bo = new ParameterBO();
//		int count = bo.deleteByID(2);
//		System.out.println("count=" + count);
		
//		 ParameterBean testBean = bo.selectParameterById(1);
//		 System.out.println("name=" + testBean.getName());

//		ParameterBO bo = new ParameterBO();
//		 ParameterBean testBean = bo.selectParameterById(1);
//		 System.out.println("name=" + testBean.getName());
		 
//		ParameterBO bo = new ParameterBO();
		 List list = bo.selectAllParameter();
		 System.out.println("list length: " + list.size());
		 for(int i = 0; i < list.size(); i++) {
			 ParameterBean testBean = (ParameterBean)list.get(i);
			 System.out.println(testBean.getName());
		 }
	}
}