sql2000test.java

来自「在java中如何实现读取sql2000中的表中的记录信息」· Java 代码 · 共 39 行

package com.test;
import java.sql.*;
public class sql2000test { 
    public static void main(String[] args) { 

        ResultSet result;
        String dbURL;
        dbURL= "jdbc:sqlserver://localhost:1433;DatabaseName=shopping";
        
    try { 
        
    	Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
 
        Connection con = DriverManager.getConnection(dbURL,"sa","");
    
        System.out.println("建立连接成功!"); 
    
        Statement stat=con.createStatement();
    
        result=stat.executeQuery("SELECT *  FROM  users");

        System.out.println("----------------------------------------------------------");
        
            int i=0;
            while(result.next())
            {
                i++;
                System.out.println(String.valueOf(i)+"  "+result.getString(1)+"  "+result.getString(2)+"  "+result.getString(3));
                
            }
        System.out.println("----------------------------------------------------------");
            
        }
    catch (Exception e){ 
        e.printStackTrace(); 
        }
    }
}