Aneresia White

sql date

So this is the error:

but the syntax is ok I already verify it in sql. if I put (Date) instead of (String) I don't get any errors but the update is not working when I look in the database.

16 years ago

sql date

I want to get the day, month and year from combo boxes and making an update in my database after this date. I tried something like this:

can is the combo box for year, czi for day and cluna for month.
It doesn't work like this, I receive an error. I think it should be something else instead of (String).

16 years ago

how to set text in textarea if I don't find something in my database?

ok problem solved.
Thank you.

private void jComboBox1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
if(jComboBox1.getSelectedItem().equals("Cod Carte"))
{
try {
Class.forName("org.apache.derby.jdbc.ClientDriver");
Connection con = (Connection) DriverManager.getConnection("jdbc :mrgreen: erby://localhost:1527/Proiect","aneresia","aneresia");
//int rowNumber=jTable1.getSelectedRow()+1; //
// Statement stmt1 = con.createStatement();
con.setAutoCommit(false);
// int rowsUpdated;
Statement stmt1 = (Statement) con.createStatement();
ResultSet rs = (ResultSet) stmt1.executeQuery("Select cod_carte,nume_autor,pren_autor,nume_carte," +
"nr_car_stoc,editura,an_aparitie,pret_v from CARTI where cod_carte= "+jTextField9.getText());
ResultSetMetaData rsmd = (ResultSetMetaData) rs.getMetaData();
model1.setNumRows(0);
model1.setColumnCount(0);
for (int col = 1; col <= rsmd.getColumnCount(); col++) {
model1.addColumn(rsmd.getColumnLabel(col));
}
if (rs.next()) { do{
Vector row = new Vector();
// short cod_carte = rs.getShort(1);
for (int i = 1; i <= rsmd.getColumnCount(); i++) {
// short cod_carte1 = rs.getShort(1);
row.addElement(rs.getString("cod_carte"));
row.addElement(rs.getString("nume_autor"));
row.addElement(rs.getString("pren_autor"));
row.addElement(rs.getString("nume_carte"));
row.addElement(rs.getString("nr_car_stoc"));
row.addElement(rs.getString("editura"));
row.addElement(rs.getString("an_aparitie"));
row.addElement(rs.getString("pret_v"));
} model1.addRow(row);
jTextArea1.setText("");
}
while(rs.next());
}
else{
//jTextArea1.setRows(0);
jTextArea1.setText("We're sorry, what you're looking for is not here");
}
con.commit();
con.close();
} catch (SQLException ee) {
ee.printStackTrace();
} catch (Exception f) {
}
}
else if...

[ December 14, 2008: Message edited by: Aneresia White ]

16 years ago

how to set text in textarea if I don't find something in my database?

This is how I search for something:

private void jComboBox1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
if(jComboBox1.getSelectedItem().equals("Cod Carte"))
{
try {
Class.forName("org.apache.derby.jdbc.ClientDriver");
Connection con = (Connection) DriverManager.getConnection("jdbc :mrgreen: erby://localhost:1527/Proiect","aneresia","aneresia");
con.setAutoCommit(false);
int rowsUpdated;
Statement stmt1 = (Statement) con.createStatement();
ResultSet rs = (ResultSet) stmt1.executeQuery("Select cod_carte,nume_autor,pren_autor,nume_carte," +
"nr_car_stoc,editura,an_aparitie,pret_v from CARTI where cod_carte= "+jTextField9.getText());
ResultSetMetaData rsmd = (ResultSetMetaData) rs.getMetaData();
model1.setNumRows(0);
model1.setColumnCount(0);
for (int col = 1; col <= rsmd.getColumnCount(); col++) {
model1.addColumn(rsmd.getColumnLabel(col));
}
while (rs.next()) {
Vector row = new Vector();
// short cod_carte = rs.getShort(1);
for (int i = 1; i <= rsmd.getColumnCount(); i++) {
// short cod_carte1 = rs.getShort(1);
row.addElement(rs.getString("cod_carte"));
row.addElement(rs.getString("nume_autor"));
row.addElement(rs.getString("pren_autor"));
row.addElement(rs.getString("nume_carte"));
row.addElement(rs.getString("nr_car_stoc"));
row.addElement(rs.getString("editura"));
row.addElement(rs.getString("an_aparitie"));
row.addElement(rs.getString("pret_v"));
}
model1.addRow(row);
}
con.commit();
con.close();
} catch (SQLException ee) {
ee.printStackTrace();
} catch (Exception f) {
}
}
else if....}

And if I don't find it I want to set a text in a text area, something like:
"We're sorry, what you're looking for is not here"
Is there any way to do it?

16 years ago

oh great... thank you so much... it worked

That's what I didn't know, how to clear the model.
And now it seems so obvious. :roll:

16 years ago

no that's not it. I'll show you my problem in pictures.
This is my table before update:
photobucket.com

This is my table after update:
photobucket.com

And what I want is now to add those rows again, just to update the table.

16 years ago

I tried this and I get the updated data , but the old rows are still there.

private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
try {
Class.forName("org.apache.derby.jdbc.ClientDriver");
Connection con = (Connection) DriverManager.getConnection("jdbc :mrgreen: erby://localhost:1527/Proiect","aneresia","aneresia");
int rowNumber=jTable1.getSelectedRow()+1; //
Statement stmt1 = con.createStatement();
// int rowsUpdated;
con.setAutoCommit(false);
stmt1.executeUpdate("Update Carti set nume_autor='"+jTextField2.getText()+"' , pren_autor='"+jTextField3.getText()+"', nume_carte='"+(String)jTextField4.getText()+
"' , nr_car_stoc="+jTextField5.getText()+" ,editura='"+jTextField6.getText()+"' , an_aparitie="+jTextField7.getText()+
" , pret_v="+jTextField8.getText()+" where cod_carte="+rowNumber);
model.fireTableRowsUpdated(jTable1.getSelectedRow(),jTable1.getSelectedRow());
if(stmt1.getUpdateCount()>=1){
Statement stmt=con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM Carti");
ResultSetMetaData rsmd = (ResultSetMetaData) rs.getMetaData();
while(rs.next()){
Vector row = new Vector();
short cod_carte = rs.getShort(1);
for (int i = 1; i <= rsmd.getColumnCount(); i++) {
short cod_carte1 = rs.getShort(1);
row.addElement(rs.getString(i));
}
model.addRow(row);
}
}
con.commit();
con.close();
} catch (SQLException ee) {
ee.printStackTrace();
} catch (Exception f) {
}}

But after I rerun the application I get the correct data (the old one+the row updated).Hope you understand what I'm trying to say
So what should I do?

16 years ago

I can update rows in database, but in jTable I see the changes only after I close the application and rerun it. What should I do?
This is my code:

16 years ago

How to insert data from database in jtable

Actually I want to create 5 jframes with different jtables. My database has 5 tables.
[But it would be great if you can give me an example for 1 jtable.]
Can anyone help me? I can't find anything that would help me
And if someone already had this problem, please give me a link

Thank you

16 years ago