JSP连MySQL

来源:互联网 发布:佳仁按摩椅怎么样知乎 编辑:程序博客网 时间:2024/05/20 07:53

<%
    String sql = "";
    String url = "";

    try {
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        url = "jdbc:mysql://localhost/myDB?user=root&password=123456&useUnicode=true&characterEncoding=gb2312";
        Connection conn = DriverManager.getConnection(url);
        Statement stmt = conn.createStatement();

        sql = "select Id, Name, Address from myTable";
        ResultSet rs = stmt.executeQuery(sql);

        while (rs.next()){
            out.println("<information id=/"" + rs.getString(1) + "/">");
            out.println("<id>" + rs.getInt(1) + "</id>");
            out.println("<name>" + rs.getString(2) + "</name>");
            out.println("<address>" + rs.getString(3) + "</address>");
            out.println("</information>");
        }

        rs.close();
        stmt.close();
        conn.close();

    } catch (Exception e) {
        out.println(e);
    }
%>