torsti koistinen

Here is my problem, in my Java applet i got this textfield(txtNormalHours) and button(xml).
When I press this button program should create file foo.xml, but nothing happens, no errors.
Here is the funny part without that button code works fine and foo.xml is cr

I have created project management software with Java and MySql and it works fine.
This applet gets and writes information directly to MySql database.

Problem is that those sqlClauses below(update and insert) should go "through" xml "document" and i haven�t got idea how to do that.
If someone could give me advices or even tell me how I must modify my code I would be very grateful.

My english is not so good, so my problem sentence could be little hard to understand, but please try. If it�s too hard to understand please tell me even how can i save results of those clauses to xml "document". (soap?)



Here is part of main program:
void cmgUpdateNormalHours1_actionPerformed(ActionEvent e) { ///button update if(e.getActionCommand().equals("Update")) { ResultSet Result; String proj= txtProjectNumber.getText();//gets project number String day= txtDate1.getText();//gets date String paivitus = txtNormalHours1.getText(); //gets normalhours int changes=0; String sqlClause="select count(*) from hours where days ='"+day+"'"; Tietokantayhteys Conn = new Tietokantayhteys(); ///connection to the database Result= Conn.Query(sqlClause); String result=null; //different result than Result try { Result.next(); result=Result.getString(1); } catch(Exception ex) { ex.printStackTrace(); } int tempa=Integer.parseInt(result); if(tempa==1) { String sqlClause1 = "update hours set normalhours= '" + paivitus + "'" + "where proj_id = " + proj + " and days ='" + day + "'"; tempa=Conn.UpdateQuery(sqlClause1); } if(tempa==0) { String sqlClause2= "insert into hours (proj_id, days, normalhours) " + "values ("+proj+",'"+day+"','"+paivitus+"')"; tempa=Conn.UpdateQuery(sqlClause2); }

And here is database connection class which i have created:

package simple; import java.sql.*; public class Tietokantayhteys { ///m��ritell��n luokan tarvitsemat oliot ///define object which class need Connection Conn; Statement st; ResultSet Result; public Tietokantayhteys() { //open connection to database try { ///load database driver Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Conn = DriverManager.getConnection ( "jdbc :o dbc :p ro","root",""); //set start value to Statement object st = Conn.createStatement(); } catch (Exception e) { e.printStackTrace(); } } // query method for select public ResultSet Query(String sqlClause) { try { Result = st.executeQuery(sqlClause); } catch (Exception e) { e.printStackTrace(); } return Result; } /// update method for update inquery public int UpdateQuery(String sqlClause) { //saves how many changes has been made int muutoksia=0; try { muutoksia = st.executeUpdate(sqlClause); ///<---muutoksia means == changes } catch(Exception e) { e.printStackTrace(); } return muutoksia; } ////close all connections public void suljeYhteys() ///<---means close connection { try { st.close(); Conn.close(); } catch(Exception e) { e.printStackTrace(); } } }
[edited to disable smilies - in the future, you can do it by clicking the disable smilies button in the options section (near the bottom) of the posting page]
[ August 09, 2004: Message edited by: Jeanne Boyarsky ]

If only someone could help

All code(s) below gives me a current date,
but I also need to get tomorrows and yesterdays dates.

I think I can�t use simpledateformat because I need to import import java.sql.*;

So if anyone can tell me how to modify some of the codes below, It would be great. All I need is that I get forexample this yesterdays or tomorrows date with the
"codes" below:


these are the codes what I have try to use without success

1.
java.sql.Date date = new java.sql.Date((new GregorianCalendar()).getTime().getTime()); jTextField2.setText(""+date);

2.
Calendar cal = GregorianCalendar.getInstance(); DateFormat fmt = DateFormat.getInstance(); String buf = fmt.format(cal.getTime()); jTextField2.setText(""+buf);

3. java.util.Date today = new java.util.Date(); java.sql.Date sqlToday = new java.sql.Date(today.getTime()+1); jTextField2.setText(""+sqlToday);

First, I am sorry about my broken English.
I have created simple project manager software with MySql and Java and I got this little problem.


my problem: : java.sql.SQLException: No row count was produced
-so there is something wrong in my code, but I can�t find out what is wrong
If I do those sql-clauses without switch they work.

This is what i am trying to do: Sql-clause should check is there this days(2004-07-29) field in database if there is sql-clause should only update hours(user given) of the day, but if there is not this days field sql-clause should create it. That�s why I need switch.

String update1=null; String today=null; update1 = jTextField14.getText(); ///user input hours today= jTextField18.getText(); //user input date (2004-07-29) String sqlClause= "select days from hours where days ='2004-07-29'"; int chances=0; Connection conn = new Connection(); chances = conn.updatequery(sqlClause); switch(chances) { case 0: String sqlClause1= " insert into hours set normalhours = '" + update1+"'where proj_id = " + proj + " and days = '" + today +"'"; break; case 1: String sqlClause2= "update hours set normalhours = '" + update1 +"' where proj_id = " + proj + " and days = '" + today +"'"; break; }

I have tried to resolve this problem days.
If someone could please help me