
hi every Java Master or Java Professional , my Name Is Vincent i'm java beginner can i ask a question regarding for Java application convert to Java Applet. below her is my sample application hope every master or professional can teaching me thank you.
import javax.swing.*; import java.awt.*; import java.awt.event.*; import java.sql.*;
public class AddressBook extends JFrame implements ActionListener{ public void frame(){ AddressBook panel = new AddressBook(); panel.setSize(320,350); panel.setVisible(true); panel.setResizable(false); panel.setLocation(320,200);
}
JLabel lblId = new JLabel("ID Number : ",JLabel.RIGHT);
JLabel lblFName = new JLabel("First Name : ",JLabel.RIGHT);
JLabel lblAddress = new JLabel("Address : ",JLabel.RIGHT);
JLabel lblLName = new JLabel("Last Name : ",JLabel.RIGHT);
JLabel lblPNumber = new JLabel("Phone : ",JLabel.RIGHT);
JTextField txtId = new JTextField(20);
JTextField txtFName= new JTextField(20);
JTextField txtAddress= new JTextField(20);
JTextField txtLName = new JTextField(20);
JTextField txtPNumber = new JTextField(20);
JButton btnNew = new JButton(new ImageIcon("news.jpg"));
JButton btnUpdate = new JButton(new ImageIcon("update.jpg"));
JButton btnDelete = new JButton(new ImageIcon("delete.jpg"));
JButton btnSearch = new JButton(new ImageIcon("search.jpg"));
Connection cn;
Statement st;
PreparedStatement ps;
public void clear(){
txtId.setText("");
txtFName.setText("");
txtAddress.setText("");
txtLName.setText("");
txtPNumber.setText("");
}
public AddressBook() {
super("MY Electronic Address Book Application ");
JPanel pane = new JPanel();
pane.setLayout(null);
pane.setBackground(Color.pink);
lblId.setBounds(5,50,80,25);
pane.add(lblId);
txtId.setBounds(90,50,150,25);
pane.add(txtId);
lblFName.setBounds(5,85,80,25);
pane.add(lblFName);
txtFName.setBounds(90,85,150,25);
pane.add(txtFName);
lblLName.setBounds(5,120,80,25);
pane.add(lblLName);
txtLName.setBounds(90,120,150,25);
pane.add(txtLName);
lblPNumber.setBounds(5,155,80,25);
pane.add(lblPNumber);
txtPNumber.setBounds(90,155,150,25);
pane.add(txtPNumber);
lblAddress.setBounds(5,190,80,25);
pane.add(lblAddress);
txtAddress.setBounds(90,190,150,25);
pane.add(txtAddress);
btnNew.addActionListener(this);
btnNew.setBounds(5,255,75,35);
btnNew.setBackground(Color.white);
pane.add(btnNew);
btnNew.addActionListener(this);
btnUpdate.setBounds(80,255,75,35);
btnUpdate.setBackground(Color.white);
pane.add(btnUpdate);
btnUpdate.addActionListener(this);
btnDelete.setBounds(155,255,75,35);
btnDelete.setBackground(Color.white);
pane.add(btnDelete);
btnDelete.addActionListener(this);
btnSearch.setBounds(230,255,75,35);
btnSearch.setBackground(Color.white);
pane.add(btnSearch);
btnSearch.addActionListener(this);
setContentPane(pane);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
pane.setBorder(BorderFactory.createTitledBorder(
BorderFactory.createEtchedBorder(), " Personal Information"));
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
cn = DriverManager.getConnection("jdbc:odbc:AddressBook ");
}catch(ClassNotFoundException e) {
System.err.println("Failed to load driver");
e.printStackTrace();
}catch(SQLException e){
System.err.println("Unable to connect");
e.printStackTrace();}
}
public void actionPerformed(ActionEvent e){
Object source = e.getSource();
if(source == btnNew){
try{
st= cn.createStatement();
ps=cn.prepareStatement("INSERT INTO PInfo " + " (IDN,FName,LName,PNumber,Address) " + " VALUES(?,?,?,?,?)");
ps.setString(1,txtId.getText());
ps.setString(2,txtFName.getText());
ps.setString(3,txtLName.getText());
ps.setString(4,txtPNumber.getText());
ps.setString(5,txtAddress.getText());
ps.executeUpdate();
JOptionPane.showMessageDialog(null,"New record has been successfully added.","Suspect sample program",JOptionPane.INFORMATION_MESSAGE);
txtId.requestFocus(true);
st.close();
clear();
}catch(SQLException sqlEx){
System.out.println(sqlEx.getMessage());}}
if(source == btnSearch){
try{
st= cn.createStatement();
int id=0;
String search;
clear();
search=JOptionPane.showInputDialog(null,"Search Id Number","Find What?",JOptionPane.PLAIN_MESSAGE);
ResultSet rs=st.executeQuery("SELECT * FROM PInfo WHERE IDN = '" + search + "'");
while(rs.next()){
txtId.setText(rs.getString(1));
txtFName.setText(rs.getString(2));
txtLName.setText(rs.getString(3));
txtPNumber.setText(rs.getString(4));
txtAddress.setText(rs.getString(5));
id=Integer.parseInt(rs.getString(1));
}
if(id==0){
JOptionPane.showMessageDialog(null,"No record found!.","Suspect sample program",JOptionPane.ERROR_MESSAGE);
clear();
txtId.requestFocus(true);
}st.close();
}catch(SQLException s){}}
if(source == btnUpdate){
try{
st= cn.createStatement();
ps = cn.prepareStatement("UPDATE PInfo SET IDN = '" + txtId.getText() + "',FName = '" + txtFName.getText() + "',LName = '" + txtLName.getText() + "',PNumber = '" + txtPNumber.getText() + "',Address = '"+ txtAddress.getText() + "'WHERE IDN = '" + txtId.getText() + "'");
ps.executeUpdate();
JOptionPane.showMessageDialog(null,"record has been successfully updated.","Suspect sample program",JOptionPane.INFORMATION_MESSAGE);
txtId.requestFocus(true);
clear();
st.close();
}catch (Exception y){
y.printStackTrace();}}
if(source==btnDelete){
try{
ps = cn.prepareStatement("DELETE FROM PInfo WHERE IDN ='"+ txtId.getText() + "'");
ps.executeUpdate();
JOptionPane.showMessageDialog(null,"record has been successfully deleted.","Suspect sample program",JOptionPane.INFORMATION_MESSAGE);
txtId.requestFocus(true);
clear();
st.close();
}catch(SQLException s){
System.out.print("SQL statement is not executed!");}
catch(Exception j){
j.printStackTrace();
}
}
}
public static void main(String[] args) { AddressBook s1=new AddressBook(); s1.setSize(320,350); s1.setLocation(320,200); s1.setResizable(true); s1.setVisible(true); }
}
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.