public class DataBase{

    private Connection connection = null;

        private String mysqlUrl;
        private String mysqlUser;
        private String mysqlPass;

    public DataBase() {
        mysqlUrl = "jdbc:mysql://localhost:3306/denemedb";
        mysqlUser = "root";
        mysqlPass = "";
    }

    private void connectToDatabase() {
        try {
            if(connection != null){
                        if(connection.isClosed() == false){
                        return;
                    }
            }
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection(this.mysqlUrl, this.mysqlUser, this.mysqlPass);
        } catch(Exception e) {
            System.err.println("Exception: " + e.getMessage());
        }
    }

    private void closeTheDatabaseConnection(){
        if (connection != null){
                    try{
                        connection.close ();
                        System.out.println ("Database connection terminated");
                    }catch (Exception e) { /* ignore close errors */ }
            }
    }

    public int getDenemeInfo(String id) {
        connectToDatabase();
        int deneme = 0;
        Statement statement = null;
        ResultSet resultset = null;

        try {
            statement = connection.createStatement();
            resultset = statement.executeQuery("SELECT deneme FROM table1 WHERE denemeId='"+id+"'");
            while(resultset.next()){
                deneme = resultset.getInt("deneme");
            }
            resultset.close();
            statement.close();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        closeTheDatabaseConnection();
        return deneme;
    }