Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- * To change this license header, choose License Headers in Project Properties.
- * To change this template file, choose Tools | Templates
- * and open the template in the editor.
- */
- package flugCreativClasses;
- import static flugCreativClasses.Kunde_.benutzername;
- import flugCreativClasses.util.PaginationHelper;
- import java.sql.Statement;
- import javax.inject.Named;
- import javax.enterprise.context.SessionScoped;
- import java.io.Serializable;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.util.List;
- import javax.ejb.EJB;
- /**
- *
- * @author witzl
- */
- @Named(value = "loginController")
- @SessionScoped
- public class LoginController implements Serializable {
- String benutzer, passwort, benutzereingabe, passworteingabe;
- String Admin = "Admin";
- String Adminpass = "1234";
- boolean logintrue;
- @EJB
- private flugCreativClasses.KundeFacade db;
- private PaginationHelper pagination;
- private int selectedItemIndex;
- Kunde selected;
- Connection connection;
- Statement statement;
- ResultSet resultSet;
- String SQL;
- public LoginController() {
- }
- public List<Kunde> getAll() {
- return db.findAll();
- }
- public Kunde getBenutzer() {
- return db.find(benutzername);
- }
- public void setBenutzer(String benutzer) {
- this.benutzer = benutzer;
- }
- public String getPasswort() {
- return passwort;
- }
- public void setPasswort(String passwort) {
- this.passwort = passwort;
- }
- public String getBenutzereingabe() {
- return benutzereingabe;
- }
- public void setBenutzereingabe(String benutzereingabe) {
- this.benutzereingabe = benutzereingabe;
- }
- public String getPassworteingabe() {
- return passworteingabe;
- }
- public void setPassworteingabe(String passworteingabe) {
- this.passworteingabe = passworteingabe;
- }
- public KundeFacade getDb() {
- return db;
- }
- public void setDb(KundeFacade db) {
- this.db = db;
- }
- public int getSelectedItemIndex() {
- return selectedItemIndex;
- }
- public void setSelectedItemIndex(int selectedItemIndex) {
- this.selectedItemIndex = selectedItemIndex;
- }
- public Kunde getSelected() {
- return selected;
- }
- public void setSelected(Kunde selected) {
- this.selected = selected;
- }
- public boolean isLogintrue() {
- return logintrue;
- }
- public void setLogintrue(boolean logintrue) {
- this.logintrue = logintrue;
- }
- public void dbData(String userName) {
- try {
- Class.forName("com.mysql.jdbc.Driver");
- connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/flugdb", "root", "cbz");
- statement = (Statement) connection.createStatement();
- SQL = "Select * from kunde where benutzername like ('" + benutzereingabe + "')";
- resultSet = statement.executeQuery(SQL);
- resultSet.previous();
- benutzer = resultSet.getString(1);
- passwort = resultSet.getString(2);
- //System.out.println("Databaseconn established");
- } catch (Exception ex) {
- ex.printStackTrace();
- System.out.println("Exception Occured in the process :" + ex);
- }
- }
- public String pruefe() {
- dbData(benutzereingabe);
- if (benutzereingabe.equals(Admin) && passworteingabe.equals(Adminpass)) {
- return "adminportal";
- }
- if (benutzereingabe.equalsIgnoreCase(benutzer)) {
- if (passworteingabe.equals(passwort)) {
- return "kundenportal";
- } else {
- return "index";
- }
- } else {
- return "index";
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement