基于javaweb+mysql的jsp+servlet火车票网上订票系统(前台、后台)(java+jsp+servlet+javabean+mysql+tomcat)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计，大作业，毕业设计，项目练习，学习演示等
功能说明
前台功能：用户查询车票信息、登录注册、购票、查看已购车票、修改密码等功能。
后台功能：管理员管理、用户管理、火车信息管理、站点信息管理、线路信息管理、车票信息管理、购票信息管理等。
后台：
前台
技术框架
JSP Servlet MySQL JDBC Tomcat CSS JavaScript
基于javaweb+mysql的JSP+Servlet火车票网上订票系统(前台、后台)(java+jsp+servlet+javabean+mysql+tomcat)
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//设置传输数据编码方式
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html");
HttpSession session=request.getSession();
//获取使用者信息
Object userid=session.getAttribute("userid");
Object utype=session.getAttribute("utype");
//创建json对象
JSONObject json=new JSONObject();
String sql=request.getParameter("sql");
if(userid==null||utype==null){
json.put("msg", "请重新登陆");
}else{
HandleProperties hp=new HandleProperties(session,utype+""+userid);
hp.setValue("sql", sql);
json.put("msg", 1);
}
PrintWriter out=response.getWriter();
out.print(json.toString());
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
/**
* Constructor of the object.
*/
public Add() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//设置传输数据编码方式
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html");
HttpSession session=request.getSession();
//获取当前登录用户信息
Object utype=session.getAttribute("utype");
Object userid=session.getAttribute("userid");
//创建json对象
String cz=request.getParameter("cz");
String znums=request.getParameter("znums");
String xcnums=request.getParameter("xcnums");
String traintype=request.getParameter("traintype");
String ids=request.getParameter("idi");
ResultSet rs=db.query("select id from traininfo where tname='"+tnames+"'");
if(rs!=null){
boolean bl=false;
int id=-1;
try {
while(rs.next()){
id=rs.getInt("id");
if(!String.valueOf(id).equals(ids)){
bl=true;
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if(bl){
json.put("msg", "车次已注册");
}else{
int bls=db.deleteOrUpdate("update traininfo set tname='"+tnames+"', cz='"+cz+"' ,traintype='"+traintype+"',znums="+znums+",xcnums="+xcnums+" where id="+ids);
if(bls>0){
json.put("msg", "修改成功。");
}else{
json.put("msg", "修改失败");
}
}
}else{
json.put("msg", "操作错误01");
}
}
//站点信息修改
if("zhandian".equals(tname)){
String zdname=request.getParameter("zdname");
String ids=request.getParameter("idi");
ResultSet rs=db.query("select id from zhandian where zdname='"+zdname+"'");
if(rs!=null){
boolean bl=false;
int id=-1;
try {
while(rs.next()){
id=rs.getInt("id");
if(!String.valueOf(id).equals(ids)){
bl=true;
}
}
if(rs!=null){
boolean bl=false;
int id=-1;
try {
while(rs.next()){
id=rs.getInt("id");
if(!String.valueOf(id).equals(ids)){
bl=true;
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if(bl){
json.put("msg", "站点名称已存在");
}else{
int bls=db.deleteOrUpdate("update zhandian set zdname='"+zdname+"' where id="+ids);
if(bls>0){
json.put("msg", "修改成功。");
}else{
json.put("msg", "修改失败");
}
}
}else{
json.put("msg", "操作错误01");
}
}
//车票信息修改
if("piao".equals(tname)){
String tid=request.getParameter("tid");
String szdid=request.getParameter("szdid");
String ezdid=request.getParameter("ezdid");
String stime=request.getParameter("stime");
String pval=request.getParameter("pval");
String ptype=request.getParameter("ptype");
String cxzh=request.getParameter("cxzh");
String yxsj=request.getParameter("yxsj");
String ids=request.getParameter("idi");
int bls=db.deleteOrUpdate("update piao set yxsj='"+yxsj+"', cxzh='"+cxzh+"' ,ptype='"+ptype+"',pval="+pval+", stime='"+stime+"', tid="+tid+",szdid="+szdid+",ezdid="+ezdid+" where id="+ids);
if(bls>0){
json.put("msg", "修改成功。");
}else{
json.put("msg", "修改失败");
}
}
PrintWriter out=response.getWriter();
ResultSet rs2=db2.query("select zhandian.*,xh from xianlu,zhandian where xianlu.zdid=zhandian.id and xianlu.tid="+t.getId()+" order by xh");
List<Zhandian> zdlist=FindService.getZhandian(rs2);
xl.setZdlist(zdlist);
xllist.add(xl);
}
request.setAttribute("alist", xllist);
request.getRequestDispatcher("/admin/initxianlu.jsp").forward(request, response);
return;
}
//线路信息管理初始化
if("xianlu".equals(tname)){
String ids=request.getParameter("tid");
if("1".equals(flgs)){
sql="select zhandian.*,xh from zhandian,xianlu where zhandian.id=xianlu.zdid and xianlu.tid="+ids+" order by xh";
hp.setValue("sql", sql);
}else{
sql=hp.readValue("sql");
}
ResultSet rs=db.query(sql);
List<Zhandian> zlist=FindService.getZhandians(rs);
request.setAttribute("alist", zlist);
DbConn db2=new DbConn();
ResultSet rs2=db2.query("select * from zhandian where id not in(select zdid from xianlu where tid="+ids+")");
List<Zhandian> zdlist=FindService.getZhandian(rs2);
request.setAttribute("zdlist", zdlist);
DbConn db3=new DbConn();
Object tn=db3.getOnlyOne("select tname from traininfo where id="+ids);
Traininfo t=new Traininfo();
t.setId(Integer.parseInt(ids));
t.setTname(tn+"");
request.setAttribute("t", t);
request.getRequestDispatcher("/admin/mgxianlu.jsp").forward(request, response);
return;
}
//车票信息管理初始化
if("piao".equals(tname)){
String ids=request.getParameter("tid");
if("1".equals(flgs)){
sql="select tmp.*,zdname as eaddr,tname,traintype from (select piao.*,zdname as saddr from piao,zhandian where piao.szdid=zhandian.id and yxsj='1975-01-01' and zdname like '%0%') tmp,zhandian,traininfo where tmp.tid=traininfo.id and tmp.ezdid=zhandian.id and zdname like '%0%' and 1=0";
hp.setValue("sql", sql);
}else{
sql=hp.readValue("sql");
}
Object sql=session.getAttribute("sql");
if(sql==null){
}else{
sqls=sql.toString();
}
}
if(!"".equals(sqls)){
DbConn db=new DbConn();
ResultSet rs=db.query(sqls);
List<Piao> alist=FindService.getPiao(rs);
request.setAttribute("alist", alist);
}
request.getRequestDispatcher("/main.jsp").forward(request, response);
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
package dp.admin.svlt;
public class GetZdByTid extends HttpServlet {
/**
* Constructor of the object.
*/
public GetZdByTid() {
super();
String ptype=request.getParameter("ptype");
String cxzh=request.getParameter("cxzh");
String yxsj=request.getParameter("yxsj");
boolean bl=db.insort("insert into piao(szdid,ezdid,tid,stime,pval,ptype,cxzh,yxsj) values("+szdid+","+ezdid+","+tid+",'"+stime+"',"+pval+",'"+ptype+"','"+cxzh+"','"+yxsj+"')");
if(!bl){
json.put("msg", "添加成功。");
}else{
json.put("msg", "添加失败");
}
}
PrintWriter out=response.getWriter();
out.print(json.toString());
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
package dp.admin.svlt;
public class Del extends HttpServlet {
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//设置传输数据编码方式
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html");
HttpSession session=request.getSession();
//获取当前登录用户信息
Object utype=session.getAttribute("utype");
Object userid=session.getAttribute("userid");
//创建json对象
JSONObject json=new JSONObject();
if(utype==null||userid==null){
}
package dp.svlt;
public class LoginSvlt extends HttpServlet {
/**
* Constructor of the object.
*/
public LoginSvlt() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
// Put your code here
}
}
package dp.admin.svlt;
public class CkSvlt extends HttpServlet {
/**
* Constructor of the object.
*/
public CkSvlt() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
/**
* 读取Properties综合类,默认绑定到temp下的.properties文件。
*/
public class HandleProperties {
//配置文件的路径
private String configPath=null;
/**
* 配置文件对象
*/
private Properties props=null;
/**
* 默认构造函数，用于sh运行，自动找到temp下的.properties。
*/
public HandleProperties(HttpSession session,String fname) throws IOException{
String path=session.getServletContext().getRealPath("/");
File f=new File(path+"prop/"+fname+".properties");
if(!f.exists()){
f.getParentFile().mkdirs();
}
if(!f.exists()){
try {
f.createNewFile();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
configPath=f.getPath();
FileInputStream in = new FileInputStream(f);
props = new Properties();
props.load(in);
//关闭资源
in.close();
}
/**
* 根据key值读取配置的值
* @param key key值
}else{
json.put("msg", "操作错误01");
}
}
//车票信息修改
if("piao".equals(tname)){
String tid=request.getParameter("tid");
String szdid=request.getParameter("szdid");
String ezdid=request.getParameter("ezdid");
String stime=request.getParameter("stime");
String pval=request.getParameter("pval");
String ptype=request.getParameter("ptype");
String cxzh=request.getParameter("cxzh");
String yxsj=request.getParameter("yxsj");
String ids=request.getParameter("idi");
int bls=db.deleteOrUpdate("update piao set yxsj='"+yxsj+"', cxzh='"+cxzh+"' ,ptype='"+ptype+"',pval="+pval+", stime='"+stime+"', tid="+tid+",szdid="+szdid+",ezdid="+ezdid+" where id="+ids);
if(bls>0){
json.put("msg", "修改成功。");
}else{
json.put("msg", "修改失败");
}
}
PrintWriter out=response.getWriter();
out.print(json.toString());
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
package dp.admin.svlt;
json.put("msg", "添加失败");
}
}
}
//站点信息添加
if("zhandian".equals(tname)){
String zdname=request.getParameter("zdname");
boolean bl=db.checkTrue("select id from zhandian where zdname='"+zdname+"'");
if(bl){
json.put("msg", "站点名称已存在");
}else{
bl=db.insort("insert into zhandian(zdname) values('"+zdname+"')");
if(!bl){
json.put("msg", "添加成功。");
}else{
json.put("msg", "添加失败");
}
}
}
//线路信息添加
if("xianlu".equals(tname)){
String tid=request.getParameter("tid");
String zdid=request.getParameter("zdid");
String xh=request.getParameter("xh");
DbConn db2=new DbConn();
if(db.checkTrue("select id from xianlu where tid="+tid+" and zdid="+zdid)){
json.put("msg", "该线路已有该站点");
}else if(db2.checkTrue("select id from xianlu where tid="+tid+" and xh="+xh)){
json.put("msg", "站点序号已存在");
}else{
boolean bl=db.insort("insert into xianlu(xh,tid,zdid) values("+xh+","+tid+","+zdid+")");
if(!bl){
json.put("msg", "添加成功。");
}else{
json.put("msg", "添加失败");
}
}
}
//车票信息添加
//data:{tname:'piao',"szdid":szdid,"stime":stime,"ezdid":ezdid,"pval":pval,"ptype":ptype,
//"cxzh":cxzh,"yxsj":yxsj,"tid":tid,idi:ids},
if("piao".equals(tname)){
String tid=request.getParameter("tid");
String szdid=request.getParameter("szdid");
String ezdid=request.getParameter("ezdid");
String stime=request.getParameter("stime");
String pval=request.getParameter("pval");
String ptype=request.getParameter("ptype");
}else if(db.checkTrue("select id from xianlu where tid="+ids)){
json.put("msg", "该火车有线路信息存在不能删除.");
}else{
int bls=db.deleteOrUpdate("delete from traininfo where id="+ids);
if(bls>0){
json.put("msg", 1);
}else{
json.put("msg", "删除失败");
}
}
}
//站点信息删除
if("zhandian".equals(tname)){
String ids=request.getParameter("idi");
if(db.checkTrue("select id from xianlu where zdid="+ids)){
json.put("msg", "该站点有线路信息存在不能删除.");
}else{
int bls=db.deleteOrUpdate("delete from zhandian where id="+ids);
if(bls>0){
json.put("msg", 1);
}else{
json.put("msg", "删除失败");
}
}
}
//线路信息删除
if("xianlu".equals(tname)){
String zdid=request.getParameter("zdid");
String tid=request.getParameter("tid");
int bls=db.deleteOrUpdate("delete from xianlu where zdid="+zdid+" and tid="+tid);
if(bls>0){
json.put("msg", 1);
}else{
json.put("msg", "删除失败");
}
}
//车票信息删除
if("piao".equals(tname)){
String id=request.getParameter("idi");
int bls=db.deleteOrUpdate("delete from piao where id="+id);
if(bls>0){
json.put("msg", 1);
response.setContentType("text/html");
String tid=request.getParameter("tid");
JSONObject json=new JSONObject();
if(!"".equals(tid)&&tid!=null){
DbConn db=new DbConn();
ResultSet rs=db.query("select zhandian.* from xianlu,zhandian where xianlu.zdid=zhandian.id and xianlu.tid="+tid);
List<Zhandian> zdlist=FindService.getZhandian(rs);
json.put("msg", 1);
json.put("zdlist", zdlist);
}else{
json.put("msg", 0);
}
PrintWriter out=response.getWriter();
out.print(json.toString());
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
package dp.admin.svlt;
public class CkSvlt extends HttpServlet {
/**
* Constructor of the object.
*/
public CkSvlt() {
super();
}
/**
/**
* 读取Properties综合类,默认绑定到temp下的.properties文件。
*/
public class HandleProperties {
//配置文件的路径
private String configPath=null;
/**
* 配置文件对象
*/
private Properties props=null;
/**
* 默认构造函数，用于sh运行，自动找到temp下的.properties。
*/
public HandleProperties(HttpSession session,String fname) throws IOException{
String path=session.getServletContext().getRealPath("/");
File f=new File(path+"prop/"+fname+".properties");
if(!f.exists()){
f.getParentFile().mkdirs();
}
if(!f.exists()){
try {
f.createNewFile();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
configPath=f.getPath();
FileInputStream in = new FileInputStream(f);
props = new Properties();
props.load(in);
//关闭资源
in.close();
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
//设置传输数据编码方式
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
HttpSession session=request.getSession();
Object utype=session.getAttribute("utype");
Object userid=session.getAttribute("userid");
JSONObject json=new JSONObject();
if(utype==null||userid==null){
json.put("msg", "请重新登陆");
}else{
String opwd=request.getParameter("opwd");
String npwd=request.getParameter("npwd");
DbConn db=new DbConn();
String sql="";
if("gly".equals(utype.toString())){
sql="select id from userinfo where id="+userid+" and upassword='"+opwd+"'";
}else if("cus".equals(utype.toString())){
sql="select id from cusinfo where id="+userid+" and cpassword='"+opwd+"'";
}
boolean bl=false;
if("".equals(sql)){
json.put("msg", "系统错误01");
}else{
bl=db.checkTrue(sql);
}
if(bl){
if("gly".equals(utype.toString())){
sql="update userinfo set upassword='"+npwd+"' where id="+userid;
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//设置传输数据编码方式
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html");
HttpSession session=request.getSession();
//获取当前登录用户信息
Object utype=session.getAttribute("utype");
Object userid=session.getAttribute("userid");
//创建json对象
JSONObject json=new JSONObject();
if(utype==null||userid==null){
json.put("msg", "请重新登陆。");
return;
}
//获取前台数据tname
String tname=request.getParameter("tname");
//创建数据库操作对象
DbConn db=new DbConn();
//管理员信息修改
if("admin".equals(tname)){
String un=request.getParameter("uname");
String up=request.getParameter("upassword");
String ids=request.getParameter("idi");
ResultSet rs=db.query("select id from userinfo where uname='"+un+"'");
if(rs!=null){
boolean bl=false;
int id=-1;
try {
while(rs.next()){
id=rs.getInt("id");
if(!String.valueOf(id).equals(ids)){
bl=true;
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html");
String rgidcard=request.getParameter("rgidcard");
String rgpassword=request.getParameter("rgpassword");
String rgsname=request.getParameter("rgsname");
JSONObject json =new JSONObject();
DbConn db=new DbConn();
if(userid==null||utype==null){
json.put("msg", "请重新登陆");
}else{
HandleProperties hp=new HandleProperties(session,utype+""+userid);
hp.setValue("sql", sql);
json.put("msg", 1);
}
PrintWriter out=response.getWriter();
out.print(json.toString());
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
package dp.svlt;
public class LogoutSvlt extends HttpServlet {
/**
* Constructor of the object.
*/
public LogoutSvlt() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
//设置传输数据编码方式
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
//获取前台传送的变量，账号，密码和用户类型
String uname=request.getParameter("uname");
String upassword=request.getParameter("upassword");
String utype=request.getParameter("utype");
//创建数据库操作对象
DbConn db=new DbConn();
//sql语句变量定义
String sql="";
int id=-1;
String usname="";
if("gly".equals(utype)){
sql="select id from userinfo where uname='"+uname+"' and upassword='"+upassword+"'";
}else if("cus".equals(utype)){
sql="select id,cname from cusinfo where cidcard='"+uname+"' and cpassword='"+upassword+"'";
}
JSONObject json=new JSONObject();
if("".equals(sql)){
json.put("msg", "系统错误01.");
}else{
ResultSet rs=db.query(sql);
if(rs==null){
json.put("msg", "系统错误02");
}else{
try {
while(rs.next()){
// Put your code here
}
}
package dp.svlt;
public class LoginSvlt extends HttpServlet {
/**
* Constructor of the object.
*/
public LoginSvlt() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
public GetZdByTid() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//设置传输数据编码方式
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html");
String tid=request.getParameter("tid");
JSONObject json=new JSONObject();
if(!"".equals(tid)&&tid!=null){
DbConn db=new DbConn();
ResultSet rs=db.query("select zhandian.* from xianlu,zhandian where xianlu.zdid=zhandian.id and xianlu.tid="+tid);
List<Zhandian> zdlist=FindService.getZhandian(rs);
public class UpdSvlt extends HttpServlet {
/**
* Constructor of the object.
*/
public UpdSvlt() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//设置传输数据编码方式
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
package dp.admin.svlt;
public class Del extends HttpServlet {
/**
* Constructor of the object.
*/
public Del() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html");
String rgidcard=request.getParameter("rgidcard");
String rgpassword=request.getParameter("rgpassword");
String rgsname=request.getParameter("rgsname");
JSONObject json =new JSONObject();
DbConn db=new DbConn();
if(db.checkTrue("select id from cusinfo where cidcard='"+rgidcard+"'")){
json.put("msg", "身份证已注册");
}else{
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
boolean bl=db.insort("insert into cusinfo(cname,cidcard,cpassword,intime) values('"+rgsname+"','"+rgidcard+"','"+rgpassword+"','"+sdf.format(new Date())+"')");
if(!bl){
json.put("msg", "注册成功");
}else{
json.put("msg", "error:02");
}
}
}else{
json.put("msg", "error:01");
}
PrintWriter out = response.getWriter();
out.print(json.toString());
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occurs
*/
public void init() throws ServletException {
// Put your code here
}
}
package dp.svlt;
扫一扫
6199
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
