reg2.jsp

vod播放器的编辑代码

<%@ include file="conn.jsp"%>
<%@ include file="topMain.jsp"%>
<%
String User1=request.getParameter("User");
String password1=request.getParameter("password");
String sex1=request.getParameter("sex");
String Email1=request.getParameter("Email");



sql="select * from scott.user1 where username='"+User1+"'"; 
rs=stmt.executeQuery(sql); 

	if(rs.next()) {

	out.print("对不起，您输入的用户名已经被注册，请重新输入。");
	}else{
		stmt.executeUpdate("INSERT INTO scott.user1(id,username,password) VALUES(scott.userid.nextval,'"+User1+"','"+password1+"')");
		
%>
<div align="center">
  <center>
<table cellpadding=0 cellspacing=0 border=1 width=760 bgcolor=#3399FF >
  <tr>
    <td align=center>　
        <TR align=middle bgcolor=#414141>
          <TD colSpan=2 height=39 bgcolor=#3399FF width="325">
          　</TD>
        </TR>
        <TR align=middle bgcolor=#414141>
          <TD colSpan=2 height=25 bgcolor=#FFCC99 width="325">
          <span style="font-size: 9pt">会员注册成功</span></TD>
        </TR>
        <TR>
          <TD width=120 align=right bgcolor="#FFFFFF" height="1">
          <span style="font-size: 9pt; font-weight: 700">注册名<span lang="zh-cn">：</span>&nbsp;
          </span></TD>
          <TD bgcolor="#FFFFFF" height="1" width="250"><%=User1%><span style="font-size: 9pt">
          </span>　</TD>
        </TR>
        <TR>
          <TD align=right bgcolor="#FFFFFF" height="1">
          <span style="font-size: 9pt; font-weight: 700">性别<span lang="zh-cn">：</span></span></TD>
          <TD bgcolor="#FFFFFF" height="1" width="227">
			  <%String  sex2="1";
			  if(sex2.equals(sex1))
 {%>
			  <span style="font-size: 9pt">男
			  <%}else{%>女
			  <%}%></span></TD>
        </TR>
        <TR>
          <TD align=right bgcolor="#FFFFFF" height="1">
          <span style="font-size: 9pt; font-weight: 700">密码<span lang="zh-cn">：</span></span></TD>
          <TD bgcolor="#FFFFFF" height="1" width="227"><%=password1%>　</TD>
        </TR>
        <TR>
          <TD align=right bgcolor="#FFFFFF" height="1">
          <span style="font-size: 9pt; font-weight: 700">Email<span lang="zh-cn">：</span></span></TD>
          <TD bgcolor="#FFFFFF" height="1" width="227"><%=Email1%>　</TD></TR>
        <TR>
          <TD align=right bgcolor="#FFFFFF" height="1">
          <span style="font-size: 9pt; font-weight: 700">OICQ<span lang="zh-cn">：</span></span></TD>
          <TD bgcolor="#FFFFFF" height="1" width="227"><%=request.getParameter("OICQ")%>
          </span> </TD>
        </TR>
              <TR>
          <TD align=center colSpan=2 bgcolor="#FFFFFF" height="8" width="325">
          <span style="font-size: 9pt"><a href="user.jsp">会员登陆</a></span></TD>
        </TR>
              <TR>
          <TD align=center colSpan=2 bgcolor="#3399FF" height="50" width="325">
          　</TD>
        </TR>
      </TABLE>
    <br>
  
  </center>
</div>
<%@ include file="CopyRight.jsp"%>

</html>
<%
	}
%>