李越 10:43:25
xml如下:
<?xml version="1.0" ?>
- <ROWDATA>
- <ROW>
<C0>1</C0>
<BOOKID>3</BOOKID>
<WAREHOUSENAME>馆藏标准</WAREHOUSENAME>
<ISBN>333</ISBN>
<BOOKINDEX>333</BOOKINDEX>
<BOOKNAME>333</BOOKNAME>
<BOOKTYPENUM>333</BOOKTYPENUM>
<AUTHOR>333</AUTHOR>
<TRANSLATOR>333</TRANSLATOR>
<PUBHOUSE>333</PUBHOUSE>
<PUBLISHPLACE>333</PUBLISHPLACE>
<PUBLISHDATE>333</PUBLISHDATE>
<PRICE />
<BOOKINDATE>333</BOOKINDATE>
<BOOKINTIME>333</BOOKINTIME>
<SERIALNUM>333</SERIALNUM>
<REMAINNUM>4</REMAINNUM>
<LENTNUM>0</LENTNUM>
<RESERVEDNUM>4</RESERVEDNUM>
<BOOKVERSION>333</BOOKVERSION>
<BOOKFORMAT>32</BOOKFORMAT>
<KEYWORDS>333</KEYWORDS>
<PAGECOUNT>333</PAGECOUNT>
<INTRODUCTION>333</INTRODUCTION>
<BOOKMEMO>333</BOOKMEMO>
<BOOKTYPE>333</BOOKTYPE>
<TYPENUM>333</TYPENUM>
<ISSUENUM />
<ID>0</ID>
<ISSUETITLE />
<ISSUEDATE />
<YEARISSUE />
<ORGANIZERS />
<AUTHORUNIT />
<ISISSUE>1</ISISSUE>
<ROWID>AAAIRyAAPAAAAiKAAA</ROWID>
</ROW>
- <ROW>
<C0>2</C0>
<BOOKID>4</BOOKID>
<WAREHOUSENAME>馆藏外刊</WAREHOUSENAME>
<ISBN />
<BOOKINDEX />
<BOOKNAME>444</BOOKNAME>
<BOOKTYPENUM>444</BOOKTYPENUM>
<AUTHOR>444</AUTHOR>
<TRANSLATOR />
<PUBHOUSE />
<PUBLISHPLACE />
<PUBLISHDATE />
<PRICE />
<BOOKINDATE />
<BOOKINTIME />
<SERIALNUM />
<REMAINNUM>4</REMAINNUM>
<LENTNUM>0</LENTNUM>
<RESERVEDNUM>4</RESERVEDNUM>
<BOOKVERSION />
<BOOKFORMAT>0</BOOKFORMAT>
<KEYWORDS>444</KEYWORDS>
<PAGECOUNT>444</PAGECOUNT>
<INTRODUCTION>444</INTRODUCTION>
<BOOKMEMO />
<BOOKTYPE />
<TYPENUM />
<ISSUENUM>444</ISSUENUM>
<ID>0</ID>
<ISSUETITLE>444</ISSUETITLE>
<ISSUEDATE>444</ISSUEDATE>
<YEARISSUE>444</YEARISSUE>
<ORGANIZERS>444</ORGANIZERS>
<AUTHORUNIT>444</AUTHORUNIT>
<ISISSUE>0</ISISSUE>
<ROWID>AAAIRyAAPAAAAiKAAB</ROWID>
</ROW>
</ROWDATA>行数不确定 (从其他表里导出的)
我想把如上的xml数据再导入到Oracle的一张表里面:BM_BOOK
BM_BOOK
的结构和上述xml行一样。
请问怎么实现!
请高手指点!
如果xml中没有BOOKID(自动从一往上编号) 而导入到Oracle里时 想出现BOOKID这列 并自动编号 该怎么实现?
xml如下:
<?xml version="1.0" ?>
- <ROWDATA>
- <ROW>
<C0>1</C0>
<BOOKID>3</BOOKID>
<WAREHOUSENAME>馆藏标准</WAREHOUSENAME>
<ISBN>333</ISBN>
<BOOKINDEX>333</BOOKINDEX>
<BOOKNAME>333</BOOKNAME>
<BOOKTYPENUM>333</BOOKTYPENUM>
<AUTHOR>333</AUTHOR>
<TRANSLATOR>333</TRANSLATOR>
<PUBHOUSE>333</PUBHOUSE>
<PUBLISHPLACE>333</PUBLISHPLACE>
<PUBLISHDATE>333</PUBLISHDATE>
<PRICE />
<BOOKINDATE>333</BOOKINDATE>
<BOOKINTIME>333</BOOKINTIME>
<SERIALNUM>333</SERIALNUM>
<REMAINNUM>4</REMAINNUM>
<LENTNUM>0</LENTNUM>
<RESERVEDNUM>4</RESERVEDNUM>
<BOOKVERSION>333</BOOKVERSION>
<BOOKFORMAT>32</BOOKFORMAT>
<KEYWORDS>333</KEYWORDS>
<PAGECOUNT>333</PAGECOUNT>
<INTRODUCTION>333</INTRODUCTION>
<BOOKMEMO>333</BOOKMEMO>
<BOOKTYPE>333</BOOKTYPE>
<TYPENUM>333</TYPENUM>
<ISSUENUM />
<ID>0</ID>
<ISSUETITLE />
<ISSUEDATE />
<YEARISSUE />
<ORGANIZERS />
<AUTHORUNIT />
<ISISSUE>1</ISISSUE>
<ROWID>AAAIRyAAPAAAAiKAAA</ROWID>
</ROW>
- <ROW>
<C0>2</C0>
<BOOKID>4</BOOKID>
<WAREHOUSENAME>馆藏外刊</WAREHOUSENAME>
<ISBN />
<BOOKINDEX />
<BOOKNAME>444</BOOKNAME>
<BOOKTYPENUM>444</BOOKTYPENUM>
<AUTHOR>444</AUTHOR>
<TRANSLATOR />
<PUBHOUSE />
<PUBLISHPLACE />
<PUBLISHDATE />
<PRICE />
<BOOKINDATE />
<BOOKINTIME />
<SERIALNUM />
<REMAINNUM>4</REMAINNUM>
<LENTNUM>0</LENTNUM>
<RESERVEDNUM>4</RESERVEDNUM>
<BOOKVERSION />
<BOOKFORMAT>0</BOOKFORMAT>
<KEYWORDS>444</KEYWORDS>
<PAGECOUNT>444</PAGECOUNT>
<INTRODUCTION>444</INTRODUCTION>
<BOOKMEMO />
<BOOKTYPE />
<TYPENUM />
<ISSUENUM>444</ISSUENUM>
<ID>0</ID>
<ISSUETITLE>444</ISSUETITLE>
<ISSUEDATE>444</ISSUEDATE>
<YEARISSUE>444</YEARISSUE>
<ORGANIZERS>444</ORGANIZERS>
<AUTHORUNIT>444</AUTHORUNIT>
<ISISSUE>0</ISISSUE>
<ROWID>AAAIRyAAPAAAAiKAAB</ROWID>
</ROW>
</ROWDATA>行数不确定 (从其他表里导出的)
我想把如上的xml数据再导入到Oracle的一张表里面:BM_BOOK
BM_BOOK
的结构和上述xml行一样。
请问怎么实现!
请高手指点!
如果xml中没有BOOKID(自动从一往上编号) 而导入到Oracle里时 想出现BOOKID这列 并自动编号 该怎么实现?
public void Example2()
{
XElement root = new XElement("winners",
new XElement("winner",
new XElement("Name", "Barcelona"),
new XElement("Country", "Spania"),
new XElement("Year", 2006)
),
new XElement("winner",
new XElement("Name", "Liverpool"),
new XElement("Country", "Anglia"),
new XElement("Year", 2005)
),
new XElement("winner",
new XElement("Name", "FC Porto"),
new XElement("Country", "Portugalia"),
new XElement("Year", 2004)
),
new XElement("winner",
new XElement("Name", "AC Milan"),
new XElement("Country", "Italia"),
new XElement("Year", 2003)
),
new XElement("winner",
new XElement("Name", "Real Madrid"),
new XElement("Country", "Spania"),
new XElement("Year", 2002)
),
new XElement("winner",
new XElement("Name", "Bayern Munchen"),
new XElement("Country", "Germania"),
new XElement("Year", 2001)
),
new XElement("winner",
new XElement("Name", "Real Madrid"),
new XElement("Country", "Spania"),
new XElement("Year", 2000)
),
new XElement("winner",
new XElement("Name", "Manchester Utd."),
new XElement("Country", "Andlia"),
new XElement("Year", 1999)
),
new XElement("winner",
new XElement("Name", "Real Madrid"),
new XElement("Country", "Spania"),
new XElement("Year", 1998)
),
new XElement("winner",
new XElement("Name", "Borussia Dortmund"),
new XElement("Country", "Germania"),
new XElement("Year", 1997)
),
new XElement("winner",
new XElement("Name", "Juventus"),
new XElement("Country", "Italia"),
new XElement("Year", 1996)
),
new XElement("winner",
new XElement("Name", "AFC Ajax"),
new XElement("Country", "Olanda"),
new XElement("Year", 1995)
),
new XElement("winner",
new XElement("Name", "AC Milan"),
new XElement("Country", "Italia"),
new XElement("Year", 1994)
),
new XElement("winner",
new XElement("Name", "Olympique de Marseille"),
new XElement("Country", "Franta"),
new XElement("Year", 1993)
)
); Console.WriteLine(root.ToString());
}public void WinnersFromFile()
{
var result = from e in XElement.Load("winners.xml").Elements("winner")
select new Winner
{
Name = (string)e.Element("Name"),
Country = (string)e.Element("Country"),
Year = (int)e.Element("Year")
}; foreach (Winner w in result)
{
Console.WriteLine("{0} {1}, {2}",
w.Year, w.Name, w.Country);
}
}