在 JSP 中输出 Mysql 数据
- 准备工作
首先在数据库中插入如下数据
数据库脚本:
DROP TABLE IF EXISTS `deviceinfo`; CREATE TABLE `deviceinfo` ( `Deviceid` varchar(50) NOT NULL, `Longx` varchar(50) NOT NULL, `Laty` varchar(50) NOT NULL, `Name` varchar(50) NOT NULL, `Telephone` varchar(50) NOT NULL, `Sos` varchar(50) DEFAULT NULL, `Helptime` datetime(6) DEFAULT NULL, PRIMARY KEY (`Deviceid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `deviceinfo` VALUES ('111516513158', '116.4', '39.9', '王一', '111111', null, null); INSERT INTO `deviceinfo` VALUES ('156798456321', '110', '26', '王奇', '456123', null, null); INSERT INTO `deviceinfo` VALUES ('156974632576', '117.2', '39.12', '王二', '222222', null, null); INSERT INTO `deviceinfo` VALUES ('156987456321', '102.73', '25.04', '王三', '333333', 'Y', '2017-04-07 10:52:01.000000'); INSERT INTO `deviceinfo` VALUES ('456321489657', '104.06', '30.67', '王四', '444444', null, null); INSERT INTO `deviceinfo` VALUES ('456987123654', '113.23', '23.16', '王五', '555555', null, null); INSERT INTO `deviceinfo` VALUES ('489654785214', '110', '28', '1', '2', null, null);
2. 编写代码
在 JSP 文件中读取 deviceinfo 表中name 数据。代码如下
<%@ page contentType="text/html; charset=utf-8" %> <%@ page language="java" %> <%@ page import="com.mysql.jdbc.Driver" %> <%@ page import="java.sql.*" %> <%@ page import="java.util.*" %> <% String driverName="com.mysql.jdbc.Driver"; //驱动程序 String userName="map"; //Mysql用户名 String userPasswd="mapadmin"; //密码 String dbName="maptest";//数据库名 String tableName="deviceinfo";//数据表名 String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd; //连接URL为 jdbc:mysql//服务器地址/数据库名?user=登陆用户名&password=密码 Class.forName("com.mysql.jdbc.Driver").newInstance(); //加载驱动程序 Connection conn=DriverManager.getConnection(url); //获取数据库连接 Statement stmt = conn.createStatement(); //创建Statement对象 String sql="SELECT * FROM "+tableName; //SQL语句 ResultSet rs = stmt.executeQuery(sql); //执行SQL语句 List<String> list = new ArrayList<String>(); //list while(rs.next()) { list.add (rs.getString("Name"));//将Name加入到list中 } out.println("打印 list:"); out.print(list); //关闭资源 rs.close(); stmt.close(); conn.close(); %>
运行该 JSP 页面