在 JSP 中输出 Mysql 数据

1.    准备工作

  首先在数据库中插入如下数据

 

数据库脚本：

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 页面