Member Avatar for Prashant_9

see why is is not working

its not taking combo name why

Edited by Prashant_9
  • 1 Contributor
  • 1 Reply
  • 312 Views
  • 2 Minutes Discussion Span
  • Latest Post Latest Post by Prashant_9
Member Avatar for Prashant_9 
<%@page import="java.sql.*"%>
<html>
    <body>



        <select name="combo">        
            <option value="1">railway</option> 
            <option value="2">railway station</option> 

        </select> 


    <tr>                      
        <%
            String name = request.getParameter("combo");

            String sq = "select * from vehicle where ride_add='" + name + "'";

            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/auto", "root", "123456");

            Statement sta = con.createStatement();
            ResultSet ra = sta.executeQuery(sq);
            while (ra.next()) {
        %>                       

        <td><%=ra.getString(1)%></td>
        <td><%=ra.getString(2)%></td>
        <td><%=ra.getString(4)%></td>
        <td><%=ra.getString(5)%></td>


        <%
            }

        %>                       
    </tr>   
</body>




</html>
Edited by Prashant_9
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.