Answer to Question #5048 in Other Programming & Computer Science for Laz Kenamu




 write down a JDBC program to update or insert a record into a database using JDBC connection in java
The answer to the question is available in the PDF file https://www.assignmentexpert.com/homework-answers/programming-answer-5048.pdf
I just posted an example of this over in a similar thread about JTable [here](/software-development/java/threads/373078/1605358#post1605358). Perhaps it will help. If you're unsure of writing joins in SQL use an SQL builder.


Top of my list is still SQLeo which is java based. If you make a small donation you get the full thing, you only need to donate a dollar.


Others are navicat but they have a trial not sure if it is only available to windows either. java.sql.timestamp is a subclass of java.util.date - it should work the same for comparison purposes:

<https://docs.oracle.com/en/java/javase/11/docs/api/java.sql/java/sql/timestamp.html>

if you specifically need a date, you could convert it back pretty easily; check if isinstance(java.sql.timestamp… let table = base.gettable("table 1")

let record = await input.recordasync("record", table)

await table.updaterecordasync(record.id, {

"single select": null

}) Hi,  
  
You can modify the inputs and outputs of any recipe in the Flow (by going to the Inputs/Outputs tab of this recipe), which allows you to replug parts of the flow elsewhere when needed. So you should be able to create your new joined dataset, and replug it to the rest of your Flow
 
 
 
 
 
 
 
 
 

[View solution in original post](/t5/Using-Dataiku-DSS/Insert-element-into-flow/m-p/2284#M1600) There is not an existing script but you could probably do it thru the Lotus COM interface. The easiest way is to create an agent in Lotus Notes to extract the information from Excel, and then using the NOTESACL objects of NotesDatabase add the references.


Does this help? If you need further assistance, please be a little more descriptive and I will see if I can help further.


Mike K. not [full disclosure] a linux person per se.

something similar to the following should work:

https://www.unix.com/shell-programming-and-scripting/68166-converting-integer-string.html

start simple with just enough code to test the concept.

see if it works and modify/correct as necessary.

then if it still does not work, then post your documented code accordingly along an explanation of what is or is not happening as you expect or desire. Here is a link to assist you.


<https://technet.microsoft.com/en-us/library/ms178078(v=sql.105).aspx>


If you had done a web search with the question you entered here, you would have found multiple sites that give you the instructions You could go the easy way and use [ADO.NET Data Services](http://codebetter.com/blogs/david.hayden/archive/2008/01/08/getting-started-with-ado-net-data-services.aspx). [@whyyouandi](/u/whyyouandi)

[image] whyyouandi:

i want to append another column of data.

you can add a column with [add data column] activity.

<https://www.uipath.com/activities-guide/add-data-column>

[image] whyyouandi:

and then edit the scrap date per row.

and to add a value to a target column, ch…