locate2.java
来自「java程序设计入门教程 书上的源代码 学习JAVA非常好的入门教材代码推荐给」· Java 代码 · 共 59 行
JAVA
59 行
/************************ 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 + =
减小字号Ctrl + -
显示快捷键?