package test2;
public class table {
private int sfsh;
private int bmsfsh;
private String xssh;
private String glcs;
private String bmsh;
private String jgmc;
private String txdz;
private String dwwz;
private String dzyx;
private String frdb;
private String yzbm;
private String lxr;
private String gddh;
private String yddh;
private String cz;
private String qyjg;
private String gkglbm;
private String jgjj;
private String jgxqmc;
private String qsxqnx;
private String xkfl;
private String xqjsssly;
private String jzxqnx;
private String szdy;
private int status;
private String qsxqmx;
private String city;
private String la;
private String sqjsssly;
private String datatime;
private int result;
private String path;
private String title;
private String owner;
private String receiver;
private String permissionId;
public String getJgmc() {
return jgmc;
}
public void setJgmc(String jgmc) {
this.jgmc = jgmc;
}
public String getTxdz() {
return txdz;
}
public void setTxdz(String txdz) {
this.txdz = txdz;
}
public String getDwwz() {
return dwwz;
}
public void setDwwz(String dwwz) {
this.dwwz = dwwz;
}
public String getDzyx() {
return dzyx;
}
public void setDzyx(String dzyx) {
this.dzyx = dzyx;
}
public String getFrdb() {
return frdb;
}
public void setFrdb(String frdb) {
this.frdb = frdb;
}
public String getYzbm() {
return yzbm;
}
public void setYzbm(String yzbm) {
this.yzbm = yzbm;
}
public String getLxr() {
return lxr;
}
public void setLxr(String lxr) {
this.lxr = lxr;
}
public String getGddh() {
return gddh;
}
public void setGddh(String gddh) {
this.gddh = gddh;
}
public String getYddh() {
return yddh;
}
public void setYddh(String yddh) {
this.yddh = yddh;
}
public String getCz() {
return cz;
}
public void setCz(String cz) {
this.cz = cz;
}
public String getQyjg() {
return qyjg;
}
public void setQyjg(String qyjg) {
this.qyjg = qyjg;
}
public String getGkglbm() {
return gkglbm;
}
public void setGkglbm(String gkglbm) {
this.gkglbm = gkglbm;
}
public String getJgjj() {
return jgjj;
}
public void setJgjj(String jgjj) {
this.jgjj = jgjj;
}
public String getJgxqmc() {
return jgxqmc;
}
public void setJgxqmc(String jgxqmc) {
this.jgxqmc = jgxqmc;
}
public String getJzxqmx() {
return jzxqmx;
}
public void setJzxqmx(String jzxqmx) {
this.jzxqmx = jzxqmx;
}
public String getZdkjxqgs() {
return zdkjxqgs;
}
public void setZdkjxqgs(String zdkjxqgs) {
this.zdkjxqgs = zdkjxqgs;
}
public String getGjz() {
return gjz;
}
public void setGjz(String gjz) {
this.gjz = gjz;
}
public String getYjlx() {
return yjlx;
}
public void setYjlx(String yjlx) {
this.yjlx = yjlx;
}
public String getHzms() {
return hzms;
}
public void setHzms(String hzms) {
this.hzms = hzms;
}
public String getYxdw() {
return yxdw;
}
public void setYxdw(String yxdw) {
this.yxdw = yxdw;
}
public String getQsxqnx() {
return qsxqnx;
}
public void setQsxqnx(String qsxqnx) {
this.qsxqnx = qsxqnx;
}
public String getXkfl() {
return xkfl;
}
public void setXkfl(String xkfl) {
this.xkfl = xkfl;
}
public String getXqjsssly() {
return xqjsssly;
}
public void setXqjsssly(String xqjsssly) {
this.xqjsssly = xqjsssly;
}
public String getJzxqnx() {
return jzxqnx;
}
public void setJzxqnx(String jzxqnx) {
this.jzxqnx = jzxqnx;
}
public String getZze() {
return zze;
}
public void setZze(String zze) {
this.zze = zze;
}
public String getZe() {
return ze;
}
public void setZe(String ze) {
this.ze = ze;
}
public String getSzdy() {
return szdy;
}
public void setSzdy(String szdy) {
this.szdy = szdy;
}
public String getQsxqmx() {
return qsxqmx;
}
public void setQsxqmx(String qsxqmx) {
this.qsxqmx = qsxqmx;
}
public String getCity() {
return city;
}
public void setCity(String city) {
this.city = city;
}
public String getLa() {
return la;
}
public void setLa(String la) {
this.la = la;
}
public String getSqjsssly() {
return sqjsssly;
}
public void setSqjsssly(String sqjsssly) {
this.sqjsssly = sqjsssly;
}
public int getStatus() {
return status;
}
public void setStatus(int status) {
this.status = status;
}
public String getDatatime() {
return datatime;
}
public void setDatatime(String datatime) {
this.datatime = datatime;
}
public int getResult() {
return result;
}
public void setResult(int result) {
this.result = result;
}
public String getPath() {
return path;
}
public void setPath(String path) {
this.path = path;
}
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String getOwner() {
return owner;
}
public void setOwner(String owner) {
this.owner = owner;
}
public String getReceiver() {
return receiver;
}
public void setReceiver(String receiver) {
this.receiver = receiver;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getPermissionId() {
return permissionId;
}
public void setPermissionId(String permissionId) {
this.permissionId = permissionId;
}
public int getSfsh() {
return sfsh;
}
public void setSfsh(int sfsh) {
this.sfsh = sfsh;
}
public int getBmsfsh() {
return bmsfsh;
}
public void setBmsfsh(int bmsfsh) {
this.bmsfsh = bmsfsh;
}
public String getXssh() {
return xssh;
}
public void setXssh(String xssh) {
this.xssh = xssh;
}
public String getBmsh() {
return bmsh;
}
public void setBmsh(String bmsh) {
this.bmsh = bmsh;
}
public String getGlcs() {
return glcs;
}
public void setGlcs(String glcs) {
this.glcs = glcs;
}
private String jzxqmx;
private String zdkjxqgs;
private String gjz;
private String yjlx;
private String hzms;
private String yxdw;
private String ze;
private String zze;
private int id;
}
package test2;
import java.io.IOException;
import java.util.ArrayList;
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 test2.table;
import test2.DBUtil;
/**
* Servlet implementation class queryTable
*/
@WebServlet("/queryTable")
public class queryTable extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public queryTable() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
request.setCharacterEncoding("utf-8");
String type=request.getParameter("type");
if(type.equals("all"))
{
ArrayList<table> list=DBUtil.gettables("all");
request.setAttribute("list", list);
request.getRequestDispatcher("chaxun.jsp").forward(request, response);
}
else
{
String value=request.getParameter("value");
System.out.println(value);
if(value.length()!=0) {
ArrayList<table> list=DBUtil.getDocesByCase(type,value);
request.setAttribute("list", list);
request.getRequestDispatcher("chaxun.jsp").forward(request, response);
}
else {
ArrayList<table> list=DBUtil.gettables("all");
request.setAttribute("list", list);
request.getRequestDispatcher("chaxun.jsp").forward(request, response);
}
}
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
}