<body> <% try{ Connection con=null; Class.forName("org.sqlite.JDBC"); con=DriverManager.getConnection("jdbc:sqlite:C:\\"); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("Select id,name from tb1 group by id"); // Statement stmt2=con.createStatement(); // ResultSet rs2=stmt2.executeQuery("Select id,name from tb1"); %> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script> <script> $(document).ready(function(){ $('#view').click(function(){ var id=$(this).closest('tr').find('td:eq(0)').text(); var name=$(this).closest('tr').find('td:eq(1)').text(); alert(id+" "+name); //$('#vv').slideToggle(); }); }); </script> <form action="" method=""> <table id="tb1" style="text-align: center;border: solid black medium"> <tr> <th>ID</th> <th>NAME</th> <th>View Data</th> </tr> <% while(rs.next()){%> <tr> <td><%= rs.getString(1) %></td> <td><%= rs.getString(2) %></td> <td><input type="radio" name="view" id="view" onclick="" /></td> </tr> <%}%> </table> </form>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)