jdbc显示mysql的数据_使用jsp链接jdbc数据库并将数据显示出来

jsp代码：

//定义

String name = null;

String mima=null;

String name2 = null;

String mima2=null;

String headImgUrl=null;

String driver = "com.mysql.jdbc.Driver";

//URL指向要访问的数据库名test1

String url = "jdbc:mysql://ip:3306/数据库名称";

//MySQL配置时的用户名

String user = "数据账号";

//Java连接MySQL配置时的密码

String password = "**********";

//测试sql

String sqlt1 = "SELECT headImgUrl,headImgUrl as headImgUrl2 from userinfo WHERE province='河北' ORDER BY subscribeTime desc LIMIT 1";

String sqlt2 = "SELECT headImgUrl,headImgUrl as headImgUrl2 from userinfo WHERE province='河南' ORDER BY subscribeTime desc LIMIT 1";

String sqlt3 = "SELECT nickname,subscribeTime,headImgUrl from userinfo WHERE province='北京' ORDER BY subscribeTime desc LIMIT 5";

String sqllb4 = "SELECT nickname,subscribeTime ,headImgUrl from userinfo WHERE province='河北' ORDER BY subscribeTime desc LIMIT 5";

String sqllb5 = "SELECT nickname,subscribeTime,headImgUrl from userinfo WHERE province='河南' ORDER BY subscribeTime desc LIMIT 5";

String sqllb6 = "SELECT nickname,subscribeTime,headImgUrl from userinfo WHERE province='北京' ORDER BY subscribeTime desc LIMIT 5";

try {

// 1 加载驱动程序

Class.forName(driver);

// 2 连接数据库

Connection connmysql = DriverManager.getConnection(url, user, password);

// 3 用来执行SQL语句

Statement statement = connmysql.createStatement();

// 要执行的SQL语句

%>

ResultSet rs1 = statement.executeQuery(sqllb5);

/*ResultSet rs2 = statement.executeQuery(sql2);

ResultSet rs3 = statement.executeQuery(sql3);

ResultSet rs4 = statement.executeQuery(sql4);

ResultSet rs5 = statement.executeQuery(sql5);

ResultSet rs6 = statement.executeQuery(sql6); */

//将数据存入result

List result = new ArrayList<>();

while (rs1.next()) {

Map map = new HashMap();

name = rs1.getString("nickname");

mima = rs1.getString("subscribeTime");

headImgUrl = rs1.getString("headImgUrl");

map.put("name", name);

map.put("mima", mima);

map.put("headImgUrl", headImgUrl);

result.add(map);

}

rs1.close();

%>

在这里写jsp循环取数据

if (!result.isEmpty()) {

int i = 0;

for (; i < result.size(); i++) {

System.out.print(result);

String title=result.get(i).get("name").toString();

String urlpath=result.get(i).get("headImgUrl").toString();

String timeString=result.get(i).get("mima").toString();

%>

href=" "

target="_blank" title="">

--%>

}

for (; i < result.size(); i++) {

%>

}

}

%>

/* rs2.close();

rs3.close();

rs4.close();

rs5.close();

rs6.close(); */

connmysql.close();

} catch (ClassNotFoundException e) {

System.out.println("Sorry,can`t find the Driver!");

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

} catch (Exception e) {

e.printStackTrace();

}

%>