困饶好久的有关问题,大家都帮忙,解决一定再加分
日期：2014-05-18 浏览次数：20532 次
困饶好久的问题,大家都帮忙,解决一定再加分
这段代码 向数据库插一条记录,但莫明奇妙的会一下子插入2条相同的数据
<%@ page contentType= "text/html; charset=gb2312 " language= "java " import= "java.sql.* " errorPage= " " %>
<html>
<head>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<title> 信息录入 </title>
//数据库连接JDBC
<jsp:useBean id= "connection " scope= "request " class= "com.JDBConnection "/>
//一个获取系统时间的bean
<jsp:useBean id= "showTime " scope= "request " class= "com.ShowTime "/>
</head>
<link href= "css/style.css " type= "text/css " rel= "stylesheet ">
<body> <br> <br> <br>
<table width= "289 " border= "0 " align= "center " cellpadding= "0 " cellspacing= "0 " background= "image/registerDealwith.jpg ">
<tr>
<td height= "34 "> <font color= "#FFFFFF "> ≡ 注册结果 ≡ </font> </td>
</tr>
<tr align= "center ">
<td height= "206 ">
<%
//为用户注册功能,下面数据是从注册页传来的
request.setCharacterEncoding( "gb2312 ");
String account=request.getParameter( "account ");
String realname=request.getParameter( "realname ");
String password=request.getParameter( "password1 ");
String sex=request.getParameter( "sex ");
String bron=request.getParameter( "bron ");
String tel=request.getParameter( "tel ");
String email=request.getParameter( "email ");
String QQ=request.getParameter( "QQ ");
String office=request.getParameter( "office ");
String CIQ=request.getParameter( "CIQ ");
//insert语句
String sql= "insert into t_user (account,realname,password,sex,bron,tel,email,QQ,office,CIQ,userRight) values( ' "+account+ " ', ' "+realname+ " ', ' "+password+ " ', ' "+sex+ " ', ' "+bron+ " ', ' "+tel+ " ', ' "+email+ " ', ' "+QQ+ " ', ' "+office+ " ', ' "+CIQ+ " ', '0 ') ";
if(connection.executeUpdate(sql)){%>
<p> <b> <font color= "#FF0000 "> 恭喜你注册成功! </font> </b> </p>
<meta http-equiv= "refresh " content= "5;URL=index.jsp "> //如不用自动跳转就没问题
<%}else{%>
<p> <b> <font color= "#FF0000 "> 该用户名已存在!请重新注册! </font> </b> </p>
<meta http-equiv= "refresh " content= "5;URL=index.jsp "> //如不用自动跳转就没问题
<%}%>
<%connection.closeConnection();%>
<p> <a href= "index.jsp "> （如果您的浏览器无法自动跳转，请点击这里。） </a> </p> </td>
</tr>
</tr>
</table>
这段代码 向数据库插一条记录,但莫明奇妙的会一下子插入2条相同的数据
<%@ page contentType= "text/html; charset=gb2312 " language= "java " import= "java.sql.* " errorPage= " " %>
<html>
<head>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<title> 信息录入 </title>
//数据库连接JDBC
<jsp:useBean id= "connection " scope= "request " class= "com.JDBConnection "/>
//一个获取系统时间的bean
<jsp:useBean id= "showTime " scope= "request " class= "com.ShowTime "/>
</head>
<link href= "css/style.css " type= "text/css " rel= "stylesheet ">
<body> <br> <br> <br>
<table width= "289 " border= "0 " align= "center " cellpadding= "0 " cellspacing= "0 " background= "image/registerDealwith.jpg ">
<tr>
<td height= "34 "> <font color= "#FFFFFF "> ≡ 注册结果 ≡ </font> </td>
</tr>
<tr align= "center ">
<td height= "206 ">
<%
//为用户注册功能,下面数据是从注册页传来的
request.setCharacterEncoding( "gb2312 ");
String account=request.getParameter( "account ");
String realname=request.getParameter( "realname ");
String password=request.getParameter( "password1 ");
String sex=request.getParameter( "sex ");
String bron=request.getParameter( "bron ");
String tel=request.getParameter( "tel ");
String email=request.getParameter( "email ");
String QQ=request.getParameter( "QQ ");
String office=request.getParameter( "office ");
String CIQ=request.getParameter( "CIQ ");
//insert语句
String sql= "insert into t_user (account,realname,password,sex,bron,tel,email,QQ,office,CIQ,userRight) values( ' "+account+ " ', ' "+realname+ " ', ' "+password+ " ', ' "+sex+ " ', ' "+bron+ " ', ' "+tel+ " ', ' "+email+ " ', ' "+QQ+ " ', ' "+office+ " ', ' "+CIQ+ " ', '0 ') ";
if(connection.executeUpdate(sql)){%>
<p> <b> <font color= "#FF0000 "> 恭喜你注册成功! </font> </b> </p>
<meta http-equiv= "refresh " content= "5;URL=index.jsp "> //如不用自动跳转就没问题
<%}else{%>
<p> <b> <font color= "#FF0000 "> 该用户名已存在!请重新注册! </font> </b> </p>
<meta http-equiv= "refresh " content= "5;URL=index.jsp "> //如不用自动跳转就没问题
<%}%>
<%connection.closeConnection();%>
<p> <a href= "index.jsp "> （如果您的浏览器无法自动跳转，请点击这里。） </a> </p> </td>
</tr>
</tr>
</table>
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
