📄 myservlet.java

📁 《jsp网站开发技术》中的源代码(清华大学出版社)

💻 JAVA

字号:

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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -