|
|
|||
|
<%
HttpSession verify_number_session=request.getSession(true);
String tencha="";String loi_tencha="";String tenme="";String loi_tenme="";String giosinh="";String loi_giosinh="";
String loi_verify="";String kieugio="";String ngayduong="";String thangduong="";String namduong="";String loi_ten="";
String thongbao="";String email="";String loi_email="";String noisinh="";String loi_noisinh="";
String ten1="";String ten2="";String ten3="";String ten4="";String ten5="";String ten6="";String ten7="";String ten8="";String ten9="";String ten10="";
boolean err=true;
if(request.getMethod()=="POST"){
noisinh=request.getParameter("noisinh").replaceAll("'","''");
if(noisinh.equals("")){
loi_noisinh="* Vui lòng cho biết nơi sinh.";
err=false;
}
// tam thoi bo qua phan bat buoc nhap noi sinh
loi_noisinh="";
err=true;
tencha=request.getParameter("tencha").replaceAll("'","''");
if(tencha.equals("")){
loi_tencha="* Vui lòng cho biết tên cha.";
err=false;
}
tenme=request.getParameter("tenme").replaceAll("'","''");
if(tenme.equals("")){
loi_tenme="* Vui lòng cho biết tên mẹ.";
err=false;
}
email=request.getParameter("email").replaceAll("'","''");
if(email.equals("")){
loi_email="* Vui lòng cho biết email.";
err=false;
}
Object vSession=verify_number_session.getAttribute("verifyNumber");
String uSession=request.getParameter("userverify");
String vCode="";
try{vCode=vSession.toString();}catch(Exception ee){vCode="";}
if(!vCode.equals(uSession)||uSession.equals("")){
loi_verify="* Mã xác nhận không chính xác.";
err=false;
}
giosinh=request.getParameter("giosinh");
//int giosinh_int=-1;
//try {giosinh_int=Integer.parseInt(giosinh);}
//catch (NumberFormatException nfe){giosinh_int=-1;}
if(giosinh.equals("")){
loi_giosinh="* Vui lòng cho biết giờ sinh.";
err=false;
}
// tam thoi bo qua phan bat buoc nhap gio sinh
loi_giosinh="";
err=true;
kieugio=request.getParameter("kieugio");
ngayduong=request.getParameter("ngayduong");
thangduong=request.getParameter("thangduong");
namduong=request.getParameter("namduong");
ten1=request.getParameter("ten1").replaceAll("'","''");
ten2=request.getParameter("ten2").replaceAll("'","''");
ten3=request.getParameter("ten3").replaceAll("'","''");
ten4=request.getParameter("ten4").replaceAll("'","''");
ten5=request.getParameter("ten5").replaceAll("'","''");
ten6=request.getParameter("ten6").replaceAll("'","''");
ten7=request.getParameter("ten7").replaceAll("'","''");
ten8=request.getParameter("ten8").replaceAll("'","''");
ten9=request.getParameter("ten9").replaceAll("'","''");
ten10=request.getParameter("ten10").replaceAll("'","''");
if(ten1.equals("") && ten2.equals("") && ten3.equals("") && ten4.equals("") && ten5.equals("") &&
ten6.equals("") && ten7.equals("") && ten8.equals("") && ten9.equals("") && ten10.equals("")){
loi_ten="* Vui lòng chọn ít nhất một tên.";
err=false;
}
String ten=ten1+"@"+ten2+"@"+ten3+"@"+ten4+"@"+ten5+"@"+ten6+"@"+ten7+"@"+ten8+"@"+ten9+"@"+ten10;
//if(kieugio.equals("pm") && giosinh_int<=12) giosinh_int+=12;
String ngaysinh=ngayduong+"/"+thangduong+"/"+namduong;
if(err){
try{
String DBUrl = "jdbc:mysql://localhost:3306/tuvigl2_tuvi";
String DBUserName = "tuviuser";
String DBPassword = "EP2F469pnV6Dw3YG";
Class.forName("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection(DBUrl, DBUserName, DBPassword);
Statement stmt = con.createStatement();
//ResultSet rs = stmt.executeQuery("SELECT email FROM user_info WHERE user_id ='"+sLogin+"'");
//if(rs.next()){
//String email=rs.getString("email");
String sql = "INSERT INTO datten(tencha, tenme, giosinh, ngaysinh, ten, postdate,username,email,kieugio,noisinh) VALUES (";
sql+="'"+tencha+"', '"+tenme+"', '"+giosinh+"', '"+ngaysinh+"', '"+ten+"', now(),'"+sLogin+"','"+email+"','"+kieugio+"','"+noisinh+"')";
// out.write(sql);
PreparedStatement st=con.prepareStatement(sql);
st.executeUpdate();
//}
stmt.close();
con.close();
thongbao="|||
|
Copyright © 2003-2008 TuviGLOBAL. All Rights Reserved. Developed by QNESoft. Powered by : TuviGLOBAL 1.2 |