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 + -
显示快捷键?