Web作业1输出九九乘法表编写表单和表单信息接收这两个页面Web作业2从数据库获取显示修改表单% page contentTypetext/html;charset UTF-8 languagejava %% page importjava .sql.* %!DOCTYPE htmlhtmlheadmeta charsetUTF-8 /title用户列表/titlestylebody {margin: 30px;font-family: Microsoft YaHei, sans-serif;}table {border-collapse: collapse;width: 100%;}th,td {border: 1px solid #ddd;padding: 8px 10px;text-align: center;}th {background: #f5f5f5;}.actions a {margin: 0 6px;}.top-link {margin-bottom: 14px;}/style/headbodyh2所有注册用户信息/h2p classtop-linka hrefindex.jsp返回首页/a/ptabletrthID/thth用户名/thth密码/thth性别/thth年龄/thth爱好/thth操作/th/tr%String sql SELECT id, name, password, gender, age, hobby FROM users ORDER BY id DESC;try {Class.forName(com.microsoft.sqlserver.jdbc .SQLServerDriver);// SQL Server 连接 URLString uri jdbc:sqlserver://127.0.0.1:1433;databaseNamereglogin;encryptfalse;trustServerCertificatetrue;characterEncodingUTF-8;String user sa;String password1 123456;try (Connection conn DriverManager.getConnection(uri, user, password1);PreparedStatement ps conn.prepareStatement(sql);ResultSet rs ps.executeQuery()) {while (rs.next()) {%trtd% rs.getInt(id) %/tdtd% rs.getString(name) %/tdtd% rs.getString(password) %/tdtd% rs.getString(gender) %/tdtd% rs.getInt(age) %/tdtd% rs.getString(hobby) %/tdtd classactionsa hrefupdateUser.jsp?id% rs.getInt(id) %修改/aa hrefdeleteUser.jsp?id% rs.getInt(id) %onclickreturn confirm(确认删除该用户吗);删除/a/td/tr%}}} catch (Exception e) {%trtd colspan7 stylecolor: red查询失败% e.getMessage() %/td/tr% } %/table/body/htmlWeb作业31.复刻注册登录以及注册人员信息的增删改查2.规划的网站的其中一个模块的增删改查
