📄 583712.xml
字号:
<?xml version='1.0' encoding='GB2312'?>
<?xml-stylesheet type='text/xsl' href='../csdn.xsl'?>
<Topic>
<Issue>
<PostUserNickName>prewind</PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>111</credit>
<TopicId>583712</TopicId>
<TopicName>紧急求救！能通过jdbc怎样连接sqlsever 然后通过 for xml 关键字得到xml流吗？</TopicName>
<PostUserId>33027</PostUserId>
<PostUserName>ctrlpower</PostUserName>
<RoomName>JSP</RoomName>
<ReplyNum>8</ReplyNum>
<PostDateTime>2002-3-18 15:24:56</PostDateTime>
<Point>70</Point>
<ReadNum>0</ReadNum>
<RoomId>28</RoomId>
<EndState>2</EndState>
<Content>我想通过jdbc 连接sqlserver 2000 数据库 ，我已连接成功。
 
但我现在想知道能不能通过该jdbc连接sqlserver 2000 数据库，得到 xml数据。就是sql server2000支持的xml输出。
我发现Statement 的方法里面没有返回伟String 的方法！
紧急求救！</Content>
</Issue>
<Replys>
<Reply>
<PostUserNickName>小玉米</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>100</credit>
<ReplyID>3895968</ReplyID>
<TopicID>583712</TopicID>
<PostUserId>111242</PostUserId>
<PostUserName>whd11808</PostUserName>
<Point>0</Point>
<Content>利用ORACLE的包！
下边是例子
public static Collection queryOdbc( String strSql,String className )
    {
        QueryXML queryXML = new QueryXML();
        String xmlString = "";
        Collection result = null;
        Connection conn = null;
        ConnectionManager c = new ConnectionManager();
        conn = c.getOdbcConnection();
        try
        {
            OracleXMLQuery qry = new OracleXMLQuery (conn, strSql);
            qry.setEncoding("GBK");
            xmlString = qry.getXMLString();
            System.out.println(xmlString);
            queryXML.objectXML( xmlString,className );
            result = queryXML.getResult();
        }
        catch (Exception e)
        {
            System.out.println("queryXML error in DbOption..."+e.toString());
        }
        finally
        {
            try
            {
                conn.close();
            }
            catch (SQLException e)
            {
                System.out.println("query method close connection error in DbOption..."+e.toString());
            }
        }</Content>
<PostDateTime>2002-3-19 19:05:46</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>sorsir</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>97</credit>
<ReplyID>3901324</ReplyID>
<TopicID>583712</TopicID>
<PostUserId>112511</PostUserId>
<PostUserName>sorsir</PostUserName>
<Point>0</Point>
<Content>Oracle的包能用于SQL Server的吗?</Content>
<PostDateTime>2002-3-20 10:02:34</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>小玉米</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>100</credit>
<ReplyID>3905342</ReplyID>
<TopicID>583712</TopicID>
<PostUserId>111242</PostUserId>
<PostUserName>whd11808</PostUserName>
<Point>0</Point>
<Content>呵呵，和数据库没有关系的。ORACLE包是JAVA程序里用的，都可以了</Content>
<PostDateTime>2002-3-20 13:33:23</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>prewind</PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>111</credit>
<ReplyID>3915251</ReplyID>
<TopicID>583712</TopicID>
<PostUserId>33027</PostUserId>
<PostUserName>ctrlpower</PostUserName>
<Point>0</Point>
<Content>这个包从那儿能得到阿！
你能发给我一份吗！
wind@digisuper.com
还有别的方法吗？
请继续关注</Content>
<PostDateTime>2002-3-21 8:36:31</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>小玉米</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>100</credit>
<ReplyID>3918338</ReplyID>
<TopicID>583712</TopicID>
<PostUserId>111242</PostUserId>
<PostUserName>whd11808</PostUserName>
<Point>70</Point>
<Content>你有ORACEL么？在oracle\ora81\jlib\xmlparserv2.jar
</Content>
<PostDateTime>2002-3-21 11:09:17</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>小玉米</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>100</credit>
<ReplyID>3918361</ReplyID>
<TopicID>583712</TopicID>
<PostUserId>111242</PostUserId>
<PostUserName>whd11808</PostUserName>
<Point>0</Point>
<Content>我给你发了！</Content>
<PostDateTime>2002-3-21 11:09:37</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>马可</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<ReplyID>3933060</ReplyID>
<TopicID>583712</TopicID>
<PostUserId>213498</PostUserId>
<PostUserName>yourmarco</PostUserName>
<Point>0</Point>
<Content>whd11808(小玉米):
 我也要一份，谢谢！
yourmake@163.net</Content>
<PostDateTime>2002-3-22 13:26:55</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>prewind</PostUserNickName>
<rank>三级(初级)</rank>
<ranknum>user3</ranknum>
<credit>111</credit>
<ReplyID>3959768</ReplyID>
<TopicID>583712</TopicID>
<PostUserId>33027</PostUserId>
<PostUserName>ctrlpower</PostUserName>
<Point>0</Point>
<Content>我好像没有收到，不过还是先结贴吧！</Content>
<PostDateTime>2002-3-25 10:14:36</PostDateTime>
</Reply>
</Replys>
</Topic>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -