jsp：JDBCmysql数据库连接

一，本例使用JDBC连接mysql数据库

package com.test;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


public class GetMysql extends HttpServlet {

    /**
     * Constructor of the object.
     */
    
    
    public GetMysql() {
        super();
    }

    /**
     * Destruction of the servlet. <br>
     */
    public void destroy() {
        super.destroy(); // Just puts "destroy" string in log
        // Put your code here
    }

    /**
     * The doGet method of the servlet. <br>
     *
     * This method is called when a form has its tag value method equals to get.
     * 
     * @param request the request send by the client to the server
     * @param response the response send by the server to the client
     * @throws ServletException if an error occurred
     * @throws IOException if an error occurred
     */
    private static final long serUid=1L;
    //加载驱动
    static final String jdbc="com.mysql.jdbc.Driver";
    //要连接的数据库url
    static final String db_url="jdbc:mysql://localhost:3306/test";
    //数据库用户名
    static final String user="dyb";
    //数据库密码
    static final String pass="174372150";
    public void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        Connection conn=null;
        Statement stmt=null;
        //显示的数据的格式
        response.setContentType("text/html;charset=UTF-8");
        
        PrintWriter out =response.getWriter();
        try {
            Class.forName("com.mysql.jdbc.Driver");
            //输入用户名密码和连接。
            conn=DriverManager.getConnection(db_url,user,pass);
            //用于向数据库发送sql语句
            stmt=conn.createStatement();
            String sql=null;
            //输入sql语句获取想要的数据
            sql="SELECT t.title,t.new_id," +
                    "t.news_type_id,t.new_date," +
                    "d.name FROM t_news t " +
                    "JOIN t_type_id d on t.news_type_id=d.t_type_id";
            //发送sql语句并返回结果
            ResultSet rs=stmt.executeQuery(sql);
            //循环遍历打印结果
            while (rs.next()) {
                
                int id=rs.getInt("t.news_type_id");
                String lr=rs.getString("t.title");
                String dd=rs.getString("t.new_date");
                String name=rs.getString("d.name");
                out.print("ID:"+id);
                out.print("内容："+lr);
                out.print("日期："+dd);
                out.print("名称："+name);
                
                out.println("</BR>");
                
            }
            //关闭通道
            rs.close();
            conn.close();
            stmt.close();
            
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        
    }

    /**
     * The doPost method of the servlet. <br>
     *
     * This method is called when a form has its tag value method equals to post.
     * 
     * @param request the request send by the client to the server
     * @param response the response send by the server to the client
     * @throws ServletException if an error occurred
     * @throws IOException if an error occurred
     */
    public void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
        out.println("<HTML>");
        out.println("  <HEAD><TITLE>A Servlet</TITLE></HEAD>");
        out.println("  <BODY>");
        out.print("    This is ");
        out.print(this.getClass());
        out.println(", using the POST method");
        out.println("  </BODY>");
        out.println("</HTML>");
        out.flush();
        out.close();
    }

    /**
     * Initialization of the servlet. <br>
     *
     * @throws ServletException if an error occurs
     */
    public void init() throws ServletException {
        // Put your code here
    }

}

 

posted @ 2017-12-24 20:45  dybe  阅读(443)  评论(0)  编辑  收藏  举报