Big Data and Hadoop Training @$80 or Rs. 6,000 only - valid till Oct 17th Apply Now!

How to compare two tables, and insert values which r not in one table to another table?

Ads
 

How to compare two tables, and insert values which r not in one table to another table?

Hi

I need to compare two tables MainTable and OUTTable, The maintable may not have all the data so...if outtable have new data just insert the values to main_table...

here is my sql query

insert into Main_Table MT (MT.serialno) values (Select SerialNo Main_Table MT from where not exists (select SerialNo from OUT_Table OT where OT.SerialNo = MT.SerialNo));

here is my code:

<%@ page import="java.sql.*" %>
<% Class.forName("oracle.jdbc.driver.OracleDriver");%>
<HTML>

    <BODY bgcolor="#99CCFF">
        <p>&nbsp;</p>
<p><img src="SingtelLogoBanner.gif" width="87" height="25"> </p>
<center>
<td align="right" width=37> <strong><img title="Go back" src="Undo.gif" width="20" height="20" onClick="javascript:history.back()" style="vertical-align:middle;" onMouseOver="this.style.cursor='hand';"></strong>
<td align="right" width=38> <strong><img title="Print it" src="Print.gif" width="20" height="20" onClick="javascript:window.print()" style="vertical-align:middle;" onMouseOver="this.style.cursor='hand';">
        </strong>
</center>
<H1 align="center">Inventory</H1>
        <%

        String connectionURL = "jdbc:oracle:thin:@localhost:1521:scott";
        String driver = "oracle.jdbc.driver.OracleDriver";
        String user = "root";
        String pass = "root";
        Connection connection = null;
        PreparedStatement pstatement = null;
        ResultSet resultset;
        int i = 1;

            Class.forName(driver).newInstance();
           connection = DriverManager.getConnection(connectionURL,user,pass);



             String queryString = ("insert into Main_Table MT (MT.serialno) values (Select SerialNo from Main_Table MT where not exists (select SerialNo from OUT_Table OT where OT.SerialNo = MT.SerialNo))");
             resultset = pstatement.executeQuery(queryString);
        %>

    </BODY>
</HTML>

This query is selecting all the values which r not in maintable...but not inserting into the main table using jsp. I am doing this program using JSP. Please can you give me the code to insert the values into maintable. Please help me out. Iam stuck here.

Thanks in advance Lissy.

View Answers

Ads









Related Tutorials/Questions & Answers:
How to compare two tables, and insert values which r not in one table to another table?
how to set the tables one is left and another one is right - JSP-Servlet
Advertisements
can i insert values into two tables by a query - JDBC
how to store array values into two different tables in java?
how to do two database tables in one page?
how to get values for same column name from two different tables in SQL
Data fetch from multiple SQL tables - Hibernate
Join the two tables in sql
how to insert one table to anothere table
SQL Server row comparison using two tables
take data from one table and insert same in another
how to add the two tables in same row when generating pdf file from jsp - JSP-Servlet
Comparing tables
How to send and view data in seperate tables of a swing application, to a japser reporting(two)
How to send and view data in seperate tables of a swing application, to a japser reporting(two)
tables in oracle 10g
search in Two Tables to Find data and view by jsp
merge tables in sql using union
sql query to get data from two tables
CSV tables
Combine Two Tables(Purchase and Sales) and getting Current Stock
types of relationships in tables
how to compare text in two jTextarea
Joining tables using criteria
Join tables in the specific database
update one table from another table
how to count unique and duplicate values from one table in mysql?
Nest tables within tables
how to get multiple hyperlink values from a table column to another jsp file?
what is the jsp coding to insert a data in database tables
I cant get values in MS acces in tables

Ads