<select>
<%
Connection con=null;
ResultSet rs=null;

try
{
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     con=DriverManager.getConnection("jdbc:odbc:db","root","root");
     HttpSession ss=request.getSession();
     String uid=(String)ss.getAttribute("id");
     PreparedStatement pst=con.prepareStatement("select name from emp where uid=?");
     pst.setString(1,uid);
     rs=pst.executeQuery();
     while(rs.next())
     {
         out.print(rs.getString("name"));
%>
</select>
<%
     }
}catch(Exception e)
{    out.print(e);
}
%>

<select>
<%
Connection con=null;
ResultSet rs=null;

try
{
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     con=DriverManager.getConnection("jdbc:odbc:db","root","root");
     HttpSession ss=request.getSession();
     String uid=(String)ss.getAttribute("id");
     PreparedStatement pst=con.prepareStatement("select name from emp where uid=?");
     pst.setString(1,uid);
     rs=pst.executeQuery();
     while(rs.next())
     {
          String name = rs.getString("name");
%>
          <option value="<%=name%>"><%=name%></option>
<%
     }
}catch(Exception e)
{    out.print(e);
}
%>
</select>

arabaid int,
arabaadi varchar(100),
constraint ck_arabaid primary key (arabaid)

modelid int,
modeladi varchar(100),
arabaid int,
constraint ck_modelid  primary key (modelid),
constraint ck_arabaid  foreign key (arabaid) references araba(arabaid)

<select name="araba" id="araba" onchange="this.form.submit();">
                    <option value="0">Kategori Seç</option>
                    <%@ page import ="java.sql.*" %>
                    <%@ page import ="javax.sql.*" %>
                    <%
                        try
                        {
                            String Query = "Select * From araba";
                            Class.forName("org.postgresql.Driver").newInstance();
                            java.sql.Connection conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/Proje", "postgres", "155");
                            Statement stm = conn.createStatement();
                            ResultSet rs = stm.executeQuery(Query);
                            while(rs.next())
                            {
                                %>
                                    <option value="<%=rs.getInt("arabaid")%>"

                                        <%
                                            if(request.getParameter("araba")!=null)
                                            {
                                                if(rs.getInt("arabaid") == Integer.parseInt(request.getParameter("araba")))
                                                {
                                                    out.print("selected");
                                                }
                                            }
                                        %>

                                    ><%=rs.getString("arabaadi")%></option>
                                <%
                            }
                        }
                        catch(Exception ex)
                        {
                            ex.printStackTrace();
                        }
                    %>
                </select>

<select>
            <option value="0">Model Seç</option>
            <%@ page import ="java.sql.*" %>
            <%@ page import ="javax.sql.*" %>
            <%
                Connection con=null;
                ResultSet rs=null;

                try
                {
                    Class.forName("org.postgresql.Driver");
                     con=DriverManager.getConnection("jdbc:postgresql://localhost:5432/Proje", "postgres", "155");
                     HttpSession ss=request.getSession();
                     String aid=(String)ss.getAttribute("arabaid");
                     PreparedStatement pst=con.prepareStatement("select modeladi from model  where aid=?");
                     pst.setString(1,aid);
                     rs=pst.executeQuery();
                     while(rs.next())
                     {
                        String name = rs.getString("modeladi");
                        %>
                            <option value="<%=name%>"><%=name%></option>
                        <%
                    }
                }catch(Exception e)
                {    out.print(e);
                }
            %>
            </select>