📄 bookdbquery.java
字号:
/******************** BookdbQuery.java ********************/import java.io.*;import java.sql.*;import javax.servlet.*;import javax.servlet.http.*;public class BookdbQuery extends HttpServlet { public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { String sql=req.getParameter("sql"); Connection con = null; Statement stmt = null; ResultSet rs = null; res.setContentType("text/html"); ServletOutputStream sos=res.getOutputStream(); PrintWriter out=new PrintWriter(sos,true);// PrintWriter out = res.getWriter(); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:bookdb"); stmt = con.createStatement(); rs = stmt.executeQuery(sql); ResultSetMetaData rsmd = rs.getMetaData(); int numcols = rsmd.getColumnCount(); out.println("<HTML>"); out.println("<HEAD><TITLE>bookdb</TITLE></HEAD>"); out.println("<BODY>"); out.println("<TABLE>"); out.println("<TR>"); for (int i = 1; i <= numcols; i++) out.println("<TH>" + rsmd.getColumnLabel(i)); out.println("</TR>\n"); // while (rs.next()) { out.println("<TR>"); for (int i = 1; i <= numcols; i++) { out.println("<TD>"); Object obj = rs.getObject(i); if (obj != null) out.println(obj.toString()); else out.println(" "); } out.println("</TR>\n"); } out.println("</TABLE>\n"); out.println("</BODY></HTML>"); } catch (ClassNotFoundException e) { out.println("Couldn't load database driver: " + e.getMessage()); } catch (SQLException e) { out.println("SQLException caught: " + e.getMessage()); } finally { try { if (con != null) con.close(); } catch (SQLException ignored) { } } } }⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -