في حاله الريجستر كيف يمكن ان نتاكد انه number-id غير متكرر

السلام عليكم ورحمة الله وبركاته

في حاله الريجستر كيف يمكن ان نتاكد انه number-id غير متكرر ( اي كل شخص له number-id حتى لا يصبح id هناك استخدم له متكرر )

انا عملت الريجستر الى المستخدم واريد عندما يعمل المستخدم تسجيل اذا كان number-id متكرر فانه سوف يرجع الى حالة صفحة الرجستر مرة اخرى

اما اذا كان number-id غير متكرر فانه سوف يدخل بيانات المستخدم الجديد ويطبع كلمة true

انا برمجه الفكرة ويعمل بصورة صحيحة ولكن عندما يسجل المستخدم الجديد البرنامج يجيك فقط اول number-id ويترك number-id الاخرى

اي عندما يكون number -id هو يشبه اول id سوف يتنقذ البرنامج بصورة صحيحة

اما اذا number-id يشبة ثاني او اي number-id اخر فانه البرنامج لايطبق بصورة صحيحة ويشير الى انه توجد مشكلة في برمجة الصفحة aa.jsp

فارجو من اخوتي الكرام انه يدعموني بالتوجيه الله يبارك فيكم وهذه البرمجة

قاعدة البيانات

DROP TABLE IF EXISTS `mahmood`.`students`;
CREATE TABLE  `mahmood`.`students` (
  `userid` varchar(75) collate utf8_unicode_ci NOT NULL,
  `password` varchar(75) collate utf8_unicode_ci default NULL,
  `fname` varchar(75) collate utf8_unicode_ci default NULL,
  `lname` varchar(75) collate utf8_unicode_ci default NULL,
  `email` varchar(75) collate utf8_unicode_ci default NULL,
  `college dep.` varchar(75) collate utf8_unicode_ci default NULL,
  `stage study` varchar(75) collate utf8_unicode_ci default NULL,
  `country name` varchar(75) collate utf8_unicode_ci default NULL,
  `city name` varchar(75) collate utf8_unicode_ci default NULL,
  `number-id` varchar(75) collate utf8_unicode_ci NOT NULL,
  `mobile no.` bigint(20) default NULL,
  PRIMARY KEY  (`number-id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

الواجه a.jsp

<%--
    Document   : registerstudent
    Created on : Jan 10, 2010, 7:12:11 PM
    Author     : Mahmood2010
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">



<head>

  <title>Student Registration Information</title>
  <link href="css/style.css" rel="stylesheet" type="text/css"/>

</head>

<body>

 <!-- blue line -->
<table width="240" height="5" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td  bgcolor="#0066CC"  align="center" width="120" height="5" valign="top"></td>
<td  bgcolor="#0066CC"  align="center" width="120" height="5" valign="top"></td>
</tr>
</table>

<!-- green line -->
<table width="240" height="5" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td  bgcolor="#99CC33"  align="center" width="120" height="10" valign="top"></td>
<td  bgcolor="#99CC33"  align="center" width="120" height="10" valign="top"></td>
</tr>
</table>

<!-- the images logo and tage -->
<table width="240" height="5" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
 <td width="240" height="150" align="center"><img src="image/registerstudent.gif" width="240" height="150" align="center"/></td>
</tr>

 <!--  Mnew bar  -->
<table background="image/menu-bg.gif" class="bgx" align="center" cellpadding="0" cellspacing="0" width="240" border="0">

<tr>
 <td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"/></td>
<td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"/></td>
<td align="center"><img src="image/menu-sep.gif" width="6" height="27" alt=""/></td>
<td align="center"><a href="index.jsp" ><font color="#FFFFFF" size="1">Home Page</font></a></td>
<td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"/></td>
<td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"/></td>
<td align="center"><img src="image/menu-sep.gif" width="6" height="27" alt=""/></td>
<td align="center"><a href="register.jsp"><font color="#FFFFFF" size="1">Back</font></a></td>
<td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"/></td>
<td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"/></td>
<td align="center"><img src="image/menu-sep.gif" width="6" height="27" alt=""/></td>
</tr>
</table>

 <!-- green line -->
<table width="240" border="0" cellpadding="0" cellspacing="0" align="center"  bgcolor="#66CC33">

<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>
 </table>

<!-- the types of registration pages -->

<table width="240" border="0" cellpadding="0" cellspacing="0" align="center"  bgcolor="#66CC33">

<!-- select -->
<tr>
<td width="240" height="20" align="left"><font color="#0000FF" size="1" face="Arial">Plase register your user name account & password to use them in the following :-</font></a></td>
</tr>

</table>

 <!-- green line -->
<table width="240" border="0" cellpadding="0" cellspacing="0" align="center"  bgcolor="#66CC33">

<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>
 </table>



 <form action="aa.jsp" method="post">

 <!-- first part of information -->
<!-- student user name and password-->

<table width="240" border="0" cellpadding="0" cellspacing="0" align="center" bgcolor="#66CC33">


   <tr>
   <td  align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">UserName</font></td>
   <td  align="left" width="150"><input align="left" size="8" maxlength="100" type="text" name="userid" /></td>
   </tr>

<tr>
<td  bgcolor="#66CC33"  align="center" height="7"></td>
</tr>

    <tr>
   <td  align="center" valign="baseline" width="90"><font color="#000000" face="Arial" size="1">Password</font></td>
   <td  align="left" width="150"><input align="left" size="8" maxlength="100" type="password" name="pwd" /></td>
   </tr>

  <!-- green line -->

 <tr>
<td  bgcolor="#66CC33"  align="center" width="90" height="7" valign="top"></td>
<td  bgcolor="#66CC33"  align="center" width="150" height="7" valign="top"></td>
</tr>

<!-- second part of information -->

<tr>
<td width="240" height="20" align="left"><font color="#0000FF" size="1" face="Arial">Insert your information :-
</font>
</td>
</tr>

<!-- green line -->
<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>

<!-- personality information  -->
<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">First Name</font></td>
<td  align="left" width="150"><input align="left" size="8" maxlength="100" type="text" name="fname" /></td>
</tr>

<tr>
<td  bgcolor="#66CC33"  align="center" height="7"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="80"><font color="#000000" size="1" face="Arial">Last Name  </font></td>
<td  align="left" width="160"><input align="left" size="8" maxlength="100" type="text" name="lname" /></td>
</tr>

 <tr>
<td  bgcolor="#66CC33"  align="center" height="7"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="80"><font color="#000000" size="1" face="Arial">E-mail</font></td>
<td  align="left" width="160"><input align="left" size="8" maxlength="100" type="text" name="email" /></td>
</tr>

 <!-- green line -->
<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">The College Department Name </font></td>
<td  align="left" width="150">
<select name="cdepart">
 <option  value="IT">I&C</option>
 <option  value="NETWORK">Network</option>
 <option  value="INTERNET">Internet</option>
</select>
</td>
</tr>


 <!-- green line -->
<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">The Stage Of Study </font></td>
<td  align="left" width="150">
<select name="sstudy">
 <option  value="First">First</option>
 <option  value="Second">Second</option>
 <option  value="Third">Third</option>
 <option  value="Fourth">Fourth</option>
 <option  value="Master">Master</option>
</select>
</td>
</tr>

<tr>
<td  bgcolor="#66CC33"  align="center" height="7"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">The Country Name </font></td>
<td  align="left" width="150">
 <select name="ncountry">
<option  value="Albania">Albania</option>
<option  value="Argntina">Argntina</option>
<option  value="Australia">Australia</option>
<option  value="Bahrain">Bahrain</option>
<option  value="Brazil">Brazil</option>
<option  value="Bulgaria">Bulgaria</option>
<option  value="Canada">Canada</option>
<option  value="China">China</option>
<option  value="Cuba">Cuba</option>
<option  value="Denmark">Denmark</option>
<option  value="D.P.R.Korea">Korea</option>
<option  value="Ecuador">Ecuador</option>
<option  value="Egypt">Egypt</option>
<option  value="Finland">Finland</option>
<option  value="Franca">Franca</option>
<option  value="Germany">Germany</option>
<option  value="Guinea">Guinea</option>
<option  value="Guyana">Guyana</option>
<option  value="Hungary">Hungary</option>
<option  value="Iceland">Iceland</option>
<option  value="India">India</option>
<option  value="Iran">Iran</option>
<option  value="Iraq">Iraq</option>
<option  value="Italy">Italy</option>
<option  value="Japan">Japan</option>
<option  value="Jordan">Jordan</option>
<option  value="Kenya">Kenya</option>
<option  value="Kuwait">Kuwait</option>
<option  value="Lebanon">Lebanon</option>
<option  value="U.S.A">U.S.A</option>
<option  value="other">other</option>
</select>
</td>
</tr>

 <!-- green line -->

<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">The City Name </font></td>
<td  align="left" width="150"><input align="left" size="5" maxlength="100" type="text" name="ncity" /></td>
</tr>

<tr>
<td  bgcolor="#66CC33"  align="center" height="7"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">Number Of ID </font></td>
<td  align="left" width="150"><input align="left" size="5" maxlength="100" type="text" name="nid" id="id" /></td>
</tr>

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">Mobile Number </font></td>
<td  align="left" width="150"><input align="left" size="5" maxlength="100" type="text" name="nmobile" /></td>
</tr>

 <!-- green line -->

<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>

<tr>
<td  align="center"><input align="center" size="5" maxlength="100" type="submit" value="Submit" /></td>
<td  align="center"><input align="center" size="5" maxlength="100" type="reset" value="Reset" /></td>
</tr>



</table>


 </form>


 <!-- green line -->
<table width="240" border="0" cellpadding="0" cellspacing="0" align="center"  bgcolor="#66CC33">

<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="3" valign="top"></td>
</tr>
 </table>



<!-- The footer of the home page -->

<table width="240" border="0" cellspacing="0" cellpadding="0" bgcolor="#3399CC" align="center">
<tr>

<td><img src="image/b-bg.gif" alt="" width="1" height="62"/></td>
<td width="100"><font face="Arial" color="#FFFFFF" size="1">College of Information Engineering</font><br><font face="Arial" color="#FFFFFF" size="1">
Phone: 7763124</font><br><font face="Arial" color="#FFFFFF" size="1">
E-mail: Information Engineering@yahoo.com</font><br></td>


<td width="140" valign="middle" align="center"><a href="index.jsp" >

<STYLE TYPE="text/css">
A { text-decoration: none; }
A:link { color: #000000; }
A:visited { color: #000000; }
</STYLE>

<font face="Arial" color="#FFFFFF" size="1">Home Page</font></a> || <a href="register.jsp"><font face="Arial" color="#FFFFFF" size="1">Back</font></a></td>


</tr>
</table>



</body>

</html>

برمجة aa.jsp

<%--
    Document   : reg student
    Created on : 29/12/2009, 07:51:01 م
    Author     : Mahmood80
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>reg student</title>
    </head>
    <body>
<%@ page import ="java.sql.*" %>
<%@ page import ="javax.sql.*" %>
<%
ResultSet rs=null;
Statement st = null;
String user=request.getParameter("userid");
session.putValue("userid",user);
String pwd=request.getParameter("pwd");
String fname=request.getParameter("fname");
String lname=request.getParameter("lname");
String email=request.getParameter("email");
String cdepart=request.getParameter("cdepart");
String sstudy=request.getParameter("sstudy");
String ncountry=request.getParameter("ncountry");
String ncity=request.getParameter("ncity");
String nid=request.getParameter("nid");
String nmobile=request.getParameter("nmobile");
Class.forName("com.mysql.jdbc.Driver");
java.sql.Connection con = DriverManager.getConnection("jdbc:mysql://localhost/mahmood","root","password");
st= con.createStatement();
rs=st.executeQuery("select * from students");
if(rs.next())
{
if(rs.getString(10).equals(nid))
{
response.sendRedirect("a.jsp");
}
else
{
Class.forName("com.mysql.jdbc.Driver");
java.sql.Connection con1 = DriverManager.getConnection("jdbc:mysql://localhost/mahmood","root","password");
Statement st1= con1.createStatement();
st1.executeUpdate("insert into students values ('"+user+"','"+pwd+"','"+fname+"','"+lname+"','"+email+"','"+cdepart+"','"+sstudy+"','"+ncountry+"','"+ncity+"','"+nid+"','"+nmobile+"')");
out.println("true");
}
}
else
%>

    </body>
</html>

اخوتي الله يبارك لكم وجهوني لماذا هذا الخل

سلامي

اخوكم

محمود سامي