Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Retrieve data from database and display it dynamically in the rows of the table using textboxes
- <table>
- <tr>
- <td>
- <select name="choice_type">
- <option>select</option>
- <option value="part_type">part_type</option>
- <option value="category">category</option>
- <option value="names">names</option>
- </select>
- </td>
- </tr>
- <tr>
- <th>VAL</th>
- <th>VAL DESC</th>
- </tr>
- <tr>
- <td> <input type="text" name="val" id="val" size="15" /></td>
- <td> <input type="text" name="val_desc" id="val_desc" size="15" /></td>
- </tr>
- </table>
- <input type="submit" name="Query" value="Query" onClick="getData();"/>
- function getData(){
- xmlHttp=GetXmlHttpObject()
- var id=document.getElementById("choice_type").value;
- var url="choice_retrieval.jsp";//The code for this file is defined below
- url=url+"?choice_type="+id;
- xmlHttp.onreadystatechange=stateChanged
- xmlHttp.open("GET",url,true)
- xmlHttp.send(null);
- }
- function stateChanged(){
- if(xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){
- var showdata = xmlHttp.responseText;
- var strar = showdata.split(":");
- if(strar.length>1){
- var strname = strar[1];
- document.getElementById("val").value= strar[1];
- document.getElementById("val_desc").value= strar[2];
- }
- }
- <%
- String ch = request.getParameter("choice_type").toString();
- System.out.println(ch);
- String data ="";
- try{
- Class.forName("com.mysql.jdbc.Driver");
- Connection con = DriverManager.getConnection("jdbc:mysql://", "", "");
- Statement st=con.createStatement();
- ResultSet rs=st.executeQuery("select * from master_panel where choice_type='"+ch+"'");
- while(rs.next())
- {
- data = ":" + rs.getString("val") + ": " + rs.getString("val_desc");
- }
- out.println(data);
- System.out.println(data);
- }
- catch(Exception e) {
- System.out.println(e);
- }
- %>
- var table = document.getElementById('tableId');
- var data = xmlHttp.responseText.split(":");
- for (int i = 0; i < data.length; i + 2)
- {
- var valueText = document.createElement('input');
- valueText.type = 'text';
- valueText.name = 'value' + i;
- valueText.value = data[i];
- var valueCell = document.createElement('td');
- valueCell.appendChild(valueText);
- var descriptionText = document.createElement('input');
- descriptionText.type = 'text';
- descriptionText.name = 'value' + i;
- descriptionText.value = data[i + 1];
- var descriptionCell = document.createElement('td');
- descriptionCell.appendChild(descriptionText);
- var tableRow = document.createElement('tr');
- tableRow.appendChild(valueCell);
- tableRow.appendChild(descriptionCell);
- table.tBodies[0].appendChild(tableRow);
- }
Add Comment
Please, Sign In to add comment