Modulzáró

package Modulzaro;

import java.io.*;
import java.util.Scanner;
import java.sql.*;

public class Modulzaro{
private String vnev;
private String knev;
private int id;
private int kor;

public Modulzaro(String vnev, String knev, int id,  int kor){
this.vnev = vnev;
this.knev = knev;
this.id = id;
this.kor = kor;
}

public void setVnev(String vnev){
this.vnev = vnev;
}

public String getVnev(){
return vnev;
}

public void setKnev(String knev){
this.knev = knev;
}

public String getKnev(){
return knev;
}

public void setId(int id){
this.id = id;
}

public int getId(){
return id;
}

public void setKor(int kor){
this.kor = kor;
}

public int getKor(){
return kor;
}

public static void main(String args[]) throws Exception{

Modulzaro obj1 = new Modulzaro ("Vnev", "Knev", 0, 0);
int tanuloszam;
int i = 0;
Scanner in = new Scanner(System.in);

Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/emp","root","");

PreparedStatement ps=con.prepareStatement("insert into modulzaro values(?,?,?,?)");
BufferedReader br=new BufferedReader(new InputStreamReader(System.in));

System.out.println("Kérem adja meg a csoport tanulóianak a számát: ");
tanuloszam = in.nextInt();

while( i < tanuloszam){
System.out.println("Írd be a vezetéknevet:");
String vnev=br.readLine();
System.out.println("Írd be a keresztnevet:");
String knev=br.readLine();
System.out.println("Írd be a tanuló azonosítót:");
int id=Integer.parseInt(br.readLine());
System.out.println("Írd be a tanuló korát:");
int kor=Integer.parseInt(br.readLine());
ps.setString(1,vnev);
ps.setString(2,knev);
ps.setInt(3,id);
ps.setInt(4,kor);
int a=ps.executeUpdate();
i++;
}
System.out.println(tanuloszam+" Személy felvétele megtörtént");

    try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection myConn=DriverManager.getConnection("jdbc:mysql://localhost:3306/emp","root","");
Statement stmt=myConn.createStatement();
ResultSet rs=stmt.executeQuery("select * from modulzaro");

System.out.println("Az adatbázisba felvitt személyek neve:");
while(rs.next())
{
System.out.println(rs.getString("vnev")+" "+rs.getString(2));
}
}
catch(SQLException e)
{
System.out.println(e);
}
catch(Exception e)
{
System.out.println(e);
}

br.close();
in.close();
con.close();
}}