Update data into database using java swings
--------------------------------------------------------------------import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
class SwingUpdate extends JFrame implements ActionListener
{
JTextField t1,t2;
JButton b1,b2;
SwingUpdate()
{
setVisible(true);
setSize(550, 450);
t1=new JTextField();
add(t1);
t1.setBounds(20,30,70,30);
t2=new JTextField();
add(t2);
t2.setBounds(90,30,70,30);
b1=new JButton("Update");
add(b1);
b1.setBounds(20,60,90,30);
b1.addActionListener(this);
setLayout(null);
}
public void actionPerformed(ActionEvent e)
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","krishna");
PreparedStatement st = con.prepareStatement("update Student124 set name=? where course=?");
st.setString(1, t1.getText());
st.setString(2, t2.getText());
if(!st.execute())
{
JOptionPane.showMessageDialog(b1, "success");
}
else
{
System.out.println("Failure!");
}
}
catch(Exception ex)
{
}
}
public static void main(String[] args) throws Exception
{
new SwingUpdate();
}
}
0 Comments