Lesson 6 (Cont)

1. Insert

String sql = "insert into Product (ID, Name, Price, Amount) values (?, ?, ?, ?)";

try{

st = c.prepareStatement(sql);

st.setString(1, t1.getText());

st.setString(2, t2.getText());

st.setString(3, t3.getText());

st.setString(4, t4.getText());

st.execute();

JOptionPane.showMessageDialog(null, "Save");

}

catch(Exception e){}

2. Search

try{

String sql = "select * from product where ID = '"+t1.getText()+"' ";

st = c.prepareStatement(sql);

rs = st.executeQuery();

if(rs.next()){

t2.setText(rs.getString("Name"));

t3.setText(rs.getString("Price"));

t4.setText(rs.getString("Amount"));

}

}

catch(Exception e){}

3. Delete

try{

String sql = "delete from product where ID = '"+t1.getText()+"' ";

st = c.prepareStatement(sql);

st.execute();

JOptionPane.showMessageDialog(null, "Delete");

t1.setText(" ");

t2.setText(null);

t3.setText(" ");

t4.setText(null);

}

catch(Exception e){JOptionPane.showMessageDialog(null, "Not Delete");}

4. Update

try{

String sql = "update product set ID =?, Name =?, Price=?, Amount =? where ID = '"+t1.getText()+"' ";

st = c.prepareStatement(sql);

st.setString(1, t1.getText());

st.setString(2, t2.getText());

st.setString(3, t3.getText());

st.setString(4, t4.getText());

st.executeUpdate();

JOptionPane.showMessageDialog(null, "Update");

}

catch(Exception e){ JOptionPane.showMessageDialog(null, "Not Update");

}

Connection c;

PreparedStatement st;

ResultSet rs;