JSP与数据库链接

来源：互联网发布：网络棋牌交流群编辑：程序博客网时间：2024/05/23 10:45

<%@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>

阅读全文

0 0