package gwt.registration.server;

import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class UserAdmin {
		private static Connection con = null;
		private final static String host = "asgard.swp2010.de";
		private final static String db = "db";
		private final static String user = "user";
		private final static String pw = "pw";

		public UserAdmin() throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException {
				if(con==null) {
					getClass().getClassLoader().loadClass("org.postgresql.Driver").newInstance();
					con = DriverManager.getConnection("jdbc:postgresql://"+host+"/"+db, user, pw);
				}
		}

		public boolean login(String nickname, String pw) throws SQLException {
				Statement s = con.createStatement();
				s.execute("SELECT nickname AS nickname, password AS password FROM table WHERE nickname='"+nickname+"'");
				ResultSet r = s.getResultSet();

				if(r.first()) {
						if(r.getString("nickname")==nickname && r.getString("password")==pw)
								return true;
				}
				return false;
		}
}