Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Derby client driver

  • 24-03-2015 06:32PM
    #1
    Closed Accounts Posts: 431 ✭✭


    So i'm working on an application and i'm having problems installing the derby driver can anyone help me out here's my code so far.
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    /**
     *
     * @author user
     */
    public class DBConnect {
    
        /**
         * @param args the command line arguments
         */
        public static void main(String[] args) {
            // TODO code application logic here
        try {
            
            String host = "Jdbc:derby://localhost:1527/admin1";
            String uName = "admin1";
            String uPass = "admin1";
            Connection con = DriverManager.getConnection(host, uName, uPass);
            
            Statement stmt = con.createStatement();
            String sql = "SELECT * FROM Workers";
            ResultSet rs = stmt.executeQuery(sql);
            
        while (rs.next()) {
            rs.next();
            int id_col = rs.getInt("ID");
            String first_name = rs.getString("First_Name");
            String last_name = rs.getString("Last_Name");
            String job = rs.getString("Job_Title");
            
            String p = id_col + " " + first_name + " " + last_name + " " +job;
            System.out.println(p);
        }
        }
        catch (SQLException err) {
            System.out.println( err.getMessage());
        }
        }
        
    }
        
    

    How exactly do i attach the driver?


Comments

Advertisement