servlet吧 关注：1,440贴子：1,219
- 3回复贴，共1页
代码：
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setCharacterEncoding("utf-8");
response.setContentType("text/html");
PrintWriter out = response.getWriter();
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
String indate=request.getParameter("checkindate");
String outdate=request.getParameter("checkoutdate" );
String floor=request.getParameter("floor" );
String number=request.getParameter("number" );
String sql="select * from room where floor='"+floor+"'and number='"+number+"'";
String sql2="update room set is_checkin ='1'and time_out ='"+outdate+"' and time_in ='"+indate+"' where floor='"+floor+"'and number='"+number+"'";
System.out.println("Connecting to database...");
try {
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/room","root","root");
System.out.println("creating statement...");
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
System.out.println(rs);
System.out.println(rs.next());
rs.previous();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
if(rs.next())
{
stmt.executeUpdate(sql2);
System.out.println("success");
}
else
{
System.out.println("error");
}
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
try {
if(conn!=null)
conn.close();
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();}
response.setHeader("reflesh","0.1;url:/welcom.jsp");
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
System.out.println("bye");
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setCharacterEncoding("utf-8");
response.setContentType("text/html");
PrintWriter out = response.getWriter();
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
String indate=request.getParameter("checkindate");
String outdate=request.getParameter("checkoutdate" );
String floor=request.getParameter("floor" );
String number=request.getParameter("number" );
String sql="select * from room where floor='"+floor+"'and number='"+number+"'";
String sql2="update room set is_checkin ='1'and time_out ='"+outdate+"' and time_in ='"+indate+"' where floor='"+floor+"'and number='"+number+"'";
System.out.println("Connecting to database...");
try {
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/room","root","root");
System.out.println("creating statement...");
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
System.out.println(rs);
System.out.println(rs.next());
rs.previous();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
if(rs.next())
{
stmt.executeUpdate(sql2);
System.out.println("success");
}
else
{
System.out.println("error");
}
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
try {
if(conn!=null)
conn.close();
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();}
response.setHeader("reflesh","0.1;url:/welcom.jsp");
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
System.out.println("bye");
}
}
扫二维码下载贴吧客户端
下载贴吧APP
看高清直播、视频！
看高清直播、视频！
贴吧热议榜
- 1怎么给LPL定制版本能拿S冠1561230
- 2你看好小米生产卫生巾吗1133697
- 3JKL和Uzi相比谁更强848008
- 4为什么黄毛从来不缺女朋友835461
- 5刘神自传之冰岛首尔双城记774722
- 6沙特球员或因斋月获得debuff631850
- 7BLG赛训上强度有用吗601752
- 8国人超玩首通双影奇境超级关卡526562
- 9樊振东不参加澳门世界杯467412
- 10HLE登顶全球战力榜464793
