connecting java application to JAVADB database

[aditya vikram singh]

guys this is my project and i am not able to connect with database i am using...JAVA DB....PLEASE help me out ...i am not able to save any data to database or update or delete....if any body is having idea about this error tell me how to fix it..and if any error is there please post me with corrected code...please i need help....thank you guys...i have attched the file naming java code ..

savebtn.addActionListener(new ActionListener() { 

@Override 
public void actionPerformed(ActionEvent ae){ 
String value1=tf1.getText(); 
String value2=tf2.getText(); 
String value3=tf3.getText(); 
String value4=tf4.getText(); 
Connection con = null; 
String url = "jdbc:derby://localhost:1527/SAILS MANAGER"; 
String db = "SAILSMANAGER"; 
String driver = "org.apache.derby.jdbc.ClientDriver"; 
String user = "sailsmanager"; 
String pass = "sails"; 
System.out.println(value1+value2+value3+value4); 
try{ 
Class.forName(driver); 
con = DriverManager.getConnection(url+db, user, pass); 
PreparedStatement st=con.prepareStatement("insert into CUSTOMER(ID,NAME,CUS_ORDER,PRICE" ); 
st.setString(1,value1); 
st.setString(2,value2); 
st.setString(3,value3); 
st.setString(4,value4); 
st.executeUpdate(); 
JOptionPane.showMessageDialog(p1,"Data is successfully inserted into database."); 
con.close(); 
} 
catch(Exception e){ 
JOptionPane.showMessageDialog(p1,"Error in submitting data!"); 
} 
} 
}); 

deletebtn.addActionListener(new ActionListener() { 
@Override 
public void actionPerformed(ActionEvent ae){ 

String value1=tf5.getText(); 
Connection con = null; 
String url = "jdbc:derby://localhost:1527/SAILS MANAGER"; 
String db = "SAILSMANAGER"; 
String driver = "org.apache.derby.jdbc.ClientDriver"; 
String user = "sailsmanager"; 
String pass = "sails"; 
try{ 
Class.forName(driver); 
con = DriverManager.getConnection(url+db, user, pass); 
PreparedStatement st=con.prepareStatement("DELETE FROM CUSTOMER WHERE ID = ?"); 
st.setString(1,value1); 
st.executeUpdate(); 
JOptionPane.showMessageDialog(p3,"Data is deleted successfully."); 
con.close(); 
} 
catch(Exception exp3) 
{ 
JOptionPane.showMessageDialog(p3,"Error in deleting data."); 
} 
} 
}); 
editbtn1.addActionListener(new ActionListener() { 
@Override 
public void actionPerformed(ActionEvent ae){ 

String value=tf7.getText(); 
Connection con = null; 
String url = "jdbc:derby://localhost:1527/SAILS MANAGER"; 
String db = "SAILSMANAGER"; 
String driver = "org.apache.derby.jdbc.ClientDriver"; 
String user = "sailsmanager"; 
String pass = "sails"; 
try{ 
Class.forName(driver); 
con = DriverManager.getConnection(url+db, user, pass); 
PreparedStatement st=con.prepareStatement("select * from CUSTOMER where ID=?"); 
st.setString(1,value); 
ResultSet res=st.executeQuery(); 
res.next(); 
tf7.setText(Integer.toString(res.getInt(1))); 
tf8.setText(res.getString(2)); 
tf9.setText(res.getString(3)); 
tf10.setText(Integer.toString(res.getInt(4))); 
con.close(); 
} 
catch(Exception e) 
{ 
JOptionPane.showMessageDialog(p2,"Can not edit data"); 
} 
} 
}); 
editbtn2.addActionListener(new ActionListener() { 
@Override 
public void actionPerformed(ActionEvent ae){ 
Connection con = null; 
String url = "jdbc:derby://localhost:1527/SAILS MANAGER"; 
String db = "SAILS MANAGER"; 
String driver = "org.apache.derby.jdbc.ClientDriver"; 
String user = "sailsmanager"; 
String pass = "sails"; 
try 
{ 
int x=JOptionPane.showConfirmDialog(p2,"Confirm edit? All data will be replaced"); 
if(x==0){ 
try{ 
String value1=tf7.getText(); 
String value2=tf8.getText(); 
String value3=tf9.getText(); 
String value4=tf10.getText(); 

Class.forName(driver); 
con = DriverManager.getConnection(url+db, user, pass); 
Statement st=con.createStatement(); 
st.executeUpdate("update CUSTOMER set NAME='"+value2+"', CUS_ORDER='"+value3+"',PRICE=('"+value4+"' where ID='"+value1+"'"); 
JOptionPane.showMessageDialog(p2,"Updated successfully"); 
con.close(); 
} 
catch(Exception ex) 
{ 
JOptionPane.showMessageDialog(p2,"Error in updating edit Data"); 
} 
} 
} 
catch(Exception ex) 
{ 
JOptionPane.showMessageDialog(p2,"Error"); 
} 
} 
}); 
} 
void dis() 
{ 
f.getContentPane().add(tp); 
tp.addTab("Add Data",p1); 
tp.addTab("Edit Data",p2); 
tp.addTab("Delete Data",p3); 

f.setSize(600,400); 
f.setVisible(true); 
f.setResizable(true); 
} 
public static void main(String z[]){ 
SailsManager pro=new SailsManager(); 
pro.dis(); 
} 
} 
 
 

[Ashwin Sridhar]

whats the exception that you are getting. post the stack trace.

[aditya vikram singh]

IS THERE ANY ERROR IN WRITING CODE FOR CONNECTING TO JAVA DB..IF THERE PLEASE LET ME KNW THE CORRRECTION..IN

CONNECTION CONN=NULL;/* THERE IS AN YELLOW MARK ITS SHOWING ASSINGNED VALUE NEVER USED...*/

savebtn.addActionListener(new ActionListener() {
                  
                  @Override
public void actionPerformed(ActionEvent ae){
String value1=tf1.getText();
String value2=tf2.getText();
String value3=tf3.getText();
String value4=tf4.getText();
Connection conn = null;
String url = "jdbc:derby://localhost:1527/SAILS MANAGER";
String db = "SAILSMANAGER";
String driver = "org.apache.derby.jdbc.ClientDriver";
String user = "sailsmanager";
String pass = "sails";
System.out.println(value1+value2+value3+value4);
try{
Class.forName(driver);
conn = DriverManager.getConnection(url+db, user, pass);
PreparedStatement st=conn.prepareStatement("insert into CUSTOMER(ID,NAME,CUS_ORDER,PRICE" );
st.setString(1,value1);
st.setString(2,value2);
st.setString(3,value3);
st.setString(4,value4);
st.executeUpdate();
JOptionPane.showMessageDialog(p1,"Data is successfully inserted into database.");
conn.close();
}
catch(Exception e){
JOptionPane.showMessageDialog(p1,"Error in submitting data!");
}
}
});

[Paul Clapham]

You made me open a stupid image just to read a single error message? Don't you have any consideration? Just copy and paste error messages the next time.

As for the so-called error message, it's just telling you that you haven't written any Javadoc for the method. You don't have to write Javadoc for the method. But if those warning messages confuse you, then just write the Javadoc and carry on with your work.

[aditya vikram singh]

WHAT ABOUT DATBASE IS THERE ANY ERROR..IN CODE..ANY WHY THIS CODE IS NOT GETTING CONNECTED TO DATABASE I HAVE GIVEN URL,DRIVER NAME AND ALL....

DO I NEED TO WRITE JAVA DOC..IS IT NECESSARY...??

what does this error says ....

[Rob Spoor]

Please KeepItDown. There's no need to use only uppercase letters.

Your problem from the screen shot is the class name. You think that the class name is "SailsManager", but it's "sails.manager.SailsManager" - the package is part of the class name.

[aditya vikram singh]

but how a class name can be sails.manager.sailsmanger. it can't be there will be no dot-operartor in between..it will be wrong class name...if i give also it will just take sails as my class name not the whole class name as you suggested..please refer to my code is there any problem there beacuse i have tried hell lot things but nothing is working out

[Rob Spoor]

You've put the class in a package called sails.manager; that's where that part of the name comes from.