students.java

来自「j2ee 小例子内容包含 javabean、xml 在java中的应用、 集」· Java 代码 · 共 49 行

package Students;

import java.sql.*;
import javax.xml.parsers.*;
import org.w3c.dom.*;
import org.xml.sax.*;
import java.io.*;

public class Students {
  public static void main(String[] args) {
    String headerstring = "<?xml version = \"1.0\"?>";
    String root = "<students>";
    String rootend = "</students>";
    try{
      File ff = new File("students.xml");
      ff.createNewFile();
      FileWriter fw = new FileWriter(ff);
      fw.write(headerstring);
      fw.write(root);

      Class.forName("oracle.jdbc.driver.OracleDriver");
      Connection con = DriverManager.getConnection("jdbc:oracle:oci8:@newer","scott","tiger");
      Statement st = con.createStatement();
      ResultSet rs = st.executeQuery("select * from students");

      while(rs.next()){
        fw.write("<student>");

        fw.write("<stud_id>");
        String stud_id = rs.getString("stud_id");
        fw.write(stud_id);
        fw.write("</stud_id>");

        fw.write("<stud_name>");
        String stud_name = rs.getString("stud_name");
        fw.write(stud_name);
        fw.write("</stud_name>");

        fw.write("</student>");
      }
      fw.write(rootend);
      fw.close();
      System.out.println("success");
    }catch(Exception ex){
      System.out.println(ex);
    }
  }
}