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 + -
显示快捷键?