Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package vehicle_package;
- import java.io.Serializable;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.sql.SQLException.*;
- import java.util.ArrayList;
- import java.util.List;
- import javax.faces.bean.ManagedBean;
- import javax.faces.bean.SessionScoped;
- @ManagedBean(name = "category")
- @SessionScoped
- public class DatabaseConnection {
- private Connection conn;
- public DatabaseConnection() {
- super();
- }
- public List<Category> getCategoriesList() throws SQLException{
- DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
- conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.20.22:1521:FLEETGAL", "OF_OWNER", "OFO");
- conn.setAutoCommit(false);
- Statement statement = conn.createStatement();
- ResultSet resultSet =
- statement.executeQuery(
- "SELECT vo_vehicle_category_id, name, graphical_symbol, max_speed, lm_comment " +
- "FROM vo_vehicle_category");
- List<Category> categoriesList = new ArrayList<Category>();
- while (resultSet.next()) {
- categoriesList.add(new Category(resultSet.getInt("vo_vehicle_category_id"),
- resultSet.getString("name"),
- resultSet.getString("graphical_symbol"),
- resultSet.getShort("max_speed"),
- resultSet.getString("lm_comment")));
- }
- return categoriesList;
- }
- }
Add Comment
Please, Sign In to add comment