?? locate2.java
字號:
/************************ Locate.java *********************/import java.io.*;import java.sql.*;import javax.servlet.*;import javax.servlet.http.*;public class Locate extends HttpServlet { public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { String idStr=req.getParameter("id"); String sql="SELECT * FROM bookTbl WHERE bookId=" + idStr + ";" ; // 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 + -