singerinfo.jsp

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

JSP
34
字号
<%@ page contentType="text/html;charset=gb2312" language="java"
 import="java.sql.*,music.*" errorPage="" %>
<html>
<head></head>
<body>
<%
    String disccorpid=LoadDriver.convert(request.getParameter("disccorpid"));
    
    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 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="insert into singer(name,sex,address,intro,hotdegree) values('"
         +name+"','"+sex+"','"+address+"','"+intro+"','"+hotdegree+"')";
    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 + -
显示快捷键?