📄 booking.java
字号:
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class booking extends HttpServlet
{
Statement stmt;
Connection conn;
ResultSet results;
public void doGet(HttpServletRequest req ,HttpServletResponse res)throws ServletException, IOException
{
res.setContentType("text/html; charset=GBK");
String[] items = req.getParameterValues("bookid");
int num;
;
if(req.getParameterValues("num")==null)
num=0;
else
num=Integer.parseInt(req.getParameterValues("num")[0]);
PrintWriter out = res.getWriter();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce)
{
out.println(ce);
}
conn=null;
try{
conn=DriverManager.getConnection("jdbc:odbc:book");
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
results=stmt.executeQuery("select * from book");
out.println("<BODY><center>");
out.println("<p><strong><font size=4>Booking</font></stong></p>");
out.println("<FORM ACTION='booking' METHOD=get>");
out.println("<table border=1 cellspacing=1 cellpadding=5>");
out.println("<tr>");
out.println("<td width=189>bookname</td>");
out.println("<td width=55>price</td>");
out.println("<tr>");
int i;
if(items!=null)
{
out.println("your choosing sum : "+items.length);
for (int j = 0; j < items.length; j++)
{
out.println("<tr>");
out.println("<td height=20>");
out.println(items[j]);
out.println("</td>");
out.println("<td>"+"</td>");
out.println("</tr>");
}
out.println("</table>");
out.println("</form><br>");
out.println("<FORM ACTION='hello' METHOD=get>");
out.println("<input type=submit value=Payment></form>");
out.println("</BODY>");
}
}
catch(SQLException se)
{
out.println(se.toString());
}
}
public void doPost(HttpServletRequest req ,HttpServletResponse res)throws ServletException, IOException
{
doGet(req,res);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -