JSP与数据库链接

最新推荐文章于 2020-11-17 20:29:47 发布

Wqanxiu

最新推荐文章于 2020-11-17 20:29:47 发布

阅读量491

点赞数

分类专栏： javaweb 文章标签：数据库 jsp

本文链接：https://blog.csdn.net/qq_38343111/article/details/78310224

版权

javaweb 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

<%@page import="java.awt.Button"%>
<%@ page contentType="text/html;charset=utf-8"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Connection con;
Statement sql;
ResultSet rs;
try{Class.forName("com.mysql.jdbc.Driver").newInstance();}
catch(Exception e){out.print(e);}
try{
    String uri="jdbc:mysql://localhost:3306/iotregister";
    con=DriverManager.getConnection(uri,"root","wqx818");
    sql=con.createStatement();
    rs=sql.executeQuery("SELECT * FROM student");
    out.print("<table border=4>");
    out.print("<tr>");
    out.print("<th width=100>"+"姓名");
    out.print("<th width=100>"+"时长");
    out.print("</tr>");
    while(rs.next()){
        out.print("<tr>");
        out.print("<td>"+rs.getString(1)+"</td>");
        out.print("<td>"+rs.getString(2)+"</td>");
        //添加按钮    
        out.print("<td><input type=\"button\" value=\"签到\" onclick = \"TimerGO(this，rs)\"></td>");
        out.print("<td><input type=\"button\" value=\"离开\" onclick = \"TimerEnd(this,rs)\"></td>");
        
    }
    
    out.print("</table>");
    con.close();
} 
catch(SQLException e1){out.print(e1);}
%>
</body>
</html>

Wqanxiu

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
JSP与数据库链接

<%Connection con;Statement sql;ResultSet rs;try{Class.forName("com.mysql.jdbc.Driver").newInstance();}catch(Exception e){out.print(e);}try{ String uri="jdbc:mysql://localhost:3306/iotregiste
复制链接

扫一扫