如何使 xml 模式关联(链接)到 JTable,xml java? [英] How to make xml schema relate(link) to JTable,xml java?
本文介绍了如何使 xml 模式关联(链接)到 JTable,xml java?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
在这里你可以看到我的申请:
那么我需要做什么:
我不知道如何通过代码将 xml 模式与所有类型(int、string、float)的 JTable 链接起来.说像 Year 是 int 类型，在 schema 中是 int ，我如何链接它?我不知道如何用英文链接或关联.在这个应用程序中，我将所有数据写入 xml 文件，当应用程序加载时，它从 xml 文件加载所有数据.
这里我创建了 xml 架构:
public void CreateSchema(String FileName){文件=文件名；JAXBContext jc;尝试 {jc = JAXBContext.newInstance(XmlSchemaType.class);jc.generateSchema(new SchemaOutputResolver() {@覆盖public javax.xml.transform.Result createOutput(String namespaceURI, StringRecommendedFileName)throws IOException {建议文件名=文件+.xsd"；返回新的 StreamResult(suggestedFileName);}});} catch (IOException e) {e.printStackTrace();} catch (JAXBException e) {e.printStackTrace();}}这里是所有类型:
import javax.xml.bind.annotation.XmlAccessType;导入 javax.xml.bind.annotation.XmlAccessorType;导入 javax.xml.bind.annotation.XmlAttribute;导入 javax.xml.bind.annotation.XmlElement;导入 javax.xml.bind.annotation.XmlRootElement;@XmlAccessorType(XmlAccessType.FIELD)@XmlRootElement(name = "Auto")公共类 XmlSchemaType {行[]行；}类行{@XmlAttribute字节 ID；@XmlElement字符串 VIN；@XmlElement字符串制作；@XmlElement字符串模型；@XmlElement整数年；@XmlElement字符串描述；@XmlElement浮动成本；}这是写入xml文件:
public void CreateXml(JTable tb,JTable tb2,String FileName){尝试 {文件=文件名；DocumentBuilderFactory docFactory = DocumentBuilderFactory.newInstance();DocumentBuilder docBuilder = docFactory.newDocumentBuilder();文档 doc = docBuilder.newDocument();元素 rootElement = doc.createElement("Auto");doc.appendChild(rootElement);int i=0,j=0,k=0;而 (i<tb.getRowCount()){j=0;元素行 = doc.createElement("Row");rootElement.appendChild(rows);Attr attr = doc.createAttribute("id");attr.setValue((i+1)+"");rows.setAttributeNode(attr);//皮尔马扁豆而 (j<tb.getColumnCount()-1){元素元素 = doc.createElement(tb.getTableHeader().getColumnModel().getColumn(j).getHeaderValue()+"");element.appendChild(doc.createTextNode(tb.getModel().getValueAt(i, j)+""));rows.appendChild(元素);j++;}//Antra lentelej=2;//pirmu lauku nereikia而 (j<tb2.getColumnCount()-1){元素 element2 = doc.createElement(tb2.getTableHeader().getColumnModel().getColumn(j).getHeaderValue()+"");element2.appendChild(doc.createTextNode(tb2.getModel().getValueAt(i, j)+""));rows.appendChild(element2);如果 (j==2){tb2.getModel().setValueAt(tb.getModel().getValueAt(i, 0),i,1);}j++;}我++;}TransformerFactory TransformerFactory = TransformerFactory.newInstance();变压器变压器=transformerFactory.newTransformer();DOMSource 源 = 新 DOMSource(doc);StreamResult 结果；尝试 {FileOutputStream fileOutputStream = null;文件输出流 = 新文件输出流(新文件(文件+.xml"))；result = new StreamResult(fileOutputStream);//new FileOutputStream(file+".xml"));transformer.setOutputProperty(OutputKeys.INDENT, "yes");//新行... kad butu naujoje eiluteje变压器.transform(源，结果)；尝试 {fileOutputStream.close();} catch (IOException e) {e.printStackTrace();}} catch (FileNotFoundException e) {e.printStackTrace();}} catch (ParserConfigurationException pce) {pce.printStackTrace();} catch (TransformerException tfe) {tfe.printStackTrace();}//file.renameTo(FileName+".xml");}在这里加载我的 xml 文件:
public void PopulateDataSet(JTable tb,JTable tb2,String FileName){文件=文件名；File f= new File(file+".xml");如果(f.exists()){尝试 {DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance();DocumentBuilder dBuilder = dbFactory.newDocumentBuilder();文档 doc = dBuilder.parse(f);doc.getDocumentElement().normalize();NodeList nList = doc.getElementsByTagName("Row");for (int temp = 0; temp < nList.getLength(); temp++) {节点 nNode = nList.item(temp);if (nNode.getNodeType() == Node.ELEMENT_NODE) {元素 eElement = (元素) nNode;DefaultTableModel 模型 = (DefaultTableModel) tb.getModel();model.addRow(new Object[] { "", "","","","Delete" });tb.getModel().setValueAt(eElement.getElementsByTagName("VIN").item(0).getTextContent(),temp, 0);tb.getModel().setValueAt(eElement.getElementsByTagName("Make").item(0).getTextContent(),temp, 1);tb.getModel().setValueAt(eElement.getElementsByTagName("Make").item(0).getTextContent(),temp, 2);tb.getModel().setValueAt(eElement.getElementsByTagName("Year").item(0).getTextContent(),temp, 3);tb.getModel().setValueAt("删除",temp, 4);DefaultTableModel model2 = (DefaultTableModel) tb2.getModel();model2.addRow(new Object[] { (tb2.getRowCount()+1), "","","","Delete" });tb2.getModel().setValueAt(eElement.getElementsByTagName("VIN").item(0).getTextContent(),temp, 1);tb2.getModel().setValueAt(eElement.getElementsByTagName("Description").item(0).getTextContent(),temp, 2);tb2.getModel().setValueAt(eElement.getElementsByTagName("Cost").item(0).getTextContent(),temp, 3);tb2.getModel().setValueAt("删除",temp, 4);}}} 捕获(异常 e){e.printStackTrace();}}如果 (!f.exists()){CreateXml(tb,tb2,file);创建模式(文件)；}}但是如何在 JTable、xml 中使用 xml shema?
解决方案
"这里正在写入 xml 文件:" ---- "这里正在加载我的 xml 文件:"
当您已经在使用 JAXB 映射时，为什么还要使用 DOM 来读取和写入 xml.如果您正确地进行映射1，只需使用 <小时>
注意: 使用上面的 JAXB 注释，您可以创建架构，并且您想根据它验证 xml，您可以在解组时设置架构.类似的东西:
private static AutoModel unmarshal(String file) throws Exception {JAXBContext 上下文 = JAXBContext.newInstance(AutoModel.class);Unmarshaller unmarshaller = context.createUnmarshaller();SchemaFactory factory = SchemaFactory.newInstance(XMLConstants.W3C_XML_SCHEMA_NS_URI);Schema schema = factory.newSchema(new File("src/table/autos.xsd"));unmarshaller.setSchema(schema);AutoModel 模型 = (AutoModel)unmarshaller.unmarshal(new File(file));退货模式；}Here you can see my application:
So what i need to do:
I dont know how I can through code link xml schema with JTable with all type(int,string,float). Say like Year is type int and in schema is int and how i can link it? I dont know how will be in english link or relate. In this application i write all data to xml file, and when application loaded it loads all data from xml file.
Here i creating xml schema:
public void CreateSchema(String FileName){
file=FileName;
JAXBContext jc;
try {
jc = JAXBContext.newInstance(XmlSchemaType.class);
jc.generateSchema(new SchemaOutputResolver() {
@Override
public javax.xml.transform.Result createOutput(String namespaceURI, String suggestedFileName)throws IOException {
suggestedFileName=file+".xsd";
return new StreamResult(suggestedFileName);
}
});
} catch (IOException e) {
e.printStackTrace();
} catch (JAXBException e) {
e.printStackTrace();
}
}
Here is all types:
import javax.xml.bind.annotation.XmlAccessType;
import javax.xml.bind.annotation.XmlAccessorType;
import javax.xml.bind.annotation.XmlAttribute;
import javax.xml.bind.annotation.XmlElement;
import javax.xml.bind.annotation.XmlRootElement;
@XmlAccessorType(XmlAccessType.FIELD)
@XmlRootElement(name = "Auto")
public class XmlSchemaType {
row[] Row;
}
class row {
@XmlAttribute
byte ID;
@XmlElement
String VIN;
@XmlElement
String Make;
@XmlElement
String Model;
@XmlElement
int Year;
@XmlElement
String Description;
@XmlElement
float Cost;
}
Here is writing to xml file:
public void CreateXml(JTable tb,JTable tb2,String FileName){
try {
file=FileName;
DocumentBuilderFactory docFactory = DocumentBuilderFactory.newInstance();
DocumentBuilder docBuilder = docFactory.newDocumentBuilder();
Document doc = docBuilder.newDocument();
Element rootElement = doc.createElement("Auto");
doc.appendChild(rootElement);
int i=0,j=0,k=0;
while (i<tb.getRowCount()){
j=0;
Element rows = doc.createElement("Row");
rootElement.appendChild(rows);
Attr attr = doc.createAttribute("id");
attr.setValue((i+1)+"");
rows.setAttributeNode(attr);
//Pirma lentele
while (j<tb.getColumnCount()-1){
Element element = doc.createElement(tb.getTableHeader().getColumnModel().getColumn(j).getHeaderValue()+"");
element.appendChild(doc.createTextNode(tb.getModel().getValueAt(i, j)+""));
rows.appendChild(element);
j++;
}
//Antra lentele
j=2;//pirmu lauku nereikia
while (j<tb2.getColumnCount()-1){
Element element2 = doc.createElement(tb2.getTableHeader().getColumnModel().getColumn(j).getHeaderValue()+"");
element2.appendChild(doc.createTextNode(tb2.getModel().getValueAt(i, j)+""));
rows.appendChild(element2);
if (j==2){
tb2.getModel().setValueAt(tb.getModel().getValueAt(i, 0),i,1);
}
j++;
}
i++;
}
TransformerFactory transformerFactory = TransformerFactory.newInstance();
Transformer transformer = transformerFactory.newTransformer();
DOMSource source = new DOMSource(doc);
StreamResult result;
try {
FileOutputStream fileOutputStream = null;
fileOutputStream = new FileOutputStream(
new File(file+".xml"));
result = new StreamResult(fileOutputStream);//new FileOutputStream(file+".xml"));
transformer.setOutputProperty(OutputKeys.INDENT, "yes");//new line... kad butu naujoje eiluteje
transformer.transform(source, result);
try {
fileOutputStream.close();
} catch (IOException e) {
e.printStackTrace();
}
} catch (FileNotFoundException e) {
e.printStackTrace();
}
} catch (ParserConfigurationException pce) {
pce.printStackTrace();
} catch (TransformerException tfe) {
tfe.printStackTrace();
}
//file.renameTo(FileName+".xml");
}
And here loading my xml file:
public void PopulateDataSet(JTable tb,JTable tb2,String FileName){
file=FileName;
File f= new File(file+".xml");
if (f.exists()){
try {
DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance();
DocumentBuilder dBuilder = dbFactory.newDocumentBuilder();
Document doc = dBuilder.parse(f);
doc.getDocumentElement().normalize();
NodeList nList = doc.getElementsByTagName("Row");
for (int temp = 0; temp < nList.getLength(); temp++) {
Node nNode = nList.item(temp);
if (nNode.getNodeType() == Node.ELEMENT_NODE) {
Element eElement = (Element) nNode;
DefaultTableModel model = (DefaultTableModel) tb.getModel();
model.addRow(new Object[] { "", "","","","Delete" });
tb.getModel().setValueAt(eElement.getElementsByTagName("VIN").item(0).getTextContent(),temp, 0);
tb.getModel().setValueAt(eElement.getElementsByTagName("Make").item(0).getTextContent(),temp, 1);
tb.getModel().setValueAt(eElement.getElementsByTagName("Make").item(0).getTextContent(),temp, 2);
tb.getModel().setValueAt(eElement.getElementsByTagName("Year").item(0).getTextContent(),temp, 3);
tb.getModel().setValueAt("Delete",temp, 4);
DefaultTableModel model2 = (DefaultTableModel) tb2.getModel();
model2.addRow(new Object[] { (tb2.getRowCount()+1), "","","","Delete" });
tb2.getModel().setValueAt(eElement.getElementsByTagName("VIN").item(0).getTextContent(),temp, 1);
tb2.getModel().setValueAt(eElement.getElementsByTagName("Description").item(0).getTextContent(),temp, 2);
tb2.getModel().setValueAt(eElement.getElementsByTagName("Cost").item(0).getTextContent(),temp, 3);
tb2.getModel().setValueAt("Delete",temp, 4);
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
if (!f.exists()){
CreateXml(tb,tb2,file);
CreateSchema(file);
}
}
But how to use xml shema with JTable, xml?
解决方案
"Here is writing to xml file:" ---- "And here loading my xml file:"
Why are you using DOM to read and write the xml, when you are already using JAXB Mapping. If you are doing the mapping correctly 1, it's just a matter of using the Marshaller and Unmarshaller to write and read, respectively. Make sure to look at those API links yo see example usage. It's only around 5 lines of code to handle each operaion.
(1) Please see the JAXB tutorial for more info about JAXB mapping.
Also, you can just create your own AbstractTableModel and unmarshal and marshal straight to and from the table model. This is probably the most effective way to keep everything sync. Create a class Auto to represent each row, and a class AutoModel, that will be the root element in the xml document, as well as the TableModel for the JTable. Something like:
Auto class
@XmlAccessorType(XmlAccessType.FIELD)
@XmlType(name = "Auto", propOrder = {
"id", "VIN", "Make", "Model", "Year", "Description", "Cost"
})
public class Auto {
@XmlElement(name = "id")
Integer id;
@XmlElement(name = "VIN")
String VIN;
@XmlElement(name = "Make")
String Make;
@XmlElement(name = "Model")
String Model;
@XmlElement(name = "Year")
Integer Year;
@XmlElement(name = "Description")
String Description;
@XmlElement(name = "Cost")
Float Cost;
// === DON'T FORGET YOUR GETTERS and SETTERS
}
AutoModel class
@XmlRootElement(name = "AutoList")
public class AutoModel extends AbstractTableModel {
String[] columnNames = {"VIN", "Make", "Model", "Year"};
@XmlElement(name = "Auto")
protected List<Auto> autos;
public AutoModel() {
autos = new ArrayList<Auto>();
}
@Override
public int getRowCount() {
return autos.size();
}
@Override
public int getColumnCount() {
return columnNames.length;
}
@Override
public String getColumnName(int columnIndex) {
return columnNames[columnIndex];
}
@Override
public boolean isCellEditable(int row, int col) {
return false;
}
@Override
public Object getValueAt(int rowIndex, int columnIndex) {
Auto auto = autos.get(rowIndex);
Object value = null;
switch (columnIndex) {
case 0 : value = auto.getVIN(); break;
case 1 : value = auto.getMake(); break;
case 2 : value = auto.getModel(); break;
case 3 : value = auto.getYear(); break;
}
return value;
}
}
Test, using this xml file
<?xml version="1.0" encoding="UTF-8"?>
<AutoList>
<Auto>
<id>1</id>
<VIN>123456788910FASDE</VIN>
<Make>Mercedes</Make>
<Model>CL 550</Model>
<Year>2012</Year>
<Description>Hello World</Description>
<Cost>80000.00</Cost>
</Auto>
</AutoList>
import java.awt.Dimension;
import java.io.File;
import javax.swing.*;
import javax.xml.bind.*;
public class TestTableMarshall {
private static final String INPUT_FILE = "src/table/autos.xml";
private static final String OUTPUT_FILE = "src/table/autos1.xml";
public static void main(String[] args) throws Exception {
AutoModel model = unmarshal(INPUT_FILE);
JTable table = new JTable(model) {
@Override
public Dimension getPreferredScrollableViewportSize() {
return getPreferredSize();
}
};
JOptionPane.showMessageDialog(null, new JScrollPane(table));
marshal(model, OUTPUT_FILE);
}
private static void marshal(AutoModel model, String file) throws Exception {
JAXBContext context = JAXBContext.newInstance(AutoModel.class);
Marshaller marshaller = context.createMarshaller();
File f= new File(file);
marshaller.setProperty(Marshaller.JAXB_FORMATTED_OUTPUT, true);
marshaller.marshal(model, f);
}
private static AutoModel unmarshal(String file) throws Exception {
JAXBContext context = JAXBContext.newInstance(AutoModel.class);
Unmarshaller unmarshaller = context.createUnmarshaller();
AutoModel model = (AutoModel)unmarshaller.unmarshal(new File(file));
return model;
}
}
As far the the AutoModel goes, it only works for your first table. You will need to create another model for your repairs table. Also, the model, currently only offered read-only. You will need to add other functionality to say add a row and set individual values.
Here are some resources to look at:
NOTE: With the JAXB annotations above you can create the schema, and you you want to validate the xml against it, you could just set the schema when you unmarshal. Something like:
private static AutoModel unmarshal(String file) throws Exception {
JAXBContext context = JAXBContext.newInstance(AutoModel.class);
Unmarshaller unmarshaller = context.createUnmarshaller();
SchemaFactory factory = SchemaFactory.newInstance(XMLConstants.W3C_XML_SCHEMA_NS_URI);
Schema schema = factory.newSchema(new File("src/table/autos.xsd"));
unmarshaller.setSchema(schema);
AutoModel model = (AutoModel)unmarshaller.unmarshal(new File(file));
return model;
}
这篇关于如何使 xml 模式关联(链接)到 JTable,xml java?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
