vildt

package com.company;
import java.sql.*;
/**
 * Created by Alex on 28-11-2016.
 */
public class network {
    private static final String mysql_user       = "root";
    private static final String mysql_pass       = "ezlife";
    private static final int    mysql_port       = 3306;
    private static final String mysql_server     = "jdbc:mysql://localhost:3306/test";
    private static Connection   mysql_connection = null;
    private static Statement    mysql_statement  = null;

    static int init(){
        try{
            DriverManager.registerDriver(new com.mysql.jdbc.Driver());
            mysql_connection = DriverManager.getConnection(mysql_server, mysql_user, mysql_pass);
            return 1;

        }catch (Exception e){
            System.out.println(e);
            return -1;
        }
    }

    public int insert_data(String sql){
        try{
            PreparedStatement ps = mysql_connection.prepareStatement(sql);
            ps.execute();
            return -1;
        }catch (Exception e){
            System.out.println(e);
            return -1;
        }
    }

    public int set_data(String sql){
        try {
            PreparedStatement ps = mysql_connection.prepareStatement(sql);
            ps.executeUpdate();
            return 1;
        }catch (Exception e){
            System.out.println(e);
            return -1;
        }
    }

    public ResultSet get_data(String sql){
        try{
            mysql_statement = mysql_connection.createStatement();
            return mysql_statement.executeQuery(sql);
        }catch (Exception e){
            System.out.println(e);
            ResultSet empty = null;
            return empty;
        }
    }

    public int close(){
        try{
            mysql_connection.close();
            return 1;
        }catch (Exception e){
            System.out.println(e);
            return -1;
        }
     }
}















package com.company;

import java.sql.*;

/**
 * Created by kasperolsen on 29/11/2016.
 */
public class ConnectSQL {

    private static final String USER = "grp44";
    private static final String PASS = "grp42";
    private static final String DB_URL = "jdbc:mysql://mysql.itu.dk/Cinema_grp44";
    private static Connection connection;
    //private static Statement statement  = null;

    static void connect(){

        try{
            DriverManager.registerDriver(new com.mysql.jdbc.Driver());
            connection = DriverManager.getConnection(DB_URL, USER, PASS);

            System.out.println("Connected");

        }catch (Exception e){
            System.out.println(e);
        }
    }

    static void close(){
        try{
            connection.close();
            System.out.println("Closed");
        }catch(Exception e){
            e.printStackTrace();
        }
    }
}