jsp查询mysql数据_jsp查询数据库

Created by IntelliJ IDEA.

User: Administrator

Date: 2019/9/24

Time: 9:30

To change this template use File | Settings | File Templates.

--%>

把数据库的表显示在页面

-%>

mysql测试

-%>

mysql测试

try {

Class.forName("com.mysql.jdbc.Driver"); 加载数据库驱动

String url = "jdbc:MySQL://localhost:3306/kh87?&useSSL=false&serverTimezone=UTC"; //指向数据库table

String username = "root"; //数据库用户名

String password = "ROOT"; //数据库用户密码

Connection conn = DriverManager.getConnection(url, username, password);

if(conn != null){

out.print("数据库连接成功！");

out.println("
");

out.println("-------------------------------");

out.print("
");

Statement stmt = null;

ResultSet rs = null;

String sql ="select * from user"; //查询语句

stmt = conn.createStatement();

rs = stmt.executeQuery(sql);

out.println("执行结果如下所示:");

out.println("
");

out.println("-------------------------------");

out.println("
");

out.println("id" + "\t" + "name"+"\t"+"age"+"\t");

out.println("
");

while (rs.next()) {

out.println(rs.getString("id")+" &nbsp "+rs.getString("name")+" &nbsp "+rs.getString("age")+" &nbsp "); //将数据库表格查询结果输出

out.print("
");

}

}

else{

out.print("连接失败！");

}

}

catch (Exception e) {

out.print("数据库连接异常！");

}

%>