⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 xiugai2.jsp

📁 jsp写的学生管理系统 可以好好看看 初学者
💻 JSP
字号:
🔍 
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.Date"%>
<%!
 public String codeToString(String str)    
 {
   String s=str;
   try
   { 
      byte tempB[]=s.getBytes("ISO-8859-1");
      s=new String(tempB);
      return s;
   }
   catch(Exception e)
   {
     return s;
   }
 }
%>
<% 
    String account="",secret="";
    if(session.isNew())
       {
         response.sendRedirect("main.jsp"); 
       }
    else
       { account=(String)session.getAttribute("account");
         secret=(String)session.getAttribute("secret");
         secret=codeToString(secret); 
         account=codeToString(account);
       }
%>
<%//接收要修改的学生的学号
  String number=null;
  try
  {    number=request.getParameter("number");
  }
  catch(Exception e)
  {
  }
%>
<html>
<head>
<title>修改学生的资料</title>
</head>
<body background="background.jpg">

<center>
<%
    String sqlString="select * from student where sno="+"'"+number+"'";
    try
     {
	  Connection con;
      Statement sql;
      ResultSet rs;
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      con=DriverManager.getConnection("jdbc:odbc:student");
      sql=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
      rs=sql.executeQuery(sqlString);
      rs.next();
%>
<table border=1 width="600">
 <tr>
  <td colspan="2" align="center">修改学生资料程序</td>
 </tr>
 <form action="xiugai3.jsp" method="post" onsubmit="return on_submit()" name="form1">
  <input type="hidden" value="<%=number%>" name="number">
  <tr>
    <td width="25%">姓名：</td>
    <td width="75%"><input type="text" name="name" value="<%=rs.getString("name")%>"></td>
  </tr>
  <tr>
    <td>学号:</td>
    <td><input type="text" name="number" value="<%=rs.getString("sno")%>"></td>
  </tr>
  <tr>
    <td>性别：</td>
	<td><input type="text" name="sex"  value="<%=rs.getString("sex")%>">
	  </td>	   
  </tr>

   <tr>
    <td>专业：</td>
    <td><input type="text" name="zhuanye" value="<%=rs.getString("zhuanye")%>"></td>
   </tr>
   <tr>
    <td>高数：</td>
    <td><input type="text" name="gaoshu" value="<%=rs.getString("gaoshu")%>"></td>
   </tr>
</tr>
   <tr>
    <td>C语言：</td>
    <td><input type="text" name="Cyuyan" value="<%=rs.getString("Cyuyan")%>"></td>
   </tr>
</tr>
   <tr>
    <td>JAVA：</td>
    <td><input type="text" name="JAVA" value="<%=rs.getString("JAVA")%>"></td>
   </tr>
</tr>
   <tr>
    <td>JSP：</td>
    <td><input type="text" name="JSP" value="<%=rs.getString("JSP")%>"></td>
   </tr>
   <tr>
    <td>英语：</td>
    <td><input type="text" name="English" value="<%=rs.getString("English")%>"></td>
   </tr>
  <tr><td align=center><input type="submit" value="提交"><input type="reset" value="重输"></td>
   </tr> 
 </form>
</table>
<%   con.close();
  }
  catch(SQLException el)
  {out.print("SQL异常!");}
%>
<br>
<p align=center>
<a href='tianjia.jsp'>录入学生信息</a>&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;
<a href='shanchu.jsp'>删除学生信息</a>&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;
<a href='xiugai.jsp'>修改学生信息</a>&nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;&nbsp;&nbsp;
<a href='main.jsp'>返回首页>></a>
</p>
</center>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -