servernet示例

package com.sunsheen.bucm.web.aboutmuseum;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.hibernate.SQLQuery;
import org.hibernate.transform.Transformers;

import com.google.gson.Gson;
import com.sunsheen.jfids.system.base.composite.data.query.QueryParameterImpl;
import com.sunsheen.jfids.system.database.IdsSession;
import com.sunsheen.jfids.system.servlet.Servlet;
import com.sunsheen.jfids.util.IdsDataBaseUtil;
@Servlet(value=”/CurrentLeaders.svt”, anonymous=true)
public class CurrentLeadersListServlet extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 3244153105604223213L;

@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    // TODO Auto-generated method stub
    response.setCharacterEncoding("utf-8");
    request.setCharacterEncoding("utf-8");
    response.setContentType("text/plain;charset=utf-8");
    PrintWriter out = response.getWriter();     
    //获取请求参数
    String keywords = request.getParameter("keywords");//关键字
    String page_num=request.getParameter("page_num");//获取每页数量
    String locat_num=request.getParameter("locat_num");//获取查询起始数
    String test=request.getParameter("test");//获取查询起始数
    String id = request.getParameter("id");//关键字
    /*将参数放入的map中*/
    Map<String, String> map = new HashMap<String, String>(); 
    map.put("page_num",page_num);
    map.put("locat_num",locat_num);
    if(!(keywords==null || keywords.isEmpty())){
        map.put("keywords",keywords);
    }
    if(!(id==null || id.isEmpty())){
        map.put("id",id);
    }
    IdsSession session = IdsDataBaseUtil.getHibernateSession();
    session.beginTransaction();

    try {
        if(test.equals("1")){//初始化分页
                if(!(id==null || id.isEmpty())){

                    String sql1="SELECT bucm_leader_id AS id, name, position, position_detail AS detail, relation_id AS headPortrait, creation_date AS date, concat('Images/', relation_id) AS server_name FROM bucm_leader WHERE bucm_leader_id = :id";
                    SQLQuery query1 = session.createSQLQuery(sql1);
                    new QueryParameterImpl().initParameter(query1, map);//将组装好的map传入
                    List<Map> rs1 = query1.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();
                    String data = new Gson().toJson(rs1);
                    out.print(data);

                }else{
                    SQLQuery query1 = session.createDySQLQuery("SelectAboutMuseum.selectCurrentLeaders",map);
                    new QueryParameterImpl().initParameter(query1 , map);
                    List<Map> rs2 = query1.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();
                    String data = new Gson().toJson(rs2);
                    out.print(data);
                }


        }else if(test.equals("0")){//点击分页 事件

                SQLQuery query1 = session.createDySQLQuery("SelectAboutMuseum.selectCurrentLeaders",map);
                new QueryParameterImpl().initParameter(query1 , map);
                List<Map> rs2 = query1.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();

                String data = new Gson().toJson(rs2);
                out.print(data);
        }
    }catch (Exception e) {
        session.rollback();
    }finally{
        session.close();//关闭事务
    }
}

}