📄 testservlet.java
字号:
package lee;
import javax.servlet.*;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.*;
import java.sql.*;
/**
* @author yeeku.H.lee kongyeeku@163.com
* @version 1.0
* <br>Copyright (C), 2005-2008, yeeku.H.Lee
* <br>This program is protected by copyright laws.
* <br>Program Name:
* <br>Date:
*/
public class TestServlet extends HttpServlet
{
public void init(ServletConfig config)throws ServletException
{
super.init(config);
}
public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException,java.io.IOException
{
try
{
ServletConfig config = getServletConfig();
String driver = config.getInitParameter("driver");
String url = config.getInitParameter("url");
String user = config.getInitParameter("user");
String pass = config.getInitParameter("pass");
Class.forName(driver);
Connection conn = DriverManager.getConnection(url,user,pass);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from userinf");
PrintStream out = new PrintStream(response.getOutputStream());
out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">");
out.println("<HTML>");
out.println("<HEAD>");
out.println("<TITLE>application测试</TITLE>");
out.println("</HEAD>");
out.println("<BODY>");
out.println("<table bgcolor=\"9999dd\" border=\"1\" align=\"center\">");
while(rs.next())
{
out.println("<tr>");
out.println("<td>" + rs.getString(2) + "</td>");
out.println("<td>" + rs.getString(3) + "</td>");
out.println("</tr>");
}
out.println("</table>");
out.println("</BODY>");
out.println("</HTML>");
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -