tianjia.jsp

来自「一个简单实用的网上书城,可当作原型使用」· JSP 代码 · 共 45 行

JSP
45
字号
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@page language="java" import="java.sql.*"%>
<jsp:useBean id="db" scope="page" class="czm.opendb"/>

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
          <title>添加信息</title>
    </head>
    <body>
        <%String tmpmemberID=request.getParameter("memberID");  
        String memberID=null;
        memberID=new String(tmpmemberID.getBytes("ISO8859-1"),"UTF-8");
        
       
 		 String tmpisbn=request.getParameter("BookISBN");
        String BookISBN=null;
        BookISBN=new String(tmpisbn.getBytes("ISO8859-1"),"UTF-8");
		
		 String tmpdate=request.getParameter("keepdate");
        String keepdate=null;
        keepdate=new String(tmpdate.getBytes("ISO8859-1"),"UTF-8");
		
		
		
        String sql="SELECT * FROM Keepbook WHERE memberID='"+memberID+"'";
        ResultSet rs=db.executeQuery(sql);
        if(rs.next())
        {%>
            你好 
        <%
        }
        else
        {
        String sql2="INSERT INTO Keepbook VALUES('"+memberID+"','"+BookISBN+"','"+keepdate+"')";
        ResultSet rs2=db.executeQuery(sql2); 
        %>
        <p>添加成功!</p>
        <%
        }
        %>   
    </body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?