Advertisement
Guest User

Untitled

a guest
Jul 28th, 2015
209
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. String sql="insert into billingdetail(ID,billingstartdate,billingenddate
  2. ,billingamount,customerid) values('"+ID+"','"+billingstartdate+"','"+billingenddate+"','"
  3. +billingamount+"','"+customerid+"')";
  4.  
  5. Class.forName("com.mysql.jdbc.Driver");
  6. Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydbb"
  7. ,"root","gm@iā€Œā€‹l@123");
  8. Statement st=con.createStatement();
  9. String sql=("SELECT id,name,design,statuss,jobfamilyy,jobtitlee,billablee FROM infoo");
  10. String sql1=("SELECT customerid,customername FROM customerdetail");
  11. ResultSet rs = st.executeQuery(sql);
  12.  
  13. <div style="width:200px; float:left;">
  14. <select name="customerid" onchange="showCustomer1(this.value)">
  15. <option VALUE="blank" SELECTED>Please Select
  16. <% while (rs2.next())
  17. {%> <option VALUE="<%=rs2.getString(1)%>">
  18. <%=rs2.getString(1)%> <%}%>
  19. </select> </div></div>
  20. <% String customerid=request.getParameter("customerid");
  21. ResultSet rs5=st.executeQuery("SELECT customername FROM
  22. customerdetail where customerid="+ customerid +"");
  23. <% while(rs5.next()) { %>
  24. <tr><td><%=rs5.getString(1)%></td></tr>
  25. <%}%>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement