<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <% request.setCharacterEncoding("utf-8"); //设置参数编码格式 String no=request.getParameter("stuNO"); //获取id参数的值 String classId = ""; String stuName = ""; String gender = ""; String birthday = ""; String stature = ""; String political = ""; Class.forName("com.mysql.jdbc.Driver").newInstance(); //Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/杜老师数据库", "root", "123456"); Connection con = DriverManager.getConnection("jdbc:mysql://www.duzhaojiang.cn:3306/杜老师数据库", "dzj", "6337925"); CallableStatement cstmt = null; //声明预处理对象 cstmt = con.prepareCall("call Get学生信息By学号_000(?)"); cstmt.setString(1, no); //设置第一个个参数 ResultSet rs = cstmt.executeQuery(); if (rs.next()) { classId = rs.getString("班级ID"); stuName = rs.getString("姓名"); gender = rs.getString("性别"); birthday = rs.getString("生日"); stature = rs.getString("身高"); political = rs.getString("政治面貌"); } //关闭连接、释放资源 rs.close(); cstmt.close(); con.close(); %> 修改学生信息
修改学生
<%="checked"%> <%}%>>男 <%="checked"%> <%}%>>女