try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException ex) {
            System.out.println(ex);
        }
        try {
            Connection con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3311/Books","root","root");
            Statement statement = con.createStatement();
            String sql = "insert into student(studid,fname,lname,course,yr) value ('"+txtID.getText()+"', '"+txtFName.getText()+"', '"+txtLName.getText()+"', '"+txtCourse.getText()+"', "+txtYear.getText()+")";
            statement.execute(sql);
        } catch (SQLException ex) {
            System.out.println(ex);
        }