updatesinger.jsp
来自「音乐信息管理系统」· JSP 代码 · 共 40 行
JSP
40 行
<%@ 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 sex=LoadDriver.convert(request.getParameter("sex"));
String address=LoadDriver.convert(request.getParameter("address"));
String intro=LoadDriver.convert(request.getParameter("intro"));
String interest=LoadDriver.convert(request.getParameter("interest"));
String hotdegree=LoadDriver.convert(request.getParameter("hotdegree"));
String sql=null;
DBManager db=DBManager.getInstance("localhost","music","root","589060");
Connection con=db.getCon();
ResultSet rs=null;
try{
con.setAutoCommit(false);
sql="update singer set name='"+name+"', address='"+address+"',sex='"+
sex+"', intro='"+intro+"',hotdegree='"+hotdegree+
"', interest='"+interest+"' 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 + -
显示快捷键?