//Customer Name:

<select name="name">
 <% 
 try{
 Class.forName("com.mysql.jdbc.Driver");
 Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/scs","root","root");
 Statement st=con.createStatement();
 String sql="select * from staff";
 ResultSet rs=st.executeQuery(sql);
 while(rs.next()){
 //String name = rs.getString("name");
   }    %>    <option value="<%=rs.getString("fname")%>"></option>

   <%
  }catch(Exception e){
  }     
 %>
 </select>

Ads