📄 tianjia.jsp

📁 一个简单实用的网上书城,可当作原型使用

💻 JSP

字号:

<%@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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -