title: how to insert the data as string and data base should accept as a number
body: <p>I have table named as 'lecturer' and the fields are</p>
  
  <pre><code>Id    Name 
  -----------
   1     abcd
   2     efgh      
   3     ijkl
  -----------
  </code></pre>
  
  <p>where the 'Id' is primary key</p>
  
  <p>I have onother table named as student and fields are</p>
  
  <ul>
  <li>stdId</li>
  <li>name</li>
  <li>dateOfBirth</li>
  <li>dateOfJoining</li>
  <li>lecturerId</li>
  </ul>
  
  <p>where <code>lecturerId</code> is foreign key</p>
  
  <p>Now I want to insert the data in fields as </p>
  
  <pre><code>5101
  ----------
  xyz
  ----------  
  10/12/1995
  ----------
  12/10/2011
  ---------- 
  abcd
  ----------
  </code></pre>
  
  <p>But the data of last column should enter in table "student" as '1' where I'm giving as 'abcd'</p>
  
  <p>My DAOImpl code is</p>
  
  <p>please help me for writing a query .as beginner I'm unable to understand how to write query.. I'm waiting for your responses ... </p>
  
  <p>Thanks in advance</p>