Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
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.

Derby client driver

  • 24-03-2015 07: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