Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*
- public class PostgresjbcFlugzeug
- {
- public static void main(String[] args) throws ClassNotFoundException, SQLException
- {
- Class.forName("org.postgresql.Driver")
- String url="jdbc:postgresql://localhost/Faststrike";
- Connection con = DriverManager.getConnection(url,"Fasti","1337");
- }
- boolean logIn=false;
- boolean exit=false;
- int KNR=0;
- int menue;
- String Kundennummer_search="select * from Kunden where Kundennummer=?";
- String Kundennummer_Insert="insert into Passagier (?,?,?)";
- String FlugSuchen="select datum,v1.Flugnummer,v1.Startflughafen,v1.Zielflughafen,v1.Ziel from Flugverbindung v1,Flughafen f1,abflug where v1.zielflughafen=f1.IATA like ?% or f1.Zielflughafen like ?%;"
- while(menue != true ){
- Scanner M=new Scanner(System.in);
- menue=M.nextInt();
- switch (menue) {
- case 1: PreparedStatement stmtKnr= cn.prepareStatement(Kundennummer_search);
- Scanner S=new Scanner(System.in);
- KNR=S.nextInt();
- stmtKnr.setInt(1,KNR);
- S.close();
- ResultSet rset = stmtKnr.executeQuery();
- if(rset.next()){logIn=true;rset.close();}
- else
- {
- PreparedStatement stmtInKunde=cn.prepareStatement(Kundennummer_Insert);
- Scanner s1 = new Scanner(System.in);
- System.out.print("Ihr Nachname eingeben: ");
- String NN = s1.next();
- System.out.print("Ihr Vorname eingeben: ");
- String VN = s1.next();
- System.out.print("Ihre Kundennummer eingeben: ");
- KNR= s1.nextint();
- stmtInKunde.setString(1,NN);
- stmtInKunde.setString(2,VN);
- stmtInKunde.setString(3,KNR);
- logIn=true;
- stmtInKunde.executeUpdate();
- s1.close();
- rset.close;
- }break;
- case 2: if(logIn=true){
- }
- else{System.out.print("Sie sind als kein Kunde angemeldet bitte ers anmelden");};
- break;
- case 3: ;
- break;
- case 4: ;
- break;
- default: ;
- break;
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement