📄 select2.java
字号:
/************************ Select.java *********************/import java.io.*;import java.sql.*;import javax.servlet.*;import javax.servlet.http.*;public class Select extends HttpServlet { public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { String fromId=req.getParameter("fromId"); String toId=req.getParameter("toId"); String sql="SELECT * FROM bookTbl WHERE bookId>=" + fromId + " AND bookId<=" + toId + " ORDER BY bookId;" ; Connection con = null; Statement statement = null; ResultSet rs = null; res.setContentType("text/html"); ServletOutputStream sos=res.getOutputStream(); PrintWriter pw=new PrintWriter(sos,true); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:bookdb"); statement = con.createStatement(); rs = statement.executeQuery(sql); ResultSetMetaData rsmd = rs.getMetaData(); int colCount = rsmd.getColumnCount(); // pw.println("<HTML>"); pw.println("<HEAD><TITLE>bookdb</TITLE></HEAD>"); pw.println("<BODY>"); pw.println("<TABLE CELLSPACING=10>"); pw.println("<TR>"); for (int i = 1; i <= colCount; i++) pw.println("<TH>" + rsmd.getColumnLabel(i)); pw.println("</TR>\n"); // while (rs.next()) { pw.println("<TR>"); for (int i = 1; i <= colCount; i++) { pw.println("<TD>"); Object obj = rs.getObject(i); if (obj != null) pw.println(obj.toString()); else pw.println(" "); } pw.println("</TR>\n"); } pw.println("</TABLE>\n"); pw.println("</BODY></HTML>"); } catch (ClassNotFoundException e) { pw.println("礚猭更⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -