myservlet.java

来自「《jsp网站开发技术》中的源代码(清华大学出版社)」· Java 代码 · 共 45 行

JAVA
45
字号
package ServletBean;

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

//创建一个MyServlet类
public class MyServlet extends HttpServlet implements Serializable
{
//MyServlet 构造函数
public MyServlet() {
super();
}

//MyServlet的service()方法
public void service(HttpServletRequest req, HttpServletResponse res) 
      throws ServletException, IOException {
try {
//创建MyBean的对象实例
MyBean Javabean = new MyBean();
Javabean.executesql();
ResultSet result = Javabean.getResult();
PrintWriter out = res.getWriter();
res.setContentType("text/html");
out.println("<html><body>This is an example for Servlet Using JavaBeans.<br>");
//输出打印,书写HTML

out.println("<h3>Servlet Using JavaBeans to connect DataBase</h3>");
out.println("ID   NAME   AGE");
out.println("<br>");
//循环处理
while (result.next()) {
for (int i = 1; i <=3; i++)
  {out.println(result.getString(i));}
   out.println("<br>");
}
out.println("</body></html>");

//调用Sqlclose方法关闭数据库连接
Javabean.Sqlclose();
} catch (SQLException e) {
e.toString();}
}
}

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?