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

Derby client driver

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