JSP与JDBC:在页面显示数据库账户资料

╰半夏微凉° 2022-05-11 11:54 217阅读 0赞

纯属个人笔记，方便以后查找！  
**JSP代码如下：**

<%@ page language="java" contentType="text/html; charset=UTF-8"
        pageEncoding="UTF-8"%>
        
    
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>Insert title here</title>
    
    	<style type="text/css">
    	
    		table{border:1px solid #ccc;margin:50px auto;text-align: center;}
    		td{border:1px solid #ccc;background-color:#ccc;}
    	
    	</style>
    </head>
    <body>
    	
    	<jsp:useBean id="jdbc" class="com.JDBC.JDBC"></jsp:useBean>
    	<jsp:setProperty property="name" name="jdbc" value=""/>
    	<jsp:getProperty property="name" name ="jdbc"/>
    	
    </body>
    </html>

**然后就是表格数据填充：**

package com.JDBC;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    
    public class JDBC {
    	
    	/*用JSP把数据库里面的账号和密码用表格展示在页面
    	 * 
    	 *连接数据库，sql查询出所需要的数据
    	 * 
    	 * */
    
    	private String name;
    	public String getName() {
    		return name;
    	}
    	
    	public void setName(String name) throws ClassNotFoundException, SQLException {
    		//创建数据库连接
    		Class.forName("com.mysql.jdbc.Driver");
    		Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql","root", "ps123456");
    		
    		//查询语句
    		String sql="SELECT User, Host,authentication_string FROM user";
    		PreparedStatement psstem = connection.prepareStatement(sql);
    		
    		ResultSet  result=psstem.executeQuery();
    		
    		//table表头
    		name="<table><tr><td>Host</td><td>User</td><td>authentication_string</td></tr>";
    		//循环数据表体
    		while(result.next()) {
    			String id=result.getString("Host");
    			String user = result.getString("User");
    			String password = result.getString("authentication_string");
    			name +="<tr><td>"+id+"</td><td>"+user+"</td><td>"+password+"</td></tr>";
    		}
    		name += "</table>";
    		result.close();
    		psstem.close();
    		this.name=name;
    		
    	}
    
    
    }

**最后就是执行效果图：**  
![在这里插入图片描述][70]

[70]: /images/20220505/cd40359ac00b48eb800c865173a8d060.png