用JDBC的吗?
邮箱,我发给你。

解决方案 »

  1.   

    邮箱 [email protected]不仅仅是连接。使用jdbc
      

  2.   

    import java.sql.*;
    import com.microsoft.jdbc.sqlserver.*;public class YY{
    public static void main(String args[]){
    try{
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
        Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://.:1433","sa","123");
           Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
           String sql="SELECT * FROM test";
          
           ResultSet rs=stmt.executeQuery(sql);
                      rs.next();System.out.println(rs.getString(1));
    or
    //--------------------------------<?xml version="1.0" ?>
    <config>
            <drivername>com.microsoft.jdbc.sqlserver.SQLServerDriver</drivername>
            <connection>jdbc:microsoft:sqlserver://.:1433</connection>
            <user>sa</user>
            <password>123</password>
    </config>
    public class Initweb{
      private String xml;  private String drivername;
      private String connection;
      private String user;
      private String password;  public void setXml(String tablename){
        try{
          Class.forName(drivername);
          Connection conn = DriverManager.getConnection(connection,user,password);      String sql ="SELECT id,name FROM bcstnet.dbo."+tablename+" FOR XML RAW";      Statement stmt=conn.createStatement();
          ResultSet rs=stmt.executeQuery(sql);      xml="<?xml version=\"1.0\" encoding=\"gb2312\"?>";
          xml+="<root>";
          while(rs.next()) xml+=rs.getString(1);
      

  3.   

    [email protected]
    也给我一个,thanks