updatesongset.jsp

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

JSP
34
字号
<%@ 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 kind=LoadDriver.convert(request.getParameter("kind"));
  String district=LoadDriver.convert(request.getParameter("district"));
  String description=LoadDriver.convert(request.getParameter("description"));
 
  {
 
  DBManager db=DBManager.getInstance("localhost","music","root","589060"); 
  Connection con=db.getCon();
  String sql="update  songset set name='"+name+"', kind='"+kind+"',district='"+
       district+"', description='"+description+"' where id="+id; 
  try{
  con.setAutoCommit(false);
 
  db.executeUpdate(sql);
  con.commit();
  con.setAutoCommit(true);
  out.print("修改成功!");
   }
  catch(Exception e){
     con.rollback();
     out.print("<p>修改失败!</p>");  
    }    
  }
     %>                                       
</body>
</html>

⌨️ 快捷键说明

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