package pr13;
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class pr13 extends [Link] {
Connection conn;
JTable jt = new JTable();
public pr13() {
initComponents();
try{
[Link]("[Link]");
conn = [Link]("jdbc:mysql://localhost:3306/java","root","");
loaddata();
}catch(Exception e){
[Link]("conn error");
}
}
private void loaddata()
{
Statement st = null;
try
{
[Link]([Link]());
int r = 0;
st= (Statement) [Link]();
ResultSet rs = [Link]("Select * from product");
[Link](null);
while([Link]())
{
[Link]([Link](1),r,0);
[Link]([Link](2),r,1);
[Link]([Link](3),r,2);
r++;
}
[Link](null,r,0);
[Link](null,r,1);
[Link](null,r,2);
}
catch(Exception e)
{
[Link]("loaddata Error");
}
}
public void putdata(String query)
{
Statement st = null;
try{
st= (Statement) [Link]();
[Link](query);
}
catch(Exception e)
{
[Link]("putdata error");
}
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jLabel1 = new [Link]();
jLabel2 = new [Link]();
jLabel3 = new [Link]();
jTextField1 = new [Link]();
jTextField2 = new [Link]();
jTextField3 = new [Link]();
jScrollPane1 = new [Link]();
jTable1 = new [Link]();
jButton1 = new [Link]();
jButton2 = new [Link]();
jButton3 = new [Link]();
setDefaultCloseOperation([Link].EXIT_ON_CLOSE);
[Link]("p_ID");
[Link]("P_Name");
[Link]("P_Price");
[Link](new [Link]() {
public void actionPerformed([Link] evt) {
jTextField1ActionPerformed(evt);
}
});
[Link](new [Link](
new Object [][] {
{null, null, null},
{null, null, null},
{null, null, null},
{null, null, null}
},
new String [] {
"P_ID", "P_Name", "P_Price"
}
));
[Link](new [Link]() {
public void mouseClicked([Link] evt) {
jTable1MouseClicked(evt);
}
});
[Link](jTable1);
[Link]("Insert");
[Link](new [Link]() {
public void actionPerformed([Link] evt) {
jButton1ActionPerformed(evt);
}
});
[Link]("Update");
[Link](new [Link]() {
public void actionPerformed([Link] evt) {
jButton2ActionPerformed(evt);
}
});
[Link]("Delete");
[Link](new [Link]() {
public void actionPerformed([Link] evt) {
jButton3ActionPerformed(evt);
}
});
[Link] layout = new [Link](getContentPane());
getContentPane().setLayout(layout);
[Link](
[Link]([Link])
.addGroup([Link]()
.addGroup([Link]([Link])
.addGroup([Link]()
.addGap(42, 42, 42)
.addGroup([Link]([Link], false)
.addGroup([Link], [Link]()
.addGap(0, 5, Short.MAX_VALUE)
.addGroup([Link]([Link])
.addGroup([Link], [Link]()
.addComponent(jLabel3)
.addGap(36, 36, 36))
.addGroup([Link], [Link]()
.addComponent(jButton1)
.addGap(3, 3, 3)))
.addGroup([Link]([Link])
.addGroup([Link]()
.addGap(15, 15, 15)
.addComponent(jButton2)
.addGap(18, 18, 18)
.addComponent(jButton3))
.addComponent(jTextField3, [Link].PREFERRED_SIZE, 191,
[Link].PREFERRED_SIZE)))
.addGroup([Link]()
.addGroup([Link]([Link])
.addComponent(jLabel1)
.addComponent(jLabel2))
.addPreferredGap([Link],
[Link].DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup([Link]([Link])
.addComponent(jTextField2, [Link],
[Link].PREFERRED_SIZE, 191, [Link].PREFERRED_SIZE)
.addComponent(jTextField1, [Link],
[Link].PREFERRED_SIZE, 191, [Link].PREFERRED_SIZE)))))
.addGroup([Link]()
.addContainerGap()
.addComponent(jScrollPane1, [Link].PREFERRED_SIZE, 375,
[Link].PREFERRED_SIZE)))
.addContainerGap([Link].DEFAULT_SIZE, Short.MAX_VALUE))
);
[Link](
[Link]([Link])
.addGroup([Link]()
.addGap(28, 28, 28)
.addGroup([Link]([Link])
.addComponent(jLabel1)
.addComponent(jTextField1, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE))
.addPreferredGap([Link])
.addGroup([Link]([Link])
.addComponent(jLabel2)
.addComponent(jTextField2, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE))
.addPreferredGap([Link])
.addGroup([Link]([Link])
.addComponent(jLabel3)
.addComponent(jTextField3, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE))
.addPreferredGap([Link], 26, Short.MAX_VALUE)
.addGroup([Link]([Link])
.addComponent(jButton3)
.addComponent(jButton2)
.addComponent(jButton1))
.addGap(18, 18, 18)
.addComponent(jScrollPane1, [Link].PREFERRED_SIZE, 241,
[Link].PREFERRED_SIZE))
);
pack();
}// </editor-fold>
private void jTextField1ActionPerformed([Link] evt) {
// TODO add your handling code here:
}
private void jButton1ActionPerformed([Link] evt) {
putdata("insert into
product(product_id,product_name,product_price)values('"+[Link]()+"','"+[Link]()+"','"+jTex
[Link]()+"')");
[Link]("New");
[Link]("");
[Link]("");
[Link]("");
loaddata();
}
private void jButton3ActionPerformed([Link] evt) {
putdata("Delete from product where product_id='"+[Link]()+"'");
[Link]("");
[Link]("");
[Link]("");
loaddata();
}
private void jButton2ActionPerformed([Link] evt) {
// TODO add your handling code here:
putdata("update product set
product_name='"+[Link]()+"',product_price='"+[Link]()+"where
product_id='"+[Link]()+"'");
loaddata();
}
private void jTable1MouseClicked([Link] evt) {
// TODO add your handling code here:
[Link]([Link]([Link](),[Link]()) +"Grid Clicked");
[Link]([Link]([Link](),0).toString());
[Link]([Link]([Link](),1).toString());
[Link]([Link]([Link](),2).toString());
}
[Link](new Runnable() {
public void run() {
new pr13().setVisible(true);
}
});
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
try {
for ([Link] info : [Link]()) {
if ("Nimbus".equals([Link]())) {
[Link]([Link]());
break;
}
}
} catch (ClassNotFoundException ex) {
[Link]([Link]()).log([Link], null, ex);
} catch (InstantiationException ex) {
[Link]([Link]()).log([Link], null, ex);
} catch (IllegalAccessException ex) {
[Link]([Link]()).log([Link], null, ex);
} catch ([Link] ex) {
[Link]([Link]()).log([Link], null, ex);
}
//</editor-fold>
/* Create and display the form */
[Link](new Runnable() {
public void run() {
new pr13().setVisible(true);
}
});
}
// Variables declaration - do not modify
private [Link] jButton1;
private [Link] jButton2;
private [Link] jButton3;
private [Link] jLabel1;
private [Link] jLabel2;
private [Link] jLabel3;
private [Link] jScrollPane1;
private [Link] jTable1;
private [Link] jTextField1;
private [Link] jTextField2;
private [Link] jTextField3;
// End of variables declaration
}
OutPut:-