searchdatabean.java

struts构架例程基于struts的人事管理系统3.办公日志系统4.电子政务管理系统5.餐饮业进销存系

package com.dataquery.model;

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

import javax.servlet.http.HttpServletRequest;

import com.dataquery.util.Message;
import com.dataquery.util.Status;
import com.dataquery.util.TranString;

public class SearchDataBean implements ProcessData {

	public void execute(HttpServletRequest request, Status status)
			throws Exception {
		//得到数据
		String keyword = request.getParameter("keyword");
		
		//业务操作
		keyword = TranString.encoding(keyword);  //编码转换
		DBConnection db = new DBConnection();
		try {
			Connection conn = db.getConnection();
			String sql = "select * from swdj_comm";
			if ((keyword != null) && (keyword.length()!=0)){
				sql = "select * from swdj_comm where c_mc like ?";
			}
			PreparedStatement stmt = conn.prepareStatement(sql);
			if ((keyword != null) && (keyword.length()!=0)){
				stmt.setString(1,"%"+keyword+"%");
			}
			ResultSet rs = stmt.executeQuery();
			
			List list = new java.util.ArrayList();
			while (rs.next()){
				String qydm = rs.getString("c_qydm");
				String sbh = rs.getString("c_sbh");
				String mc = rs.getString("c_mc");
				String dz = rs.getString("c_dz");
				String telno = rs.getString("c_telno");
				String fddbr = rs.getString("c_fddbr");
				
				Message mess = new Message();
				mess.setQydm(qydm);
				mess.setSbh(sbh);
				mess.setMc(mc);
				mess.setDz(dz);
				mess.setTelno(telno);
				mess.setFddbr(fddbr);
				
				list.add(mess);
			}
			request.setAttribute("Result",list);  //将成功标记作为request属性存储
		} catch (SQLException e) {
			e.printStackTrace();
			Exception ex = new Exception("操作失败,请检查日志......");
			status.addException(ex);
			throw ex;  //表示该方法是发生异常,而非正常结束
		} finally {
			db.closeConnection();
		}
	}

}