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> </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.
Ads
