add1.jsp

来自「这是一个简单的网上购物系统」· JSP 代码 · 共 53 行

JSP
53
字号
<%@ page import="java.util.Iterator.*" contentType="text/html;charset=gb2312" %>
	<!--
	errorPage="WEB-INF/error.jsp" contentType="text/html;charset=gb2312"%>
	-->
<%@  taglib prefix="c" uri = "http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<html>
	<head>
		<title>add friend **</title>
	</head>
	<body>
		<jsp:include page="header.jsp" />
		<form name="friend" method="post" action="add1.jsp">
			书&nbsp;&nbsp;名:
			<input type="text" name="name" size="15">
			<br>
			作&nbsp;&nbsp;者:
			<input type="text" name="sex" size="15">
			<br>
			出版商:
			<input type="text" name="qq" size="15">
			<br>	
			类&nbsp;&nbsp;别:
			<input type="text" name="tel" size="15">
			<br>
			卖家联系电话:
			<input type="text" name="email" size="15">
			<br>
			<p>
				<input type="submit" value="提交">
		</form>
	
	<sql:setDataSource driver="sun.jdbc.odbc.JdbcOdbcDriver" url="jdbc:odbc:test"  var="mydb" />
	
	<c:if test="${param.name ne null}">
  	<sql:update var="count" dataSource="${mydb}">
	insert into classmates (name,sex,qq,tel,email,sign) values (?,?,?,?,?,?)
  		<sql:param value = "${param.name}" />
  		<sql:param value = "${param.sex}" />
  		<sql:param value = "${param.qq}" />
  		<sql:param value = "${param.tel}" />
  		<sql:param value = "${param.email}" />
  			<sql:param value = "${sessionScope.ID}" />
  	</sql:update>	
	
  		<c:out value="Add into th database successfully!"/>
	</c:if>
	</body>
</html>



⌨️ 快捷键说明

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