Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void FillCombo(){
- try{
- con = DriverManager.getConnection("jdbc:mysql://localhost:3306/hotel","root","root");
- String sql="Select * from menu where Type='CHINESE'";
- String sql2="Select * from menu where Type='NI'";
- String sql3="Select * from menu where Type='SI'";
- String sql4="Select * from menu where Type='DRINKS'";
- ps=con.prepareStatement(sql);
- ps2=con.prepareStatement(sql2);
- ps3=con.prepareStatement(sql3);
- ps4=con.prepareStatement(sql4);
- rs=ps.executeQuery();
- while(rs.next()){
- String name= rs.getString("ItemName");
- String pp= rs.getString("Price");
- chinese.addItem(name);
- prr.setText(pp);
- }
- rs2=ps2.executeQuery();
- while(rs2.next()){
- String niname= rs2.getString("ItemName");
- String pp2= rs2.getString("Price");
- northindian.addItem(niname);
- prr2.setText(pp2);
- }
- rs3=ps3.executeQuery();
- while(rs3.next()){
- String siname= rs3.getString("ItemName");
- String pp3= rs3.getString("Price");
- southindian.addItem(siname);
- prr3.setText(pp3);
- }
- rs4=ps4.executeQuery();
- while(rs4.next()){
- String drname= rs4.getString("ItemName");
- String pp4= rs4.getString("Price");
- drinks.addItem(drname);
- prr4.setText(pp4);
- }
- }
- catch(Exception e){
- System.out.println(e);
- }
- }
Add Comment
Please, Sign In to add comment