JSP页面访问数据库

怼烎@ 2021-07-24 19:15 385阅读 0赞

**一 JSP代码**

<%@ page contentType="text/html; charset=GBK" language="java" errorPage="" %>
    <%@ page import="java.sql.*" %>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
        "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <title> 小脚本测试 </title>
        <meta name="website" content="http://www.crazyit.org" />
    </head>
    <body>
    <%
    // 注册数据库驱动
    Class.forName("com.mysql.jdbc.Driver");
    // 获取数据库连接
    Connection conn = DriverManager.getConnection(
        "jdbc:mysql://localhost:3306/javaee","root","123456");
    // 创建Statement
    Statement stmt = conn.createStatement();
    // 执行查询
    ResultSet rs = stmt.executeQuery("select * from news_inf");
    %>
    <table bgcolor="#9999dd" border="1" width="300">
    <%
    // 遍历结果集
    while(rs.next())
    {%>
        <tr>
            
            <td><%=rs.getString(1)%></td>
            <td><%=rs.getString(2)%></td>
        </tr>
    <%}%>
    <table>
    </body>
    </html>

**二 准备Mysql驱动**

D:\\Program\\Tomcat8\\webapps\\basicSyntax\\WEB-INF\\lib\\mysql-connector-java-5.1.30-bin.jar

**三 准备数据库和数据表**

drop database javaee;
    create database javaee;
    use javaee;
    
    create table news_inf
    (
    news_id int primary key auto_increment,
    news_title varchar(255)
    );
    
    insert into news_inf
    values
    (null , '疯狂Java联盟'),
    (null , 'crazyit.org');

**四 测试**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZW5ncWl1bWluZw_size_16_color_FFFFFF_t_70]: /images/20210724/fc8efde38e9b4e2b9f594c13f34cb42e.png