java +SQLServer 数据层配置

测试代码：

Java code

   
   

    
    
    
    package
    
     net.csdn.java.jdbc;


    
    import
    
     java.sql.Connection;

    
    import
    
     java.sql.DriverManager;

    
    import
    
     java.sql.PreparedStatement;

    
    import
    
     java.sql.ResultSet;

    
    import
    
     java.sql.SQLException;


    
    public
    
     
    
    class
    
     JdbcTest {

    
    
    public
    
     
    
    static
    
     
    
    void
    
     main(String[] args) {
        Connection con 
    
    =
    
     
    
    null
    
    ;
        PreparedStatement ps 
    
    =
    
     
    
    null
    
    ;
        ResultSet rs 
    
    =
    
     
    
    null
    
    ;
        
    
    try
    
     {
            con 
    
    =
    
     getConnection();
            String sql 
    
    =
    
     
    
    "
    
    SELECT id, username, password FROM user
    
    "
    
    ;
            ps 
    
    =
    
     con.prepareStatement(sql);
            rs 
    
    =
    
     ps.executeQuery();
            
    
    while
    
    (rs.next()) {
                System.out.printf(
    
    "
    
    %s, %s, %s%n
    
    "
    
    ,
                        rs.getString(
    
    "
    
    id
    
    "
    
    ),
                        rs.getString(
    
    "
    
    username
    
    "
    
    ),
                        rs.getString(
    
    "
    
    password
    
    "
    
    )
                    );
            }
        }
    
    catch
    
    (SQLException e) {
            e.printStackTrace();
        }
    
    finally
    
    {
            
    
    try
    
     {
                rs.close();
                ps.close();
                con.close();
            }
    
    catch
    
     (SQLException e) {
                e.printStackTrace();
            }
        }
    }
    
    
    
    private
    
     
    
    static
    
     Connection getConnection() 
    
    throws
    
     SQLException {
        Connection con 
    
    =
    
     
    
    null
    
    ;
        
    
    try
    
     {
            Class.forName(
    
    "
    
    com.microsoft.jdbc.sqlserver.SQLServerDriver
    
    "
    
    );
            
    
    //
    
     url 中最后的databasename=后换成你的数据库
    
    

    
                String url 
    
    =
    
     
    
    "
    
    jdbc:microsoft:sqlserver://localhost:1433;databasename=YourDatabaseName
    
    "
    
    ;
            String username 
    
    =
    
     
    
    "
    
    sa
    
    "
    
    ;
            String password 
    
    =
    
     
    
    ""
    
    ;
            con 
    
    =
    
     DriverManager.getConnection(url, username, password);
        }
    
    catch
    
    (ClassNotFoundException e) {
            e.printStackTrace();
        }
        
    
    return
    
     con;
    }
}