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