Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- Connection conn;
- String dbuser = "root";
- String dbpassw = "";
- String databasename = "logindb";
- String url = "jdbc:mysql://localhost/" + databasename;
- Class.forName("com.mysql.jdbc.Driver");
- conn = DriverManager.getConnection(url, dbuser, dbpassw);
- Statement st = conn.createStatement();
- String uid = TxtUser.getText().toString();
- String passw = TxtPass.getText().toString();
- ResultSet res = st.executeQuery(
- "SELECT User, saldo FROM loginacc where User='" + uid + "' and Pass='" + passw + "'");
- if (res.next()) {
- JOptionPane.showMessageDialog(null, "Login Sucessfull.");
- lblUser_1.setText(res.getString("User"));
- Date date = new Date();
- lblDate.setText(date.toString());
- lblBank.setText(res.getString("saldo"));
- card.show(frame.getContentPane(), "MenuPanel");
- } else {
- JOptionPane.showMessageDialog(null, "Invalid Login.");
- }
- if ((TxtUser.getText().equals(uid)) && (TxtPass.getText().equals(passw))) {
- } else {
- }
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- JOptionPane.showMessageDialog(null, e.getMessage());
- } catch (SQLException e) {
- JOptionPane.showMessageDialog(null, "Sql Error");
- }
- }
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement