📄 booksnext.java
字号:
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class booksNext 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");
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");
int f=0;
while(results.next())
{
f++;
}
out.println("<BODY><center>");
//out.println("<Form method=get action=/servlet/>");
out.println("<p><strong><font size=4>booklist</font></stong></p>");
out.println("<table border=1 cellspacing=1 cellpadding=5>");
out.println("<tr>");
out.println("<td width=30>choose</td>");
out.println("<td width=189>bookname</td>");
out.println("<td width=55>price</td>");
out.println("<tr>");
int i;
if(items==null)
{
i=0;
results.beforeFirst();
}
else
{
out.println(items.length);
for (int j = 0; j < items.length; j++)
{
out.println("<INPUT TYPE=hidden NAME=bookid VALUE=\"" +
items[j] + "\">");
}
i=items.length;
results.absolute(i);
}
while(results.next())
{
out.println("<tr>");
out.println("<td><input type=checkbox name=bookid value=\""+results.getString(2)+"\"></td>");
out.println("<td height=20>");
out.println(results.getString(2));
out.println("</td>");
out.println("<td>"+results.getString(3)+"</td>");
out.println("</tr>");
if(++i%5==0)break;
}
out.println("</table>");
if(i<f)
out.println("<a href=books><input type=button value=next ></a><br>");
out.println("<a href=><input type=button value=Payment></a>");
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 + -