📄 update.jsp

📁 新生注册系统,用JSP和WEB数据库表写的系统,可以进行删除,添加,管理等操作.

💻 JSP

字号:

<%@ page contentType="text/html;charset=gb2312"%>
<html>
<head>
<meta http-equiv="content-type" content="text/html;charset=gb2312">
<title>输出查询结果页面</title>
</head>
<BODY background="images/large_9323l69.jpg">

<!-- 设置脚本语言为java,引用java.sql包 -->
<%@ page language="java" import="java.sql.*" %>
<%
    
    
    try {
      // 登记JDBC驱动程序
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      //连接数据库
      Connection con = DriverManager.getConnection("jdbc:odbc:stu","", "");
      //创建语句对象
      Statement statement = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
	   request.setCharacterEncoding("gb2312");
	  String Number=request.getParameter("number");
	  String Name=request.getParameter("name");
	  String Sex=request.getParameter("sex");
      String BirthDate=request.getParameter("birthDate");
	  String Score=request.getParameter("score");
	  String Address=request.getParameter("address");
	  String Youbian=request.getParameter("youbian");
	  String Phone=request.getParameter("phone");
	  String Card=request.getParameter("card");
	  String Email=request.getParameter("email");
	  //执行SQL语句
	   
	  String mysql="update stu set  stuName='"+Name+"',sex='"+Sex+"',birthDate='"+BirthDate+"',score='"+Score+"',address='"+Address+"',youbian='"+Youbian+"',phone='"+Phone+"',card='"+Card+"',email='"+Email+"' where stuNum='"+Number+"' ";
          //将Unicode编码的String类型数据转化为“ISO-8859-1”编码
          byte[] temp=mysql.getBytes("ISO-8859-1");
          mysql=new String(temp);
      	 statement.executeUpdate(mysql);
      //取得结果，输出到屏幕
 

    
  
         
        out.print("恭喜你！修改信息成功!");
                                           //关闭记录集对象
        statement.close();                                //关闭语句对象
        con.close();                                //关闭连接对象
    }catch(Exception e){
        out.print("数据库连接错误！,错误信息如:");
        out.print(e.getMessage());
   }
 %>
</p>
<p align="center"><font color="#0033FF" size="6">注册信息已修改!</font></p>
 
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -