📄 updatesongset.jsp
字号:
<%@ 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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -