| I want solution [message #92766] |
Tue, 11 January 2005 00:16  |
Sachin
Messages: 52
Registered: May 2001
|
Member |
|
|
|
I am an B.E. student, for my project work i need database connectivity for XML through JAVA. So please send me the information about it immediately.
|
|
|
|
| Re: I want solution [message #92773 is a reply to message #92766] |
Wed, 12 January 2005 23:49  |
sujit
Messages: 94
Registered: April 2002
|
Member |
|
|
import java.sql.*;
public class InsertExample {
public static void main(String[[]] args)
throws SQLException {
int ret_code;
Connection conn = null;
try {
int i_empno[[]] = {1001, 1002, 7788};
String i_ename[[]] = {"JOHN","DAVID","ORATEST"};
String i_job[[]] = {"MANAGER","ANALYST","CLERK"};
int i_mgr[[]] = {7839, 1001, 1002};
String i_hiredate = "01-JAN-01";
float i_sal[[]] = {10000,6000, 4000};
float i_comm[[]] = {2000,1000,500};
int i_deptno = 10;
//Load and register Oracle driver
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
//Establish a connection
conn = DriverManager.getConnection("jdbc:oracle:thin:@training:1521:
Oracle", "oratest", "oratest");
String sql1 = "SELECT empno FROM emp WHERE empno = ?" ;
String sql2 = "INSERT INTO emp VALUES (?,?,?,?,?,?,?,?)";
PreparedStatement pstmt1 = conn.prepareStatement(sql1);
PreparedStatement pstmt2 = conn.prepareStatement(sql2);
for (int idx=0;idx<3;idx++)
{
pstmt1.setInt(1, i_empno[[idx]]);
ResultSet rset = pstmt1.executeQuery();
if (rset.next()) {
System.out.println("The employee "
+i_empno[[idx]]+" already exists.");
rset.close();
}
else
{
pstmt2.setInt(1, i_empno[[idx]]);
pstmt2.setString(2, i_ename[[idx]]);
pstmt2.setString(3, i_job[[idx]]);
pstmt2.setInt(4, i_mgr[[idx]]);
pstmt2.setString(5, i_hiredate);
pstmt2.setFloat(6, i_sal[[idx]]);
pstmt2.setFloat(7, i_comm[[idx]]);
pstmt2.setInt(8, i_deptno);
pstmt2.executeUpdate(); }
} // End of for loop
pstmt1.close();
pstmt2.close();
conn.close();
} catch (SQLException e) {ret_code = e.getErrorCode();
System.err.println(ret_code + e.getMessage()); conn.close();}
}
}
See http://www.samspublishing.com/articles/article.asp?p=26251&seqNum=4
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
