注册
登录
| 关键词： nbsp mysql varchar 库里 文件夹 connector name 版本 文件 rows |
下载后得到一个名为mysql-connector-java-版本号.tar.gz的压缩文件 它解压到任 意文件夹，将其中名为mysql-connector-java-版本号-bin.jar的文件拷贝到Tomcat 的commm/lib文件夹里 (1)首先我们先进mysql看看数据库里要查询的内容: mysql> describe hack; +-------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+-------+ | id | varchar(32) | NO | PRI | | | | name | varchar(20) | NO | | | | | QQ | varchar(20) | NO | | | | +-------+-------------+------+-----+---------+-------+ 3 rows in set (0.00 sec) mysql> select * from hack; +-----+-------+---------+ | id | name | QQ | +-----+-------+---------+ | 001 | hack1 | 1234567 | | 002 | hack2 | 5321314 | | 003 | hack3 | 9876543 | +-----+-------+---------+ 3 rows in set (0.00 sec) mysql> (2)建立 test.jsp页面 <%@ page contentType="text/html; charset=utf8" language="java"%> <%@page import="java.sql.*"%> <% Class.forName("com.mysql.jdbc.Driver").newInstance(); String url="jdbc:mysql://localhost/hehe? user=root&password=123&useUnicode=true&characterEncoding=utf8"; Connection conn=DriverManager.getConnection(url); Statement stmt=conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from hack"; %> <table border=1> <tr> <td>id</td> <td>name</td> <td>QQ</td> </tr> <% ResultSet rs=stmt.executeQuery(sql); while(rs.next()){%> <tr> <td><%=rs.getString("id")%> </td> <td><%=rs.getString("name")%> </td> <td><%=rs.getString("QQ")%> </td> </tr> <%}%> </table> <%rs.close(); stmt.close(); conn.close(); %> 然后启动tomcaat |
|
声明：文章版权归原作者所有 部分文章转自互联网 如有侵权请联系
[邮箱地址] 删除
|
