import java.sql.*;
import javax.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
public class Database2 extends JFrame implements ActionListener
{
JButton in=new JButton("Inserisci");
JLabel n=new JLabel("Nome");
JTextField nome=new JTextField(5);
JLabel c=new JLabel("Cognome");
JTextField cognome=new JTextField(5);
JLabel t=new JLabel("Telefono");
JTextField telefono=new JTextField(5);
private Connection d;
String a,b,y,x;
public Database2(){
super("Database");
setSize(200,200);
setSize(200,200);
setDefaultCloseOperation(EXIT_ON_CLOSE);
GridLayout g=new GridLayout(4,2);
JPanel pane=new JPanel();
pane.setLayout(g);
pane.add(n);
pane.add(nome);
pane.add(c);
pane.add(cognome);
pane.add(t);
pane.add(in);
pane.add(telefono);
setContentPane(pane);
setVisible(true);
nome.addActionListener(this);
cognome.addActionListener(this);
telefono.addActionListener(this);
in.addActionListener(this);
}
public void connetti(){
try{
Statement stmt = null;
Connection conn=null;
String url = "jdbc:mysql://localhost/rubrica";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
d = DriverManager.getConnection (url, "root", "ciccione");
System.out.println ("Database connection established");
}catch (Exception e){
e.getMessage();
}
}
public static void main (String[] args)
{
Database2 d1=new Database2();
d1.connetti();
//d1.eseguiAggiornamento();
}
public void eseguiAggiornamento() {
String query= "insert into nome values('"+nome.getText()+"','"+cognome.getText()+"',"+telefono.getText()+");";
Statement stmt = null;
int numero = 0;
boolean risultato = false;
try {
stmt = d.createStatement();
numero = stmt.executeUpdate(query);
risultato = true;
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
e.getMessage();
risultato = false;
}
}
public void actionPerformed(ActionEvent e){
Database2 c1=new Database2();
a=nome.getText();
b=cognome.getText();
x=telefono.getText();
Object source=e.getSource();
if(source==in)
c1.eseguiAggiornamento();
}
}