I need to know how to access two tables which has some reference values within the table.I need the Java Code to Fetch Both the tables values which are same and have to display it
There is no code of Java to fetch data from databases. Obviously, it is the SQL statements. You want to fetch data from two tables based upon the reference value; So, think about Database object Views or write down Joins (select query).
sql="select a.col1,a.col2,b.col1,b.col2 from table1 a, table2 b where a.col1=b.col1";
// Load a driver
// Establish DB Connection
System.out.println(rs.getString(1) + " " + rs.getString(2) + ....);
I am writing a java program that needs to execute shell commands, so I wrote a function that would take the command to execute as a string (ie: "mkdir ~/Folder1") and execute that command with the shell. Here is the function:
Runtime run = Runtime.getRuntime();
Process pr = ...
Hi, as I was told that my code doesn’t scale well at all, I thought perhaps I’d try to get a better understanding of interfaces/abstract classes and classes and the relationship between them.
I don’t want at this stage work on a big separate project as I've already got plenty ...
Hi. I have a form with list box : lst_product, datagridview : grd_order and button: btn_addline. lst_product has a list of product ids selected from database (MS Acess 2013) , grd_order is by default empty except for 2 headers and btn_addline adds rows to grd_order.