JDBC: Lab 1

					
package com.annedirkse;


import java.sql.Connection;
import java.sql.DriverManager;

public class ConnectionManager {

    private static ConnectionManager mInstance;

    private ConnectionManager() {
     try {
      Class.forName("org.gjt.mm.mysql.Driver").newInstance();
      // newInstance() is Required for mysql   
     }
     catch(ClassNotFoundException e) {
       e.printStackTrace();
     }
     catch(Exception e) {
       e.printStackTrace();
     }
     }


    public static ConnectionManager getInstance() {
        if (mInstance == null) {
            mInstance = new ConnectionManager();
        }
        return mInstance;
    }

    public Connection getConnection() {
        Connection con = null;
        try {
          con = DriverManager.getConnection("jdbc:mysql://mysql.kattare.com/guruguides?user=dirkse-guruguide&password=guruguides");
        } catch (Exception e) {
            e.printStackTrace();
        }
        return con;
    }

    public static void main(String[] args) {
        new ConnectionManager().getConnection();
    }
}

/**
 * Created by IntelliJ IDEA.
 * User: Administrator
 * Date: Mar 7, 2003
 * Time: 7:53:32 AM
 * To change this template use Options | File Templates.
 */
package com.annedirkse;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;

public class UserManager {
    private static UserManager ourInstance;

    public synchronized static UserManager getInstance() {
        if (ourInstance == null) {
            ourInstance = new UserManager();
        }
        return ourInstance;
    }

    public boolean addUser(String username, String password) {
        ConnectionManager conMan = ConnectionManager.getInstance();
        String sql = "insert into users(username, password) values('"+username+"','"+password+"')";
        try {
          Connection con = conMan.getConnection();
          Statement state = con.createStatement();
            int i = state.executeUpdate(sql);
            if (i > 0) {
               return true;
            }
        }
        catch(SQLException e) {
            e.printStackTrace();
        }
        return false;
    }

    public boolean usernameExists(String username) {

      return true;
    }

    public boolean isValidLogin(String username, String password) {
      return false;
    }

    public static void main(String[] args) {
       UserManager.getInstance().addUser("user", "password");
    }

    private UserManager() {
    }
}