Document v=new Document(); DocumentBuilder db=new DocumentBuilder(v); Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con= DriverManager.getConnection("jdbc:oracle:thin:Roney/Roney@localhost:1521:XE","system","2211" ); Statement st= con.createStatement(); long i= st.executeUpdate("insert into student values (1, `kk`, `IT`, `agra`)"); if(i>0) { System.out.println("inserted"); } else { System.out.println("not"); } ResultSet rs=st.executeQuery("select * from student"); while(rs.next()) { // db.writeln(rs.getInt("rollno")); //db.writeln(rs.getString("name")); //db.writeln(rs.getString("department")); //db.writeln(rs.getString("city")); db.startTable(); db. insertCell(); db.write(rs.getString("rollno")); db. insertCell(); db.write(rs.getString("name")); db. insertCell(); db.write(rs.getString("department")); db. insertCell(); db.write(rs.getString("city")); db.endRow(); db.endTable(); } v.save("resultset.pdf"); con.close();
©