1 reply
by gabriela2
What about this:
import java.sql.*;
import java.io.*;
public class myXml {
private static final String dbDriver=...
private static final String dbURL = ...
private static final String userId = ...
private static final String password =...
private static final String query =new String("SELECT* FROM emp");
public static void main(String[] Args){
Connection conn=null;
Statement s= null;
ResultSet r= null;
String ename; double sal; String manager; int empid;
try{
Class.forName(dbDriver).newInstance();
}catch (Exception e){
System.out.println("Loading Driver "+e);
}
try{
conn=DriverManager.getConnection(dbURL, userId, password);
}catch (Exception e){
System.out.println("Creating Connection "+e );
}
try{
if (conn!=null){
s=conn.createStatement();
r=s.executeQuery( query );
//Open a text file for output...
BufferedWriter myFile=
new BufferedWriter( new FileWriter ("emplist.xml"));
myFile.write("\r");
myFile.write("\r");
while(r.next()){
ename=r.getString("ename");
sal=r.getDouble("sal");
manager=r.getString("mgr");
empid=r.getInt("empno");
myFile.write(" \r");
myFile.write(" "+ename+"\r");
myFile.write(" "+sal+"\r");
myFile.write(" "+manager+"\r");
}
myFile.write("/emplist>\r");
myFile.close();
}
}catch (Exception e){
System.out.println("Executing query "+e);
}finally{
try{
r.close();
s.close();
conn.close();
}catch(Exception e){
System.out.println("Closing Database Objects "+e);
}}
}}
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending