简单servlet书写

package ss.jktj;


import java.io.IOException;
import java.io.PrintWriter;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;


import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;


import DBHelp.DBHelp;


import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;


/**
 * Servlet implementation class jktj
 */
@WebServlet("/jktj")
public class jktj extends HttpServlet {
private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public jktj() {
        super();
        // TODO Auto-generated constructor stub
    }


/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/


/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
       HttpSession session=request.getSession();
       if (session.getAttribute("sJgdm").toString().equals("")){
        return;
       }
request.setCharacterEncoding("utf-8");
       response.setContentType("text/html;charset=utf-8");
       PrintWriter out = response.getWriter();
       String ActionName=(String)request.getParameter("ActionName");
       
       if (ActionName.equals("查询")==true){
        chaxun(request,response,out);
       }
       else if (ActionName.equals("查询明细")==true){
        chaxunmingxi(request,response,out);
       }
       else if (ActionName.equals("确定缴款")==true){
        quedingjiaokuan(request,response,out);
       }
       else if (ActionName.equals("打印")==true){
        print(request,response,out);
       }
       else if (ActionName.equals("查询未确认医保数据")==true){
        cxwqy(request,response,out);
       }
       else{
        out.print("0");
       }
          
}
protected void cxwqy(HttpServletRequest request, HttpServletResponse response, PrintWriter out2) throws ServletException, IOException {
       HttpSession session=request.getSession();    
request.setCharacterEncoding("utf-8");
       response.setContentType("text/html;charset=utf-8");
       PrintWriter out = response.getWriter();
       String jyls=(String)request.getParameter("jyls");      
       String jyyzm=(String)request.getParameter("jyyzm"); 
    String sJgdm=(String)session.getAttribute("sJgdm");
      String first_day=(String)request.getParameter("first_day");
      String last_day=(String)request.getParameter("last_day");
       DBHelp help=null;
CallableStatement stmt = null;
Connection conn = null; 
Integer iCount=0;
ResultSetMetaData dataColumns=null;
ResultSet dataset=null;
try {
help=new DBHelp();
conn = help.GetConnect();
stmt = conn.prepareCall("{call SS_JKTJ_YBDZ(?,?,?,?,?)}",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);

stmt.setString(1, jyls);
stmt.setString(2,jyyzm);
stmt.setString(3,sJgdm);
stmt.setString(4,first_day);
stmt.setString(5,last_day);
dataset=stmt.executeQuery();

if (dataset.next()==true) {
dataset.last();
iCount=dataset.getRow();
dataset.first();

dataColumns=dataset.getMetaData();



JSONArray rows = new JSONArray();


JSONObject cell = null;
   for(int i=1;i<=iCount;i++){
       cell = new JSONObject();
       for (int iColumnIndex=1;iColumnIndex<=dataColumns.getColumnCount();iColumnIndex++){
        //System.out.println("返回的数据;"+dataColumns.getColumnName(iColumnIndex)+"----"+dataset.getString(iColumnIndex));
        cell.put(dataColumns.getColumnName(iColumnIndex),dataset.getObject(iColumnIndex));
       }
       rows.add(cell);
       dataset.next();
   }

   out.print( rows.toString());
 
 
}
} catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println("返回的数据："+e.getMessage());
e.printStackTrace();
}finally {
DBHelp.CloseConnect( dataset, stmt, conn);
}         
}
protected void chaxun(HttpServletRequest request, HttpServletResponse response, PrintWriter out2) throws ServletException, IOException {
        HttpSession session=request.getSession();
        if (session.getAttribute("sJgdm").toString().equals("")){
        return;
        }
request.setCharacterEncoding("utf-8");
        response.setContentType("text/html;charset=utf-8");
        PrintWriter out = response.getWriter();
        String first_day=(String)request.getParameter("first_day");
        String last_day=(String)request.getParameter("last_day");
        //System.out.println("day:"+day);
        DBHelp help=null;
CallableStatement stmt = null;
Connection conn = null; 
Integer iCount=0;
ResultSetMetaData dataColumns=null;
ResultSet dataset=null;
String sJgdm=(String)session.getAttribute("sJgdm");
String sUserName=(String)session.getAttribute("sUserName");
String sUserId=(String)session.getAttribute("sUserId");
try {
help=new DBHelp();
conn = help.GetConnect(); 
stmt = conn.prepareCall("{call SS_JKTJ_SELECT(?,?,?,?,?)}",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
stmt.setString(1, first_day);
//System.out.println("first_day" + first_day);
stmt.setString(2, last_day);
//System.out.println("last_day" + last_day);
stmt.setString(3, sJgdm);
//System.out.println("sJgdm" + sJgdm);

//System.out.println("sUserName" + sUserName);
stmt.setString(4, sUserId);
stmt.setString(5, sUserName);
dataset=stmt.executeQuery();
//System.out.println("返回的数据：\n" + dataset);
if (dataset.next()==true) {

dataset.last();
iCount=dataset.getRow();
dataset.first();

dataColumns=dataset.getMetaData();


JSONObject jsonObj = new JSONObject();
JSONArray rows = new JSONArray();

   /*/ 根据jqGrid对JSON的数据格式要求给jsonObj赋值
   jsonObj.put("当前页", 1);                // 当前页
   jsonObj.put("总页数", Math.ceil(iCount/100));        // 总页数
   jsonObj.put("记录数", iCount);        // 总记录数
   / 定义rows，存放数据*/
JSONObject cell = null;
   for(int i=1;i<=iCount;i++){
       cell = new JSONObject();
       for (int iColumnIndex=1;iColumnIndex<=dataColumns.getColumnCount();iColumnIndex++){
        //System.out.println("返回的数据;"+dataColumns.getColumnName(iColumnIndex)+"----"+dataset.getString(iColumnIndex));
        cell.put(dataColumns.getColumnName(iColumnIndex),dataset.getObject(iColumnIndex));
       }
       rows.add(cell);
       dataset.next();
   }
   jsonObj.put("rows", rows);
  //out.print( rows.toString());
  // System.out.println(sJgxx+"===返回的数据：\n" + jsonObj.toString());
   out.print(jsonObj.toString());
 
}
} catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println("返回的数据："+e.getMessage());
e.printStackTrace();
} finally {
DBHelp.CloseConnect( dataset, stmt, conn);
}          
}
protected void chaxunmingxi(HttpServletRequest request, HttpServletResponse response, PrintWriter out2) throws ServletException, IOException {
        HttpSession session=request.getSession();
        if (session.getAttribute("sJgdm").toString().equals("")){
        return;
        }
request.setCharacterEncoding("utf-8");
        response.setContentType("text/html;charset=utf-8");
        PrintWriter out = response.getWriter();
        String first_time=(String)request.getParameter("first_time");
        String last_time=(String)request.getParameter("last_time");
        DBHelp help=null;
CallableStatement stmt = null;
Connection conn = null; 
Integer iCount=0;
ResultSetMetaData dataColumns=null;
ResultSet dataset=null;
String sJgdm=(String)session.getAttribute("sJgdm");
String sUserName=(String)session.getAttribute("sUserName");
String sUserId=(String)session.getAttribute("sUserId");
try {
help=new DBHelp();
conn = help.GetConnect();
stmt = conn.prepareCall("{call SS_JKTJ_JIESUAN(?,?,?,?,?)}",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);

stmt.setString(1, sJgdm);
stmt.setString(2,first_time);
stmt.setString(3,last_time);
stmt.setString(4, sUserName);
stmt.setString(5,sUserId);
dataset=stmt.executeQuery();
if (dataset.next()==true) {
dataset.last();
iCount=dataset.getRow();
dataset.first();
dataColumns=dataset.getMetaData();
JSONArray rows = new JSONArray();
JSONObject cell = null;
   for(int i=1;i<=iCount;i++){
       cell = new JSONObject();
       for (int iColumnIndex=1;iColumnIndex<=dataColumns.getColumnCount();iColumnIndex++){
        //System.out.println("返回的数据;"+dataColumns.getColumnName(iColumnIndex)+"----"+dataset.getString(iColumnIndex));
        cell.put(dataColumns.getColumnName(iColumnIndex),dataset.getObject(iColumnIndex));
       }
       rows.add(cell);
       dataset.next();
   }
   out.print( rows.toString());
 
}
} catch (SQLException e) {
System.out.println("返回的数据："+e.getMessage());
e.printStackTrace();
}finally {
DBHelp.CloseConnect( dataset, stmt, conn);
}         
}
protected void quedingjiaokuan(HttpServletRequest request, HttpServletResponse response, PrintWriter out2) throws ServletException, IOException {
        HttpSession session=request.getSession();
        if (session.getAttribute("sJgdm").toString().equals("")){
        return;
        }
request.setCharacterEncoding("utf-8");
        response.setContentType("text/html;charset=utf-8");
        PrintWriter out = response.getWriter();
        String InpRenshu=(String)request.getParameter("InpRenshu");
        String first_time=(String)request.getParameter("first_time");
        String last_time=(String)request.getParameter("last_time");
        DBHelp help=null;
CallableStatement stmt = null;
Connection conn = null; 
Integer iCount=0;
ResultSetMetaData dataColumns=null;
ResultSet dataset=null;
String sJgdm=(String)session.getAttribute("sJgdm");
String sCzy=(String)session.getAttribute("sUserName");
String sUserId=(String)session.getAttribute("sUserId");
try {
help=new DBHelp();
conn = help.GetConnect(); 
stmt = conn.prepareCall("{call SS_JKTJ_UPDATA(?,?,?,?,?,?)}",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
stmt.setString(1, sJgdm);
stmt.setString(2, sCzy);
stmt.setString(3, sUserId);
stmt.setString(4, InpRenshu);
stmt.setString(5,first_time);
stmt.setString(6,last_time);
dataset=stmt.executeQuery();
if (dataset.next()==true) {
dataset.last();
iCount=dataset.getRow();
dataset.first();
dataColumns=dataset.getMetaData();
JSONArray rows = new JSONArray();
JSONObject cell = null;
   for(int i=1;i<=iCount;i++){
       cell = new JSONObject();
       for (int iColumnIndex=1;iColumnIndex<=dataColumns.getColumnCount();iColumnIndex++){
        cell.put(dataColumns.getColumnName(iColumnIndex),dataset.getObject(iColumnIndex));
       }
       rows.add(cell);
       dataset.next();
   }
   out.print( rows.toString());
}
} catch (SQLException e) {
System.out.println("出错啦："+e.getMessage());
e.printStackTrace();
}finally {
DBHelp.CloseConnect( dataset, stmt, conn);
}        
}
protected void print(HttpServletRequest request, HttpServletResponse response, PrintWriter out2) throws ServletException, IOException {
        HttpSession session=request.getSession();
        
        if (session.getAttribute("sJgdm").toString().equals("")){
        return;
        }
request.setCharacterEncoding("utf-8");
        response.setContentType("text/html;charset=utf-8");
        PrintWriter out = response.getWriter();
        String sJsdbh=(String)request.getParameter("InpJsdbh");
        DBHelp help=null;
CallableStatement stmt = null;
Connection conn = null; 
Integer iCount=0;
ResultSetMetaData dataColumns=null;
ResultSet dataset=null;
String sJgdm=(String)session.getAttribute("sJgdm");
String sUserName=(String)session.getAttribute("sUserName");
try {
help=new DBHelp();
conn = help.GetConnect(); 
stmt = conn.prepareCall("{call SS_JKTJ_DY(?,?,?)}",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
stmt.setString(1, sJgdm);
stmt.setString(2, sJsdbh);
stmt.setString(3, sUserName);
dataset=stmt.executeQuery();
if (dataset.next()==true) {
dataset.last();
iCount=dataset.getRow();
dataset.first();
dataColumns=dataset.getMetaData();
JSONArray rows = new JSONArray();
JSONObject cell = null;
   for(int i=1;i<=iCount;i++){
       cell = new JSONObject();
       for (int iColumnIndex=1;iColumnIndex<=dataColumns.getColumnCount();iColumnIndex++){
        cell.put(dataColumns.getColumnName(iColumnIndex),dataset.getObject(iColumnIndex));
       }
       rows.add(cell);
       dataset.next();
   }
   out.print( rows);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println("返回的数据："+e.getMessage());
e.printStackTrace();
} finally {
DBHelp.CloseConnect( dataset, stmt, conn);
}        
}
}