📄 tservlet.java
字号:
package ServletApi;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class TServlet extends HttpServlet implements Serializable {
public TServlet() {
super();
}
public void service(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException {
try {
ServletApi.TBean javabean = new ServletApi.TBean();
javabean.execute();
ResultSet rs1 = javabean.getResult();
PrintWriter out = res.getWriter();
res.setContentType("text/html;charSet=gb2312");
out.println("<html><head><title>TServlet</title></head><body>");
out.println("<H1>Use JavaBean in Servlet</H1>");
out.println("<table border=1>");
out.println("<td>ID</td><td>NAME</td><td>DEPT</td><td>JOB</td><td>YEARS</td><td>SALARY</td><td>COMM</td>");
while (rs1.next()) {
out.println("<tr>");
for (int i = 1; i <= 7; i++)
out.println("<td>" + rs1.getString(i) + "</td>");
out.println("</tr>");
}
out.println("</table>");
out.println("</body></html>");
javabean.Sqlclose();
} catch (SQLException e) {
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -