Guest User

Untitled

a guest
Dec 10th, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.67 KB | None | 0 0
  1. package vehicle_package;
  2.  
  3. import java.io.Serializable;
  4.  
  5. import java.sql.Connection;
  6. import java.sql.DriverManager;
  7. import java.sql.ResultSet;
  8. import java.sql.SQLException;
  9. import java.sql.Statement;
  10. import java.sql.SQLException.*;
  11.  
  12. import java.util.ArrayList;
  13. import java.util.List;
  14.  
  15. import javax.faces.bean.ManagedBean;
  16. import javax.faces.bean.SessionScoped;
  17.  
  18.  
  19. @ManagedBean(name = "category")
  20. @SessionScoped
  21. public class DatabaseConnection  {
  22.     private Connection conn;
  23.    
  24.     public DatabaseConnection() {
  25.         super();
  26.     }
  27.    
  28.     public List<Category> getCategoriesList() throws SQLException{
  29.  
  30.         DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
  31.         conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.20.22:1521:FLEETGAL", "OF_OWNER", "OFO");
  32.  
  33.         conn.setAutoCommit(false);
  34.        
  35.         Statement statement = conn.createStatement();
  36.         ResultSet resultSet =
  37.             statement.executeQuery(
  38.                 "SELECT vo_vehicle_category_id, name, graphical_symbol, max_speed, lm_comment " +
  39.                 "FROM vo_vehicle_category");
  40.      
  41.         List<Category> categoriesList = new ArrayList<Category>();
  42.    
  43.         while (resultSet.next()) {
  44.             categoriesList.add(new Category(resultSet.getInt("vo_vehicle_category_id"),
  45.                                         resultSet.getString("name"),
  46.                                         resultSet.getString("graphical_symbol"),
  47.                                         resultSet.getShort("max_speed"),
  48.                                         resultSet.getString("lm_comment")));
  49.         }
  50.  
  51.         return categoriesList;
  52.     }    
  53.  }
Add Comment
Please, Sign In to add comment