添加数据项
有两个文件
insert_1.jsp insert_1.jsp
需要用的JavaBean以及设置的文件路径请参阅本人“JavaBean实现中文转换”
insert_1.jsp 代码如下
<%@page contentType="text/html; charset=gb2312" language="java" errorPage=""%>
<html>
<head>
<title>插入记录——1</title>
</head>
<body>
<p align="center" class=style6>输入信息</p>
<form action="insert_2.jsp" name="form1" method="POST">
<div align="center">
<p> </p>
<p> name:
<input type="text" name="name">
</p>
<p> age:
<input type="text" name="age">
</p>
<p> sno:
<input type="text" name="sno">
</p>
<p> password:
<input type="text" name="password">
<input type="submit" name="Submit" value="添加">
</p>
</div>
</form>
</body>
</html>
insert_2.jsp 代码如下
<%@page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<html>
<head>
<title>插入记录——2</title>
<body>
<jsp:useBean id="ISO_GB" scope="page" class="com.modify.ISOtoGB"/>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=369";
String user="sa";
String pass="";
Connection conn=DriverManager.getConnection(url,user,pass);
Statement stmt=conn.createStatement();
String name=ISO_GB.convert(request.getParameter("name"));
String age = request.getParameter("age");
String sno = request.getParameter("sno");
String password = request.getParameter("password");
String sql = "insert into tb_stu (name,age,sno,password) values ('"+name+"','"+age+"','"+sno+"','"+password+"')";
stmt.executeUpdate(sql);
stmt.close();
conn.close();
%>
<center>
<h2 class="style1">添加记录</h2>
<p>
<br>
<span class="style3"><span class="style4">添加成功</span>!</span>
</p>
<form action="insert_1.jsp" name="form1" method="POST">
<input type="submit" id="back" name="back" value="返回" onClick="index.jsp">
</form>
<p>
</p>
</center>
</body>
</html>