Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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
- 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"));
- customer.add(customer);
- }
- // close resources
- rs.close();
- pstmt.close();
- connect.close();
- return customers;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement