📄 dbservlet.java

📁 一本jsp自学教材
💻 JAVA
字号:
package test;

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

public class DBServlet extends HttpServlet {
    ServletConfig config=null;
    private String driverName="";
    private String username="";
    private String password="";
    private String dbName="";
    private Connection conn;
    private Statement stmt;
    ResultSet rs=null;
    public void init(ServletConfig config)throws ServletException
     {
       super.init(config);      
       this.config=config;
       driverName=config.getInitParameter("driverName");
       username=config.getInitParameter("username");
       password=config.getInitParameter("password");
       dbName=config.getInitParameter("dbName");
     }
    public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {        
        response.setContentType("text/html;charset=GBK");
        PrintWriter out = response.getWriter();
        out.println("<html>");
        out.println("<head>");
        out.println("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=GBK\">");
	out.println("<title>DataBase Connction</title>");
        out.println("</head>");
        out.println("<body bgcolor=\"white\">");
        String url="jdbc:mysql://localhost/"+dbName+"?characterEncoding=GBK"; 

        try{
            //加载驱动程序
            Class.forName("com.mysql.jdbc.Driver");
            //建立同数据库的连接对象
            conn=DriverManager.getConnection(url,username,password);
            stmt=conn.createStatement(); 
            String sql="SELECT * FROM product WHERE id<6";
            rs=stmt.executeQuery(sql);
              out.print("Servlet 访问数据库成功！");
              out.print("<TABLE BORDER=1 bordercolorlight=#000000 >");
              out.print("<TR><TD width=40>序号</TD>");
              out.print("<TD width=60>代码</TD><TD width=80>商品名称</TD>");
              out.print("<TD width=60>品牌</TD>");
              out.print("<TD width=150>产品简介</TD><TD width=80>存货数量</TD>");
              out.print("<TD width=80>价格/元</TD></TR>");
           
              while(rs.next())
               {
                 out.print("<TR>");
                 out.print("<TD>"+rs.getInt(1)+"</TD>");
                 out.print("<TD>"+rs.getString("pdm")+"</TD>");
                 out.print("<TD>"+rs.getString("pname")+"</TD>");     
                 out.print("<TD>"+rs.getString("provider")+"</TD>");
                 out.print("<TD>"+rs.getString("info")+"</TD>");
                 out.print("<TD>"+rs.getString("stock")+"</TD>");
                 out.print("<TD>"+rs.getString("price")+"</TD>");
                 out.print("</TR>");
               }
             out.print("</TABLE>");
             rs.close();
             stmt.close();
             conn.close();
           }
       catch(Exception e)
          {
            out.print(e.toString()); 
          } 
        
        out.println("</body>");
        out.println("</html>");        
    }  
    public void doPost(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {  
      doGet(request,response);    
    }   
   public void destroy()
    {
     config=null;
     driverName=null;
     username=null;
     password=null;
     dbName=null;
     conn=null;
     stmt=null;
     rs=null;
    }
}
⌨️ 快捷键说明

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