Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private List<BookModel> select(String[] params){
- final String JDBC_DRIVER="com.mysql.jdbc.Driver";
- final String DB_URL="jdbc:mysql://localhost:3306/sys";
- final String USER = "admin";
- final String PASS = "1234";
- Connection conn=null;
- Statement stmt=null;
- List<BookModel> resultSet = new ArrayList<BookModel>();
- try{
- Class.forName(JDBC_DRIVER);
- conn = DriverManager.getConnection(DB_URL, USER, PASS);
- stmt = conn.createStatement();
- String sql;
- sql = "SELECT * FROM book";
- ResultSet rs = stmt.executeQuery(sql);
- while(rs.next()){
- BookModel nextBook = new BookModel();
- nextBook.isbn = rs.getString("isbn");
- nextBook.tytul = rs.getString("title");
- nextBook.autor = rs.getString("author");
- nextBook.wydawca = rs.getString("publisher");
- nextBook.data = rs.getString("date");
- resultSet.add(nextBook);
- }
- rs.close();
- stmt.close();
- conn.close();
- }catch(SQLException se){
- se.printStackTrace();
- }catch(Exception e){
- e.printStackTrace();
- }finally{
- try{
- if(stmt!=null)
- stmt.close();
- }catch(SQLException se2){
- }
- try{
- if(conn!=null)
- conn.close();
- }catch(SQLException se){
- se.printStackTrace();
- }
- }
- return resultSet;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement