在注册页面点击确定执行以下jsp文件
<%@ page contentType="html/text; charset=gb2312" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="sqlbean" scope="session" class="com.seagull.dbconnect.SQLConnect" /><%
String strname=sqlbean.to_8859_1(request.getParameter("name"));
String username=sqlbean.to_8859_1(request.getParameter("username"));
String password=sqlbean.to_8859_1(request.getParameter("password"));
String question=sqlbean.to_8859_1(request.getParameter("question"));
String answer=sqlbean.to_8859_1(request.getParameter("answer"));
String depart=sqlbean.to_8859_1(request.getParameter("company"));
String mobile=sqlbean.to_8859_1(request.getParameter("mobile"));
String telnum=sqlbean.to_8859_1(request.getParameter("telnum"));
String email=sqlbean.to_8859_1(request.getParameter("email"));
String pagesize=sqlbean.to_8859_1(request.getParameter("pagesize"));
String remoteIP= request.getRemoteAddr();
Calendar now=Calendar.getInstance();
String sj=now.get(Calendar.YEAR)+"-"+now.get(Calendar.MONTH)+1+"-"+now.get(Calendar.DAY_OF_MONTH)+" "+now.get(Calendar.HOUR_OF_DAY)+":"+now.get(Calendar.MINUTE)+":"+now.get(Calendar.SECOND);
String sql="select * from RegUser where username='"+strname+"' or rname='"+username+"'";
sqlbean.executeQuery(sql);
if(sqlbean.next())
{
out.println("用户名重复!请重试");
}
else
{
sql="insert into RegUser(rname, username, password, depart, email, question, answer, regtime, IP, phone, mobile, pagesize) values ('"
+ username + "','" + strname + "','" + password + "','" + depart + "','" + email + "','" + question + "','" + answer + "','"+ sj + "','"
+ remoteIP + "','" + telnum + "','" + mobile + "'," + pagesize + ")" ;
sqlbean.executeUpdate(sql);
System.out.println(sql);
sql="select ID from RegUser where username='"+ strname+"'" ;
sqlbean.executeQuery(sql);
if(sqlbean.next())
{
sql="insert into userinfo(userid, username, Ltime, phone, mobile, email) values ('"
+ sqlbean.getString("ID") + "','" + username + "','" + sj + "','" + telnum + "','" + mobile + "','" + email + "')";
sqlbean.executeUpdate(sql);
out.println("用户注册成功!");
}
}
sqlbean.close();
%>
用户注册信息都写进数据库了,可是不显示用户注册成功信息,最奇怪的是弹出下载文件对话框,请各位赐教!谢谢
<%@ page contentType="html/text; charset=gb2312" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="sqlbean" scope="session" class="com.seagull.dbconnect.SQLConnect" /><%
String strname=sqlbean.to_8859_1(request.getParameter("name"));
String username=sqlbean.to_8859_1(request.getParameter("username"));
String password=sqlbean.to_8859_1(request.getParameter("password"));
String question=sqlbean.to_8859_1(request.getParameter("question"));
String answer=sqlbean.to_8859_1(request.getParameter("answer"));
String depart=sqlbean.to_8859_1(request.getParameter("company"));
String mobile=sqlbean.to_8859_1(request.getParameter("mobile"));
String telnum=sqlbean.to_8859_1(request.getParameter("telnum"));
String email=sqlbean.to_8859_1(request.getParameter("email"));
String pagesize=sqlbean.to_8859_1(request.getParameter("pagesize"));
String remoteIP= request.getRemoteAddr();
Calendar now=Calendar.getInstance();
String sj=now.get(Calendar.YEAR)+"-"+now.get(Calendar.MONTH)+1+"-"+now.get(Calendar.DAY_OF_MONTH)+" "+now.get(Calendar.HOUR_OF_DAY)+":"+now.get(Calendar.MINUTE)+":"+now.get(Calendar.SECOND);
String sql="select * from RegUser where username='"+strname+"' or rname='"+username+"'";
sqlbean.executeQuery(sql);
if(sqlbean.next())
{
out.println("用户名重复!请重试");
}
else
{
sql="insert into RegUser(rname, username, password, depart, email, question, answer, regtime, IP, phone, mobile, pagesize) values ('"
+ username + "','" + strname + "','" + password + "','" + depart + "','" + email + "','" + question + "','" + answer + "','"+ sj + "','"
+ remoteIP + "','" + telnum + "','" + mobile + "'," + pagesize + ")" ;
sqlbean.executeUpdate(sql);
System.out.println(sql);
sql="select ID from RegUser where username='"+ strname+"'" ;
sqlbean.executeQuery(sql);
if(sqlbean.next())
{
sql="insert into userinfo(userid, username, Ltime, phone, mobile, email) values ('"
+ sqlbean.getString("ID") + "','" + username + "','" + sj + "','" + telnum + "','" + mobile + "','" + email + "')";
sqlbean.executeUpdate(sql);
out.println("用户注册成功!");
}
}
sqlbean.close();
%>
用户注册信息都写进数据库了,可是不显示用户注册成功信息,最奇怪的是弹出下载文件对话框,请各位赐教!谢谢
解决方案 »
- 用控件生成了一个table 现在想给table的td增加事件,这些td都是控件生成,现在我无法找到这些td
- 问:读不了数据库的表??
- 下载一个大文件时,如何让页面不被重复提交。
- 这是个查询返回结果页面,请问出错的地方应该涉及到哪里的错误!
- ibatis 操作 access 插入一条记录报异常
- JsonStore读取外部文件的问题
- 使用hibernate反向工程建立的项目不能读取数据库
- mybatis的动态sql中有+-*这些运算符,执行报错,怎么办,急急急急
- 请问关于jsp程序中WEB-INF目录的问题
- 向oracle出现这样的错误,什么意思,求大神哦
- 怎样才能让页面不跳转
- 用JSP+MySql的中文乱码问题,输入和输出都可以显示中文,但在MYSQL中却显示乱码?急```求助```````````
<jsp:useBean id="sqlbean" scope="session" class="com.seagull.dbconnect.SQLConnect" />
我原来也出现这种情,就是里面写错了