?? students.java
字號:
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); } }}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -