updatesong.jsp

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

JSP
36
字号
<%@ 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 kind=LoadDriver.convert(request.getParameter("kind"));
    String description=LoadDriver.convert(request.getParameter("description"));
    String word=LoadDriver.convert(request.getParameter("word"));
    String sql=null;
    DBManager db=DBManager.getInstance("localhost","music","root","589060");
    Connection con=db.getCon();
    ResultSet rs=null;
    try{
    con.setAutoCommit(false);
    
    sql="update  song set kind='"+kind+"', description='"+description+"',word='"+
       word+"'  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 + -
显示快捷键?