Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ------------------------------testJDBC3.java-----------------------------
- package pak;
- import java.sql.*;
- import java.sql.Statement;
- public class testJDBC3 {
- public static void main(String[]args) throws SQLException, InstantiationException,
- IllegalAccessException, ClassNotFoundException{
- String url = "jdbc:mysql://localhost:3306/test";
- Statement sql;
- ResultSet rs;
- Class.forName ("com.mysql.jdbc.Driver").newInstance ();
- Connection con = DriverManager.getConnection (url, "root", "root");
- sql = (Statement) con.createStatement();
- rs = sql.executeQuery("select * from Persoana");
- while (rs.next())
- System.out.println("id="+rs.getInt("Id")+", nume= " + rs.getString("nume")+ ",varsta="+rs.getInt(3));
- con.close();
- sql.close();
- rs.close();
- Interfata frm=new Interfata();
- frm.setVisible(true);
- }
- }
- -----------------------------Interfata-------------------------------------------
- package pak;
- import java.awt.*;
- import javax.swing.*;
- class Interfata extends JFrame{
- public Interfata(){
- super("JMeniu");
- setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
- setSize(300, 300);
- getContentPane().setLayout(new BorderLayout());
- JToolBar myBar=new JToolBar();
- getContentPane().add(myBar,BorderLayout.NORTH);
- JButton btnFirst=new JButton();
- JButton btnPrevious=new JButton();
- JButton btnNext=new JButton();
- JButton btnLast=new JButton();
- JButton btnAdd=new JButton();
- JButton btnEdit=new JButton();
- JButton btnDelete=new JButton();
- JButton btnFind=new JButton();
- JButton btnSave=new JButton();
- JButton btnUndo=new JButton();
- JTextField txtAfis=new JTextField();
- btnFirst.setIcon(new ImageIcon("MoveFirst.png"));
- btnPrevious.setIcon(new ImageIcon("MovePrevious.png"));
- btnNext.setIcon(new ImageIcon("MoveNext.png"));
- btnLast.setIcon(new ImageIcon("MoveLast.png"));
- btnAdd.setIcon(new ImageIcon("Add.png"));
- btnEdit.setIcon(new ImageIcon("Edit.png"));
- btnDelete.setIcon(new ImageIcon("Delete.png"));
- btnFind.setIcon(new ImageIcon("Find.jpg"));
- btnSave.setIcon(new ImageIcon("Save.jpg"));
- btnUndo.setIcon(new ImageIcon("Undo.jpg"));
- myBar.add(btnFirst);
- myBar.add(btnPrevious);
- myBar.add(txtAfis);
- myBar.add(btnNext);
- myBar.add(btnLast);
- myBar.add(btnAdd);
- myBar.add(btnEdit);
- myBar.add(btnDelete);
- myBar.add(btnFind);
- myBar.add(btnSave);
- myBar.add(btnUndo);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement