🚀 go-pugleaf

���ھ����������Ҳ�����������£�����ֻ�÷�����̴���ˡ�

������ݿ����ӵ�ʱ��������ʾ��ClassNotFoundException:com.microsoft.sqlserver.
                                                      SQLServerDriver
����Ӧ������Ϊû�����ú����ԭ��ģ��ҵ�Դ����ֻ��һ���ܼ򵥵IJ��Գ���
import java.sql.*;
import java.text.DateFormat;


public class Connectbase {
    public static void main(String[] args ) {
        String jdbcDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
        String dbURL = 
"jdbc:microsoft:sqlserver://127.0.0.1:1433;DataBaseName = warehouse";
        Connection dbConn = null;
        try {
            Class.forName(jdbcDriver).newInstance();
            dbConn = DriverManager.getConnection(dbURL);
            Statement stmt = dbConn.createStatement();
            
            ResultSet rs = stmt.executeQuery("select * from Product"); 
            
            while(rs.next()) {
                System.out.println(rs.getString(1));
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            try {               
                if (dbConn != null) {
                    dbConn.close();
                }
            } catch (Exception e1) {
                e1.printStackTrace();
            }
        }
    }
}

�Dz���������⣿�������ô��ģ��һ��Dz����ף�

Thx
     
--
�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 202.192.159.41]