在这里插入代码片
Query.jsp
<%
Class.forName(“com.mysql.jdbc.Driver”);
String url=“jdbc:mysql://127.0.0.1:3306/cartoondb”;
String username=“root”;
String password=“123456”;
Connection con=DriverManager.getConnection(url,username,password);
String sql=“select * from admin”;
PreparedStatement ppsm=con.prepareStatement(sql);
ResultSet rs=ppsm.executeQuery(sql);
编号 | 账号 | 姓名 |
---|---|---|
<%=rs.getInt("id")%> | <%=rs.getString("username")%> | <%=rs.getString("userpwd")%> |