JAVA SQL语句---注册

package BBS.Ceate;


import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


import java.sql.*;


public class CreateUser extends HttpServlet
{
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)throws ServletException, IOException 
{
req.setCharacterEncoding("UTF-8");
String UserName=req.getParameter("Name");
String UserPwd=req.getParameter("Pwd");
String UserPwd2=req.getParameter("Spwd");
String Email=req.getParameter("Email");
String Reult =req.getParameter("yuanyin");
String Adress=req.getParameter("Adress");
try {
  //1  加载驱动程序
  Class.forName("oracle.jdbc.driver.OracleDriver");
  //2 获取连接对象
  //2.1 获取连接数据库的字符串
  String url="jdbc:oracle:thin:@localhost:1521:orcl";
  String user="BBS1";//用户名
  String password="123";//密码
  if(UserPwd.equals(UserPwd2))
  {
  Connection con=DriverManager.getConnection(url,user,password);//创建Connection对象接受连接字符串
  String sql="insert into userinfo(userid,USERNAME,userpwd,email,results,adress)values(usernext.nextval,'"+UserName+"','"+UserPwd+"','"+Email+"','"+Reult+"','"+Adress+"')";
  //SQL语句
  
  PreparedStatement stm=con.prepareStatement(sql);
  int i =stm.executeUpdate();
  if(i>0)
  {
  resp.sendRedirect("LoginJsp.jsp");
  System.out.print("注册成功");
  
  }
  else
  {
  System.out.println("注册失败");
  }
  con.close();
  stm.close();
   }   
  else
  {
 System.out.println("密码不一致");
  }
}
catch (ClassNotFoundException e)
{

e.printStackTrace();
} catch (SQLException e) 
{
// TODO Auto-generated catch block
e.printStackTrace();
}




  }


}