JSP with SQL database

Hi I'm trying to access my SQL database choose record and then update it. Basicaly I have PROJECT table

Code:

---

TABLE Project (PNAME  varchar(50) not null,

                      DESCR  varchar(50) not null,

                      SKILLS    varchar(50) not null,

                      PRICE number ,                         

                      TYPE        varchar(50) not null)

---

So I wont to be able to choose by TYPE in drop-down menu and then update it's price
so I'm using this code

Code:

---

<select name='PNAME' onchange="showState(this.value)"> 
  <option value="none">Select</option> 
  <%
 Class.forName("org.apache.derby.jdbc.EmbeddedDriver").newInstance();
 Connection con = DriverManager.getConnection("jdbc:derby://localhost:1527/Data"); 
 Statement stmt = con.createStatement(); 
 ResultSet rs = stmt.executeQuery("Select * from PROJECT");
 while(rs.next()){
    %>
 <option value="<%=rs.getString(1)%>"><%=rs.getString(2)%></option> 
 <%
 }
    %>
 </select> 
 <br> 
 <div id='TYPE'> 
 <select name='TYPE' > 
 <option value='-1'></option> 
 </select> 
 </div>

---

and don't know where to go from here
Thanks