JavaWeb开发基础：连接数据库的demo和数据库连接工具类DB.java

JavaWeb开发基础：连接数据库的demo和数据库连接工具类DB.java

 

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class ShowRs extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest request,
                         HttpServletResponse response) throws ServletException, IOException {

        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;

        response.setContentType("text/html");
        //输出编码是gb2312
        response.setCharacterEncoding("gb2312");
        PrintWriter out = response.getWriter();

        out.println("<table border=1>");
        out.println("<tr><td>Content:</td></tr>");
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost/blog