?? students.java
字號:
package student_details;import java.sql.*;import javax.xml.parsers.*;import org.w3c.dom.*;import org.xml.sax.*;import java.io.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 1999</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class Students { public static void main(String[] args) throws Exception{ String headerstring = "<?xml version=\"1.0\"?>"; String root = "<students>"; String rootend = "</students>"; File ff = new File("students.xml"); ff.createNewFile(); FileWriter fw = new FileWriter(ff); fw.write(headerstring); fw.write(root); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn = DriverManager.getConnection("jdbc:odbc:sqlodbc","sa","123"); Statement stmt = conn.createStatement(); ResultSet rs=stmt.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(); }}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -