Реферат Автоматизація ведення обліку замовлень на автомобільні перевезення

String ());=result.getMetaData ();

. out.println ( Database connection established ) ;. close ();

} catch (Exception e)

{. err.println ( Error in client Set ) ;. printStackTrace ();

}

}

//======================================== ==================== void addOrder (int IDClient, String AddrFrom, String AddrTo, int IDDriver, String inTime, int IDUser)

{conn=null; .sql.Statement S=null; result=null; rs=null;

sql=new StringBuffer () ;. append ( call O_Add(raquo;);.append(IDClient);.append(laquo;,raquo;);.append(laquo;laquo;raquo;);.append(AddrFrom);.append(laquo;raquo;raquo;);.append(laquo;,raquo;);.append(laquo;laquo;raquo;);.append(AddrTo);.append(laquo;raquo;raquo;);.append(laquo;,raquo;);.append(IDDriver);.append(laquo;,raquo;);.append(laquo;laquo;raquo;);.append(inTime);.append(laquo;raquo;raquo;);.append(laquo;,raquo;);.append(IDUser);.append(laquo;);raquo;);

{. forName ( com.mysql.jdbc.Driver ). newInstance ();=DriverManager.getConnection (DB_HOST, DB_USER, DB_PASSWORD);=conn.createStatement ();

. out.println (sql);

=S.executeQuery (sql.toString ());=result.getMetaData ();

. out.println ( Database connection established ) ;. close ();

} catch (Exception e)

{. err.println ( Error in client Set ) ;. printStackTrace ();

}

}

//======================================== ==================== void acceptOrder (int IDOrder, int Length, int Price, String comment)

{conn=null; .sql.Statement S=null; result=null; rs=null;

sql=new StringBuffer () ;. append ( call O_Accept(raquo;);.append(Length);.append(laquo;,raquo;);.append(Price);.append(laquo;,raquo;);.append(laquo;laquo;raquo;);.append(comment);.append(laquo;raquo;raquo;);.append(laquo;,raquo;);.append(IDOrder);.append(laquo;);raquo;);

{. forName ( com.mysql.jdbc.Driver ). newInstance ();=DriverManager.getConnection (DB_HOST, DB_USER, DB_PASSWORD);=conn.createStatement ();

. out.println (sql);

=S.executeQuery (sql.toString ());=result.getMetaData ();

. out.println ( Database connection established ) ;. close ();

} catch (Exception e)

{. err.println ( Error in client Set ) ;. printStackTrace ();

}

}

//======================================== ==================== void updateClient (int IDClient, String FName, String LName, String MName, String Telephone, String Addres)

{conn=null; .sql.Statement S=null; result=null; rs=null;

sql=new StringBuffer () ;. append ( call CL_Update(raquo;);.append(IDClient);.append(laquo;,raquo;);.append(laquo;laquo;raquo;);.append(FName);.append(laquo;raquo;raquo;);.append(laquo;,raquo;);.append(laquo;laquo;raquo;);.append(LName);.append(laquo;raquo;raquo;);.append(laquo;,raquo;);.append(laquo;laquo;raquo;);.append(MName);.append(laquo;raquo;raquo;);.append(laquo;,raquo;);.append(laquo;laquo;raquo;);.append(Telephone);.append(laquo;raquo;raquo;);.append(laquo;,raquo;);.append(laquo;laquo;raquo;);.append(Addres);.append(laquo;raquo;raquo;);.append(laquo;);raquo;);

{. forName ( com.mysql.jdbc.Driver ). newInstance ();=DriverManager.getConnection (DB_HOST, DB_USER, DB_PASSWORD);=conn.createStatement ();

. out.println (sql);

=S.executeQuery (sql.toString ());=result.getMetaData ();

. out.println ( Database connection established ) ;. close ();

} catch (Exception e)

{. err.println ( Error in client Set ) ;. printStackTrace ();

}

}

//======================================== ==================== void carSet (String Model, int NumPas, String Number, String Color, int IDDriver)

{conn=null; .sql.Statement S=null; result=null; rs=null;

sql=new StringBuffer () ;. append ( call C_Set(raquo;);.append(laquo;laquo;raquo;);.append(Model);.append(laquo;raquo;raquo;);.append(laquo;,raquo;);.append(NumPas);.append(laquo;,raquo;);.append(laquo;laquo;raquo;);.append(Number);.append(laquo;raquo;raquo;);.append(laquo;,raquo;);.append(laquo;laquo;raquo;);.append(Color);.append(laquo;raquo;raquo;);.append(laquo;,raquo;);.append(IDDriver);.append(laquo;);raquo;);

{. forName ( com.mysql.jdbc.Driver ). newInstance (...