81,122
社区成员
发帖
与我相关
我的任务
分享关于插入的一个非常奇怪的问题！，做程序一年了，还从未遇见。。。。。。。。。。
小弟，要在数据库里插入一条记录，可是数据库里却出现两条相同的记录，请问为什么阿？！
register.jsp
<%@page contentType="text/html;charset=gb2312"%>
<html>
<head>
<title>
</title>
<link href="../css/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<%@include file="../include/top.jsp"%>
<center>
<form name="register" action="registerResult.jsp" method="get">
<table border="0">
<tr>
<td><font color="red">*</font>区号:</td>
<td>
<select name="areanum" size="1">
<option>0550</option>
<option>0551</option>
<option>0552</option>
<option>0553</option>
<option>0554</option>
<option>0555</option>
<option>0556</option>
<option>0557</option>
<option>0558</option>
<option>0559</option>
<option>0561</option>
<option>0562</option>
<option>0563</option>
<option>0564</option>
<option>0565</option>
<option>0566</option>
</select>
</td>
</tr>
<tr>
<td><font color="red">*</font>小灵通号码:</td>
<td><input type="text" name="telnum" size="20" maxlength="7"/></td>
</tr>
<tr>
<td><font color="red">*</font>登录密码:</td>
<td><input type="password" name="password" size="20"/></td>
</tr>
<tr>
<td> 密码查询问题:</td>
<td><input type="text" name="ask" size="20" maxlength="20"/></td>
</tr>
<tr>
<td> 密码查询答案:</td>
<td><input type="text" name="answer" size="20" maxlength="20"/></td>
</tr>
<tr>
<td> 真实姓名:</td>
<td><input type="text" name="name" size="20"/></td>
</tr>
<tr>
<td> 性别:</td>
<td>
<input type="radio" name="sex" value="1" checked="true"/>男
<input type="radio" name="sex" value="0"/>女
</td>
</tr>
<tr>
<td> 身份证号码:</td>
<td><input type="text" name="nameid" size="20"/></td>
</tr>
<tr>
<td> email:</td>
<td><input type="text" name="email" size="20"/></td>
</tr>
</table>
<br>
<input type="submit" size="20" value="注册"/>
<input type="reset" size="20" value="取消"/>
</form>
</center>
<%@include file="../include/tail.jsp"%>
</body>
</html>
registerResult.jsp
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,forum.*" %>
<html>
<head>
<title>
</title>
</head>
<body>
<jsp:useBean id="registerForm" scope="page" class="forum.InforForm">
<jsp:setProperty name="registerForm" property="*"/>
</jsp:useBean>
<jsp:useBean id="insertRegister" scope="page" class="forum.ExecModel"/>
<%
insertRegister.insertRegister(registerForm);
%>
</body>
</html>
javabean
ExecModel.java
package forum;
import java.sql.*;
import java.io.*;
import forum.*;
public class ExecModel{
/**
*插入用户的注册的相关信息的方法
*@param form 用户的个人资料
*@throws Exception 抛出异常
*
*/
public void insertRegister(InforForm form) throws Exception{
DataBase db = new DataBase();
String strsql = "insert into register values('"+form.getAreanum()+"','"+form.getTelnum()+"','"+form.getPassword()+"','"+form.getAsk()+"','"+form.getAnswer()+"','"+form.getName()+"','"+form.getSex()+"','"+form.getNameid()+"','"+form.getEmail()+"')";
db.insert(strsql);
db.close();
}
请各位指点！不胜感激！
}
register.jsp
<%@page contentType="text/html;charset=gb2312"%>
<html>
<head>
<title>
</title>
<link href="../css/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<%@include file="../include/top.jsp"%>
<center>
<form name="register" action="registerResult.jsp" method="get">
<table border="0">
<tr>
<td><font color="red">*</font>区号:</td>
<td>
<select name="areanum" size="1">
<option>0550</option>
<option>0551</option>
<option>0552</option>
<option>0553</option>
<option>0554</option>
<option>0555</option>
<option>0556</option>
<option>0557</option>
<option>0558</option>
<option>0559</option>
<option>0561</option>
<option>0562</option>
<option>0563</option>
<option>0564</option>
<option>0565</option>
<option>0566</option>
</select>
</td>
</tr>
<tr>
<td><font color="red">*</font>小灵通号码:</td>
<td><input type="text" name="telnum" size="20" maxlength="7"/></td>
</tr>
<tr>
<td><font color="red">*</font>登录密码:</td>
<td><input type="password" name="password" size="20"/></td>
</tr>
<tr>
<td> 密码查询问题:</td>
<td><input type="text" name="ask" size="20" maxlength="20"/></td>
</tr>
<tr>
<td> 密码查询答案:</td>
<td><input type="text" name="answer" size="20" maxlength="20"/></td>
</tr>
<tr>
<td> 真实姓名:</td>
<td><input type="text" name="name" size="20"/></td>
</tr>
<tr>
<td> 性别:</td>
<td>
<input type="radio" name="sex" value="1" checked="true"/>男
<input type="radio" name="sex" value="0"/>女
</td>
</tr>
<tr>
<td> 身份证号码:</td>
<td><input type="text" name="nameid" size="20"/></td>
</tr>
<tr>
<td> email:</td>
<td><input type="text" name="email" size="20"/></td>
</tr>
</table>
<br>
<input type="submit" size="20" value="注册"/>
<input type="reset" size="20" value="取消"/>
</form>
</center>
<%@include file="../include/tail.jsp"%>
</body>
</html>
registerResult.jsp
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,forum.*" %>
<html>
<head>
<title>
</title>
</head>
<body>
<jsp:useBean id="registerForm" scope="page" class="forum.InforForm">
<jsp:setProperty name="registerForm" property="*"/>
</jsp:useBean>
<jsp:useBean id="insertRegister" scope="page" class="forum.ExecModel"/>
<%
insertRegister.insertRegister(registerForm);
%>
</body>
</html>
javabean
ExecModel.java
package forum;
import java.sql.*;
import java.io.*;
import forum.*;
public class ExecModel{
/**
*插入用户的注册的相关信息的方法
*@param form 用户的个人资料
*@throws Exception 抛出异常
*
*/
public void insertRegister(InforForm form) throws Exception{
DataBase db = new DataBase();
String strsql = "insert into register values('"+form.getAreanum()+"','"+form.getTelnum()+"','"+form.getPassword()+"','"+form.getAsk()+"','"+form.getAnswer()+"','"+form.getName()+"','"+form.getSex()+"','"+form.getNameid()+"','"+form.getEmail()+"')";
db.insert(strsql);
db.close();
}
请各位指点！不胜感激！
}
...全文
请发表友善的回复…
发表回复
love620 2006-02-21
- 打赏
- 举报
怎么没人顶阿?
