Advertisement
Guest User

Untitled

a guest
Nov 21st, 2018
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.40 KB | None | 0 0
  1. ------------------------------testJDBC3.java-----------------------------
  2. package pak;
  3.  
  4. import java.sql.*;
  5. import java.sql.Statement;
  6.  
  7.  
  8. public class testJDBC3 {
  9. public static void main(String[]args) throws SQLException, InstantiationException,
  10. IllegalAccessException, ClassNotFoundException{
  11. String url = "jdbc:mysql://localhost:3306/test";
  12. Statement sql;
  13. ResultSet rs;
  14. Class.forName ("com.mysql.jdbc.Driver").newInstance ();
  15. Connection con = DriverManager.getConnection (url, "root", "root");
  16. sql = (Statement) con.createStatement();
  17. rs = sql.executeQuery("select * from Persoana");
  18.  
  19. while (rs.next())
  20. System.out.println("id="+rs.getInt("Id")+", nume= " + rs.getString("nume")+ ",varsta="+rs.getInt(3));
  21.  
  22. con.close();
  23. sql.close();
  24. rs.close();
  25.  
  26. Interfata frm=new Interfata();
  27. frm.setVisible(true);
  28. }
  29. }
  30. -----------------------------Interfata-------------------------------------------
  31.  
  32. package pak;
  33.  
  34. import java.awt.*;
  35. import javax.swing.*;
  36. class Interfata extends JFrame{
  37. public Interfata(){
  38. super("JMeniu");
  39. setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  40. setSize(300, 300);
  41. getContentPane().setLayout(new BorderLayout());
  42. JToolBar myBar=new JToolBar();
  43. getContentPane().add(myBar,BorderLayout.NORTH);
  44. JButton btnFirst=new JButton();
  45. JButton btnPrevious=new JButton();
  46. JButton btnNext=new JButton();
  47. JButton btnLast=new JButton();
  48. JButton btnAdd=new JButton();
  49. JButton btnEdit=new JButton();
  50. JButton btnDelete=new JButton();
  51. JButton btnFind=new JButton();
  52. JButton btnSave=new JButton();
  53. JButton btnUndo=new JButton();
  54. JTextField txtAfis=new JTextField();
  55. btnFirst.setIcon(new ImageIcon("MoveFirst.png"));
  56. btnPrevious.setIcon(new ImageIcon("MovePrevious.png"));
  57. btnNext.setIcon(new ImageIcon("MoveNext.png"));
  58. btnLast.setIcon(new ImageIcon("MoveLast.png"));
  59. btnAdd.setIcon(new ImageIcon("Add.png"));
  60. btnEdit.setIcon(new ImageIcon("Edit.png"));
  61. btnDelete.setIcon(new ImageIcon("Delete.png"));
  62. btnFind.setIcon(new ImageIcon("Find.jpg"));
  63. btnSave.setIcon(new ImageIcon("Save.jpg"));
  64. btnUndo.setIcon(new ImageIcon("Undo.jpg"));
  65. myBar.add(btnFirst);
  66. myBar.add(btnPrevious);
  67. myBar.add(txtAfis);
  68. myBar.add(btnNext);
  69. myBar.add(btnLast);
  70. myBar.add(btnAdd);
  71. myBar.add(btnEdit);
  72. myBar.add(btnDelete);
  73. myBar.add(btnFind);
  74. myBar.add(btnSave);
  75. myBar.add(btnUndo);
  76. }
  77. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement