多谢10楼的～！
最近又遇到新问题啦！求大侠帮忙啊！
程序能运行，就是数据库里没东西，只有NULL!(对了是SQL2000的)。还有能直接把数据存到SQL中，但是提取XML中的数据就存上就为空。
下面是我的程序，请大家指点：
package shujuku;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.JDOMException;
import org.jdom.input.SAXBuilder;
public class Cshuju extends Object{
public static String str_id;
public static String str_number;
public static String str_name;
public static String str_age;
public Cshuju() {
}
public void conn() throws JDOMException{
SAXBuilder builder = new SAXBuilder();
Document read_doc = null;
try {
read_doc = builder.build("stu.xml");
} catch (JDOMException ex) {
ex.printStackTrace();
} catch (IOException ex) {
ex.printStackTrace();
}
Element stu1 = read_doc.getRootElement();
List list = stu1.getChildren("students");
for(int i = 0;i < list.size();i++) {
Element e = (Element)list.get(i);
int str_id = 2;
String str_number = e.getChildText("number");
String str_name = e.getChildText("name");
String str_age = e.getChildText("age");
System.out.println("---------STUDENT--------------");
System.out.println("NUMBER:" + str_number);
System.out.println("NAME:" + str_name);
System.out.println("AGE:" + str_age);
System.out.println("------------------------------");
System.out.println();
}
}
public static void main(String args[])throws Exception{
new Stu().conn();
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
} catch (InstantiationException ex) {
ex.printStackTrace();
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
} catch (IllegalAccessException ex) {
ex.printStackTrace();
}
String url ="jdbc:microsoft:sqlserver://localhost:1433;databaseName=students;";
Connection conn = null;
try {
conn = DriverManager.getConnection(url, "sa", "");
} catch (SQLException ex) {
ex.printStackTrace();
}
Statement statement = null;
try {
statement = conn.createStatement();
} catch (SQLException ex) {
ex.printStackTrace();
}
String sqlTxt = "insert into stu1 "+"(id,number, name, age) "+ "values
('"+str_id+"','"+str_number+"', '"+str_name+"', '"+str_age+"')";
int results = statement.executeUpdate(sqlTxt);
System.out.print("XML 数据输入完毕！");
}
}
[返回] W3CHINA.ORG讨论区 - 语义网·描述逻辑·本体·RDF·OWL →
XML.ORG.CN讨论区 - 高级XML应用 → 『 XML 与 数据库 』 → [求助]怎样把XML导入Access数据库？？
(订阅本版)
2007/5/29 19:41:00
新浪微博
