Using move next, previous, first and last t shift through the database using in GUI

[Rodney Ibanez]

Hi! Please Help! I'm trying to create a program wherein the user can login using his credentials saved in a database. Upon entering, he should be able to browse through the database using the move next, previous, first and last buttons. I got some codes and was able to make it work in Netbeans using the derby but I can't get it to work using Eclipse and Mysql (which both I prefer). Please Help. THANKS.

JFrame frame = new JFrame("LOGIN");
	JPanel panel = new JPanel(new FlowLayout());
	
	JTextField txtUserName = new JTextField(10);
	JTextField txtUserPass = new JTextField(10);
	JLabel lbl1 = new JLabel("User Name: ");
	JLabel lbl2 = new JLabel("Password: ");
	JButton btnLogin = new JButton("Login");
	JButton btnExit = new JButton("Exit");
	
	JLabel lbl12 = new JLabel("Student ID:");
	JLabel lbl22 = new JLabel("Full Name:");
	JLabel lbl3 = new JLabel("Account Type:");
	JLabel lbl4 = new JLabel("Prelim Grade:");
	JTextField txtFullName = new JTextField(15);
	JTextField txtID = new JTextField(10);
	JTextField txtPrelim = new JTextField(10);
	JTextField txtAcct = new JTextField(10);
	JButton btnDetails = new JButton("Details");
	JButton btnNext = new JButton("Next");
	JButton btnPrev = new JButton("Previous");
	
	private String inputName, inputPass;
	public static String inputAcct;
	boolean isFalse = false;
	int MAX_LEN = 10;
	public static int inputID;
	boolean isSame = false;
	
	public void LoginGUI() {
		frame.setSize(245, 150);
		frame.setVisible(true);
		frame.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);
		frame.setLocationRelativeTo(null);
		frame.setResizable(false);
		frame.add(panel);
		
		panel.add(lbl1);
		panel.add(txtUserName);
		panel.add(lbl2);
		panel.add(txtUserPass);
		panel.add(btnLogin);
		panel.add(btnExit);
		
// #############################################################################
		txtUserName.addKeyListener(new KeyListener() {
			
			public void keyTyped(KeyEvent e) {
				if(txtUserName.getText().length() > MAX_LEN){
					txtUserName.setText(txtUserName.getText().substring(0, MAX_LEN));
				}
			}
			public void keyReleased(KeyEvent e) {}
			public void keyPressed(KeyEvent e) {}
		});
// #############################################################################
		btnLogin.addActionListener(new ActionListener() {

			public void actionPerformed(ActionEvent arg0) {
				Login();
			}
		});
// #############################################################################
		btnExit.addActionListener(new ActionListener() {

			public void actionPerformed(ActionEvent arg0) {
				System.exit(1);
			}
		});
	}
// #############################################################################
	
	public void Login() {
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/gradingsystem", "root", "");
			
			Statement stm = con.createStatement();
			String sql = "SELECT * from logindetails";
			stm.executeQuery(sql);
			ResultSet rs = stm.getResultSet();
			
			if(rs != null && !isSame){
				while(rs.next()){
					inputName = rs.getString("userName");
					inputPass = rs.getString("userPass");
					inputAcct = rs.getString("acctType");
					inputID = rs.getInt("ID");
						if(inputName.equals(txtUserName.getText()) && inputPass.equals(txtUserPass.getText())){
							JOptionPane.showMessageDialog(null, "Access Granted.", "ALERT", 1);
							Summary();
							isSame = true;
							txtUserName.setText("");
							txtUserPass.setText("");
						}
				}
				if(!isSame){
					JOptionPane.showMessageDialog(null,  "Acces Denied!", "ALERT", 0);
					txtUserName.setText("");
					txtUserPass.setText("");
				}
			}
		} catch (ClassNotFoundException | SQLException err) {
			err.printStackTrace();
		}
		
	}
	
	public void Summary(){

		frame.setSize(200, 200);
		frame.setVisible(true);
		frame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		frame.setResizable(false);
		frame.setLocationRelativeTo(null);
		frame.getContentPane().removeAll();
		JPanel panel2 = new JPanel(new GridLayout(6,2));
		frame.add(panel2);
		frame.validate();
		frame.setTitle("SUMMARY");
		
		panel2.add(lbl3);
		panel2.add(txtAcct);
		panel2.add(lbl12);
		panel2.add(txtID);
		panel2.add(lbl22);
		panel2.add(txtFullName);
		panel2.add(lbl4);
		panel2.add(txtPrelim);
		panel2.add(btnDetails);
		panel2.add(btnNext);
		panel2.add(btnPrev);
			
		txtAcct.setText(inputAcct);
		txtID.setText(Integer.toString(inputID));

		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/gradingsystem", "root", "");
			Statement stm = con.createStatement();
			String sql = "SELECT FullName, PrelimGrade from gradesummary where ID='" + inputID + "' ";
			stm.executeQuery(sql);
			ResultSet rs = stm.getResultSet();
			rs.next();
			txtFullName.setText(rs.getString("FullName"));
			txtPrelim.setText(rs.getString("PrelimGrade"));
			
			
		} catch (ClassNotFoundException | SQLException e) {
			e.printStackTrace();
		}
		
// ############################################################################# 
		btnDetails.addActionListener(new ActionListener() {

			public void actionPerformed(ActionEvent arg0) {
				DetailedClass detailed = new DetailedClass();
				detailed.DetailedGUI();
			}
		});
// #############################################################################
		btnNext.addActionListener(new ActionListener() {
		
			public void actionPerformed(ActionEvent e) {
				Object obj = e.getSource();
				Connection con;
				ResultSet rs;
				Statement stm;
				
					try {
						Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
						con = DriverManager.getConnection("jdbc:mysql://localhost:3306/gradingsystem", "root", "");
						stm = con.createStatement();
						String sql = "SELECT * from gradesummary";
						stm.executeQuery(sql);
						rs = stm.getResultSet();
						
						if(rs.next()){
						int id_col = rs.getInt("ID");
						String id = Integer.toString(id_col);
						String name = rs.getString("FullName");
						double grade_col = rs.getDouble("PrelimGrade");
						String grade = Double.toString(grade_col);
						
						txtID.setText(id);
						txtFullName.setText(name);
						txtPrelim.setText(grade);	
						} else {
							rs.previous();
						}
					} catch (ClassNotFoundException | SQLException e1) {
						// TODO Auto-generated catch block
						e1.printStackTrace();
					}
			}
		});
// #############################################################################
		btnPrev.addActionListener(new ActionListener() {

			public void actionPerformed(ActionEvent arg0) {
				Object obj = arg0.getSource();
				Connection con;
				ResultSet rs;
				Statement stm;
				
					try {
						Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
						con = DriverManager.getConnection("jdbc:mysql://localhost:3306/gradingsystem", "root", "");
						stm = con.createStatement();
						String sql = "SELECT * from gradesummary";
						stm.executeQuery(sql);
						rs = stm.getResultSet();
						
						if(rs.previous()){
						int id_col = rs.getInt("ID");
						String id = Integer.toString(id_col);
						String name = rs.getString("FullName");
						double grade_col = rs.getDouble("PrelimGrade");
						String grade = Double.toString(grade_col);
						
						txtID.setText(id);
						txtFullName.setText(name);
						txtPrelim.setText(grade);	
						} else {
							rs.next();
						}
					} catch (ClassNotFoundException | SQLException e1) {
						// TODO Auto-generated catch block
						e1.printStackTrace();
					}
			}
		});
	}

[Rodney Ibanez]

Never mind this guys. I figured it out already ^_^.. I just needed to create another query.