📄 change_message.jsp

📁 它主要应用于教育系统

💻 JSP

字号:


<%@ page language="java" import="java.sql.*" contentType="text/html;charset=gb2312"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'change_message.jsp' starting page</title>
    
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    
    <!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->
  </head>
  
  <body>
  <jsp:useBean id="test1" scope="application" class="test.Connect_db"/> 
  <FORM action="student/update_db.jsp" method="post">
  <% String user_id=request.getParameter("user_id");
	Connection con=test1.getConnection();
 	ResultSet rs=null;
	 String sql="select name,sex,age,political,phone from student where s_id=?";//
			PreparedStatement ps=con.prepareStatement(sql);
			ps.setString(1,user_id);
			rs=ps.executeQuery(); 
		while(rs.next()) {%>
		<br>
		 姓名：
		<INPUT type="text" name="name" Value="<%=rs.getString(1)%>"/>
		<br>
		 <br>
 		 性别：
		<INPUT type="text" name="sex" Value=<%=rs.getString(2)%> />
		<br>
		<br>
		年龄：
		<INPUT type="text" name="age" Value=<%=rs.getString(3)%> />
		<br>
		<br>
		政治面貌：
		<INPUT type="text" name="political" Value=<%=rs.getString(4)%> />
		<br>
		<br>
		 电话：
		<INPUT type="text" name="phone" Value=<%=rs.getString(5)%> />
		<br>
		<br> 
		<%}%>
		
<%		
		con.close();
    %>   
    <INPUT type="hidden" name="user_id" value="<%=user_id%>">
     &nbsp;&nbsp;&nbsp;<INPUT type="Submit" name="modify" value="修改" />
    &nbsp;&nbsp;&nbsp;<INPUT type="Reset" name="reset" value="重置" />
    
    </form>
	</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -