Guest User

Untitled

a guest
Apr 14th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. Connection myCon = null;
  2. Statement mystmt =null;
  3. ResultSet myRs = null;
  4. try{
  5. String grammar = gname.getText();
  6.  
  7. myCon = DriverManager.getConnection("jdbc:mysql://localhost:3306/grammar","root","");
  8. JOptionPane.showMessageDialog(rootPane, "Connected to database");
  9. mystmt = myCon.createStatement();
  10. String query ="select starting_symbol,nonterminals,terminals from input_values INNER JOIN starting_symbol where input_values.grammar = starting_symbol.grammar='"+grammar+"'";
  11. myRs= mystmt.executeQuery(query);
  12.  
  13. while(myRs.next()){
  14. String s = myRs.getString("start_symbol");
  15. String nonT = myRs.getString("non_terminals");
  16. String t = myRs.getString("terminals");
  17.  
  18. JOptionPane.showMessageDialog(rootPane, s);
  19. }
  20.  
  21. }catch(HeadlessException | SQLException e){
  22. JOptionPane.showMessageDialog(rootPane, "NO Result");
  23. }
Add Comment
Please, Sign In to add comment