🚀 go-pugleaf

������÷���ʹ��mssql
�Ұ�Java wrote:

> ���ھ����������Ҳ�����������£�����ֻ�÷�����̴���ˡ�
> 
> ������ݿ����ӵ�ʱ��������ʾ��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]