updatesinger.jsp

来自「音乐信息管理系统」· JSP 代码 · 共 40 行

JSP
40
字号
<%@ page contentType="text/html;charset=gb2312" language="java"
 import="java.sql.*,music.*" errorPage="" %>
<html>
<head></head>
<body>
<%
    String id=LoadDriver.convert(request.getParameter("id"));
    
    String name=LoadDriver.convert(request.getParameter("name"));
    String sex=LoadDriver.convert(request.getParameter("sex"));
    String address=LoadDriver.convert(request.getParameter("address"));
    String intro=LoadDriver.convert(request.getParameter("intro"));
    String interest=LoadDriver.convert(request.getParameter("interest"));
    String hotdegree=LoadDriver.convert(request.getParameter("hotdegree"));
    String sql=null;
    DBManager db=DBManager.getInstance("localhost","music","root","589060");
    Connection con=db.getCon();
    ResultSet rs=null;
    try{
    con.setAutoCommit(false);
    
    sql="update  singer set name='"+name+"', address='"+address+"',sex='"+
       sex+"', intro='"+intro+"',hotdegree='"+hotdegree+
          "', interest='"+interest+"'  where id="+id; 
    
    
    
    db.executeUpdate(sql);
    con.setAutoCommit(true);
    out.print("修改成功!");
    }
    catch(Exception e)
    {
      con.rollback();
      out.print("修改失败!");
      e.printStackTrace();
    }
%>
</body>
</html>

⌨️ 快捷键说明

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