Untitled

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"
  xmlns:f="http://java.sun.com/jsf/core"
  xmlns:h="http://java.sun.com/jsf/html">    <h:head>
  <h:outputStylesheet library="css" name="styles.css"/>
  <title>#{msgs.pageTitle}</title>    </h:head>    <h:body>
  <h:form>
     <h:dataTable value="#{customerBean.all}" var="customer"
                  styleClass="customers" headerClass="customersHeader"
                  columnClasses="name, text">
        <h:column>
           <f:facet name="header">#{msgs.customerIdHeader}</f:facet>
           #{customer.id}
        </h:column>
        <h:column>
           <f:facet name="header">#{msgs.NDOKHeader}</f:facet>
           #{customer.NDOK}
        </h:column>
                     <h:column>
           <f:facet name="header">#{msgs.SODRABHeader}</f:facet>
           #{customer.SODRAB}
        </h:column>
     </h:dataTable>
  </h:form>    </h:body> </html>

<installation directory>sqljdbc_<version><language>sqljdbc.jar
<installation directory>sqljdbc_<version><language>sqljdbc4.jar
<installation directory>sqljdbc_<version><language>sqljdbc41.jar
<installation directory>sqljdbc_<version><language>sqljdbc42.jar

CLASSPATH =.;C:Program FilesMicrosoft JDBC Driver 6.0 for SQL Serversqljdbc_4.2enusqljdbc42.jar

CLASSPATH =.:/home/usr1/mssqlserverjdbc/Driver/sqljdbc_4.2/enu/sqljdbc42.jar

mvn install:install-file -Dfile=<путь до джарки с жрайвером без угловых скобочек> -DgroupId=com.microsoft.sqlserver
    -DartifactId=com.microsoft.sqlserver.jdbc.SQLServerDriver -Dversion=4.2 -Dpackaging=jar

<dependencies>
    <dependency>
        <groupId>com.microsoft.sqlserver</groupId>
        <artifactId>com.microsoft.sqlserver.jdbc.SQLServerDriver</artifactId>
        <version>4.2</version>
    </dependency>
</dependencies>

public class Customer {

    private Integer id;
    private String NDOK;
    private String SODRAB;

    public Customer() {
    }

    public Customer(Integer id, String NDOK, String SODRAB) {
        this.id = id;
        this.NDOK = NDOK;
        this.SODRAB = SODRAB;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getNDOK() {
        return NDOK;
    }

    public void setNDOK(String NDOK) {
        this.NDOK = NDOK;
    }

    public String getSODRAB() {
        return SODRAB;
    }

    public void setSODRAB(String SODRAB) {
        this.SODRAB = SODRAB;
    }
}

import java.io.Serializable;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.SessionScoped;

@ManagedBean
@SessionScoped
public class CustomerBean implements Serializable {

    private static final long serialVersionUID = 6081417964063918994L;

    public List<Customer> getCustomers() throws ClassNotFoundException, SQLException {

        Connection connect = null;

        //Привел пример, как указать еще и в url, это необязательно
        String url = "jdbc:sqlserver://localhost:1433;" +
     "databaseName=CustomerDatabase;user=user;password=password";

        String username = "user";
        String password = "password";

        try {

            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

            connect = DriverManager.getConnection(url, username, password);
            // System.out.println("Connection established"+connect);

        } catch (SQLException ex) {
            System.out.println("in exec");
            System.out.println(ex.getMessage());
        }

        List<Customer> customers = new ArrayList<Customer>();
        PreparedStatement pstmt = connect
                .prepareStatement("select id, NDOK, SODRAB from Customer");
        ResultSet rs = pstmt.executeQuery();

        while (rs.next()) {

            Customer customer = new Customer();
            customer.setId(rs.getInt("id"));
            customer.setNDOK(rs.getString("NDOK"));
            customer.setSODRAB(rs.getString("SODRAB"));

            customers.add(customer);

        }

        // close resources
        rs.close();
        pstmt.close();
        connect.close();

        return customers;

    }

}