/**
*这是一个注册界面
*/
package user;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class ureg extends HttpServlet{
public void doPost(HttpServletRequest req,HttpServletResponse res){
doGet(req,res);
}
public void doGet(HttpServletRequest req,HttpServletResponse res){
try{
//解决中文乱码问题
res.setContentType("text/html; charset=gbk");
//获得一个输出对象
PrintWriter pw=res.getWriter();
pw.write("<html>");
pw.write("<head>");
pw.write("<meta http-equiv=Content-Type content=text/html; charset=gbk/>");
pw.write("<title>用户注册</title>");
pw.write("<style type=text/css>");
pw.write("html{font-size:12px;}");
pw.write("fieldset{width:520px; margin: 0 auto;}");
pw.write("legend{font-weight:bold; font-size:14px;}");
pw.write("label{float:left; width:70px; margin-left:10px;}");
pw.write(".left{margin-left:80px;}");
pw.write(".input{width:150px;}");
pw.write("span{color: #666666;}");
pw.write(" </style>");
pw.write("</head>");
pw.write("<body>");
//pw.write("<p> <br>");
pw.write("<div/> <div/> <div/> <div/> ");
pw.write("<div>");
pw.write("<fieldset>");
pw.write("<legend>欢迎注册</legend>");
pw.write("<form name=regform method=post action=uregcl>");
pw.write("<p>");
pw.write("<label for=userId class=label>用户名:</label>");
pw.write("<input id=userId name=userId type=text class=inpu />");
pw.write("<span>(必填,3-15字符长度,支持汉字、字母、数字及_)</span>");
pw.write("<p/>");
pw.write("<p>");
pw.write("<label for=userName class=label>姓 名:</label>");
pw.write("<input id=userName name=userName type=text class=input />");
pw.write("<span>(必填,2-4字符长度)</span>");
pw.write("<p/>");
pw.write("<p>");
pw.write("<label for=userSex class=label>性 别:</label>");
pw.write("<input id=userSexM name=userSex type=radio class=userSex/>男");
pw.write("      ");
pw.write("<input id=userSexW name=userSex type=radio class=userSex />女");
pw.write("<span>        (必选其一)</span>");
pw.write("<p/>");
pw.write("<p>");
pw.write("<label for=userAge class=label>年龄:</label>");
pw.write("<input id=userAge name=userAge type=text class=input />");
pw.write("<span>(必填,2-3字符长度)</span>");
pw.write("<p/>");
pw.write("<p>");
pw.write("<label for=userQuestion class=label>密保问题:</label>");
pw.write("<input id=userQuestion name=userQuestion type=text class=input />");
pw.write("<span>(必填,5-100字符长度)</span>");
pw.write("<p/>");
pw.write("<p>");
pw.write("<label for=userAnswer class=label>密保答案:</label>");
pw.write("<input id=userAnswer name=userAnswer type=text class=input />");
pw.write("<span>(必填,5-100字符长度)</span>");
pw.write("<p/>");
pw.write("<p>");
pw.write("<label for=password class=label>密 码:</label>");
pw.write("<input id=password name=userPassword type=password class=input/>");
pw.write("<span>(必填,不得少于6位)</span>");
pw.write("<p/>");
pw.write("<p>");
pw.write("<label for=repassword class=label>重复密码:</label>");
pw.write("<input id=repassword name=repassword type=password class=input />");
pw.write("<p/>");
pw.write("<p>");
pw.write("<label for=email class=label>电子邮箱:</label>");
pw.write("<input id=email name=userEmail type=text class=input />");
pw.write("<span>(必填)</span>");
pw.write("<p/>");
pw.write("<p>");
pw.write("<input type=reset name=reset value=全部充填 class=left />");
pw.write("<input type=submit name=sbreg value=提交注册 class=left />");
pw.write("</p>");
pw.write("</form>");
pw.write("</fieldset>");
pw.write("</div>");
pw.write("</body>");
pw.write("<html>");
}catch(Exception ex){
ex.printStackTrace();
}
}
}
这是注册页面MySQLServletHTML
*这是一个注册界面
*/
package user;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class ureg extends HttpServlet{
public void doPost(HttpServletRequest req,HttpServletResponse res){
doGet(req,res);
}
public void doGet(HttpServletRequest req,HttpServletResponse res){
try{
//解决中文乱码问题
res.setContentType("text/html; charset=gbk");
//获得一个输出对象
PrintWriter pw=res.getWriter();
pw.write("<html>");
pw.write("<head>");
pw.write("<meta http-equiv=Content-Type content=text/html; charset=gbk/>");
pw.write("<title>用户注册</title>");
pw.write("<style type=text/css>");
pw.write("html{font-size:12px;}");
pw.write("fieldset{width:520px; margin: 0 auto;}");
pw.write("legend{font-weight:bold; font-size:14px;}");
pw.write("label{float:left; width:70px; margin-left:10px;}");
pw.write(".left{margin-left:80px;}");
pw.write(".input{width:150px;}");
pw.write("span{color: #666666;}");
pw.write(" </style>");
pw.write("</head>");
pw.write("<body>");
//pw.write("<p> <br>");
pw.write("<div/> <div/> <div/> <div/> ");
pw.write("<div>");
pw.write("<fieldset>");
pw.write("<legend>欢迎注册</legend>");
pw.write("<form name=regform method=post action=uregcl>");
pw.write("<p>");
pw.write("<label for=userId class=label>用户名:</label>");
pw.write("<input id=userId name=userId type=text class=inpu />");
pw.write("<span>(必填,3-15字符长度,支持汉字、字母、数字及_)</span>");
pw.write("<p/>");
pw.write("<p>");
pw.write("<label for=userName class=label>姓 名:</label>");
pw.write("<input id=userName name=userName type=text class=input />");
pw.write("<span>(必填,2-4字符长度)</span>");
pw.write("<p/>");
pw.write("<p>");
pw.write("<label for=userSex class=label>性 别:</label>");
pw.write("<input id=userSexM name=userSex type=radio class=userSex/>男");
pw.write("      ");
pw.write("<input id=userSexW name=userSex type=radio class=userSex />女");
pw.write("<span>        (必选其一)</span>");
pw.write("<p/>");
pw.write("<p>");
pw.write("<label for=userAge class=label>年龄:</label>");
pw.write("<input id=userAge name=userAge type=text class=input />");
pw.write("<span>(必填,2-3字符长度)</span>");
pw.write("<p/>");
pw.write("<p>");
pw.write("<label for=userQuestion class=label>密保问题:</label>");
pw.write("<input id=userQuestion name=userQuestion type=text class=input />");
pw.write("<span>(必填,5-100字符长度)</span>");
pw.write("<p/>");
pw.write("<p>");
pw.write("<label for=userAnswer class=label>密保答案:</label>");
pw.write("<input id=userAnswer name=userAnswer type=text class=input />");
pw.write("<span>(必填,5-100字符长度)</span>");
pw.write("<p/>");
pw.write("<p>");
pw.write("<label for=password class=label>密 码:</label>");
pw.write("<input id=password name=userPassword type=password class=input/>");
pw.write("<span>(必填,不得少于6位)</span>");
pw.write("<p/>");
pw.write("<p>");
pw.write("<label for=repassword class=label>重复密码:</label>");
pw.write("<input id=repassword name=repassword type=password class=input />");
pw.write("<p/>");
pw.write("<p>");
pw.write("<label for=email class=label>电子邮箱:</label>");
pw.write("<input id=email name=userEmail type=text class=input />");
pw.write("<span>(必填)</span>");
pw.write("<p/>");
pw.write("<p>");
pw.write("<input type=reset name=reset value=全部充填 class=left />");
pw.write("<input type=submit name=sbreg value=提交注册 class=left />");
pw.write("</p>");
pw.write("</form>");
pw.write("</fieldset>");
pw.write("</div>");
pw.write("</body>");
pw.write("<html>");
}catch(Exception ex){
ex.printStackTrace();
}
}
}
这是注册页面MySQLServletHTML
package user;
//import java.io.*;
//import javax.servlet.*;
//import javax.servlet.http.*;
//import java.sql.*;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;public class uregcl extends HttpServlet{
public void doPost(HttpServletRequest req,HttpServletResponse res){
doGet(req,res);
}
public void doGet(HttpServletRequest req,HttpServletResponse res){
Connection ct = null;
Statement st=null;
// ResultSet rs=null;
try{
res.setContentType("text/html;charset=gbk");
PrintWriter pw=res.getWriter();
//pw.print("恭喜你注册成功!");
//用户名
String userID=req.getParameter("userId");
//姓名
String userName=req.getParameter("userName");
//性别
String userSex=req.getParameter("userSex");
//年龄
String userage=req.getParameter("userAge");
//转换成int类型
int userAge=Integer.parseInt(userage);
//问题
String userQuestion=req.getParameter("userQuestion");
//答案
String userAnswer=req.getParameter("userAnswer");
//密码
String userPassword=req.getParameter("userPassword");
//邮箱
String userEmail=req.getParameter("userEmail");
//?
pw.print("+userName+");
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
String str="insert into user(userID,userPassword,userName,userSex,userAge,userEmail,userQuestion,userAnswer) values('"+userID+"','"+userPassword+"','"+userName+"','"+userSex+"','"+userAge+"','"+userEmail+"','"+userQuestion+"','"+userAnswer+"')";
ct=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306","root","123");
st=ct.createStatement();
int s=st.executeUpdate(str);
}catch(Exception ex){
ex.printStackTrace();
}finally{
//不管是否抛出异常都会执行
try{
//分别判断是否为空
//不为空时关闭资源
//if(rs!=null){
// rs.close();
// }
if(st!=null){
st.close();
}
if(ct!=null){
ct.close();
}
}catch(Exception ex){
ex.printStackTrace();
}
}
}
}这是注册页面处理数据库里还是没有记录,而且我用pw.print("+userName+");来查看下值有没有传来,但是打开网页就是一片空白。其他都没有错啊,这是为啥?表里面就是没有数据!!!!!!!!!!!!!!!