📄 books.java
字号:
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class books 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");
int f=0;
while(results.next())
{
f++;
}
out.println("<BODY><center>");
//out.println("<Form name=f1 method=get action=hello>");
out.println("<p><strong><font size=4>booklist</font></stong></p>");
out.println("<pre>");
if(num+5<f)
out.println("<FORM ACTION='books' METHOD=post>");
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(num==0)
{
i=0;
results.beforeFirst();
}
else
{
if(items!=null)
{
out.println("you have choosed : "+items.length+" books");
for (int j = 0; j < items.length; j++)
{
out.println("<INPUT TYPE=hidden NAME=bookid VALUE=\"" +
items[j] + "\">");
}
}
i=num;
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>");
out.println("<INPUT TYPE=hidden NAME=num VALUE="+i+">");
if(i<f)
{
out.println("<input type=submit name=s1 value=next >");
}
out.println("<input type=submit name=s2 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 + -