Сделать пару правок в программе на Java
11 USDДобрый день, мне нужно сделать кое какие правки в этой программе , а именно добавить 4-6 полей для записи в бд, при записи новой тачки с определенного "АВтор ЙД" оно добавляет значение +1 в таблицу "Каунт Ноде" оно єто делает не правильно (как правильно я покажу) и еще кое что исправить
Applications 1
-
247 Здравствуйте, если остальные задания такие же, много времени правки не займут, да и в бюджет впишемся. В общем, обращайтесь, обсудим.
-
235 10 0 Здравствуйте. Готов взяться за правки, нужно немного уточнить ТЗ.
-
В архиве нету исходников...
-
что неправильного в
String sqllUpdate = "UPDATE spider_car.telephone SET count_node=count_node+1 WHERE author_id='" + newFormat + "'";
-
С кода программы
-
а почему нет? только ваши правки нужно менять - сначала нужно найти max
-
new Integer(rs.getString("count_node")); - вот этот код для чего? он не используется. и я бы использовал запрос с параметрами, а не через конкат -
вообще не понятно что этим хотели сказать
String sqll = "SELECT * FROM spider_car.telephone WHERE author_id='" + newFormat + "';";
System.out.println("sql query= " + sqll);
Statement stmt = c.createStatement();
Statement stmt2 = c.createStatement();
ResultSet rs = stmt.executeQuery(sqll);
System.out.println("select from telephone " + sqll);
Integer telcount = Integer.valueOf(1);
while (rs.next())
{
telcount = new Integer(rs.getString("count_node"));
String sqllUpdate = "UPDATE spider_car.telephone SET count_node=count_node+1 WHERE author_id='" + newFormat + "'";
System.out.println(" " + sqllUpdate);
int i = stmt2.executeUpdate(sqllUpdate);
}
-
Current freelance projects in the category Databases & SQL
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 22 hours 43 minutes back ∙ 9 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 1 day 9 hours back ∙ 4 proposals |
CRM system for Railway LogisticsCreation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 1 day 21 hours back ∙ 39 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 4 days 16 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
602 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 6 days 20 hours back ∙ 58 proposals |