JDBCServlet的小程序
JDBCServlet.javapackage com.zyl.servlet;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.sql.*;public class JDBCServlet extends HttpServlet {@Overrideprotected void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException {Connection conn = null;Statement stmt = null;ResultSet rs = null;response.setContentType("text/html");response.setCharacterEncoding("UTF-8");PrintWriter out = response.getWriter();out.println("<table border=1>");out.println("<tr><td>categoryno:</td>" +"<td>medicalid:</td>" +"<td>medicaltitle:</td></tr>");try {Class.forName("com.ibm.db2.jcc.DB2Driver");conn = DriverManager.getConnection("jdbc:db2://192.168.25.230:50000/JSAMPLE", "zyl", "123");stmt = conn.createStatement();rs = stmt.executeQuery("select categoryno,medicalid,medicaltitle from medicalbean"); while(rs.next()){out.println("<tr>");out.println("<td>" + rs.getString("categoryno") + "</td>");out.println("<td>" + rs.getString("medicalid") + "</td>");out.println("<td>" + rs.getString("medicaltitle") + "</td>");out.println("</tr>");}out.println("</table>");} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();} finally {try {if(rs != null) {rs.close();rs = null;}if(stmt != null) {stmt.close();stmt= null;}if(conn != null) {conn.close();conn = null;}} catch (SQLException e) {e.printStackTrace();}}}}
web.xml配置
<servlet><servlet-name>RS</servlet-name><servlet-class>com.zyl.servlet.JDBCServlet</servlet-class></servlet><servlet-mapping><servlet-name>RS</servlet-name><url-pattern>/SR</url-pattern></servlet-mapping>
页:
[1]