package UnimapDBConsole;

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

public class db
{
	//declarations

		public static String classname;
		public static String constring;
		Connection con;
		ResultSet rs;
		PreparedStatement st;
		String sql,fullname;
		db()
		{
			classname="com.mysql.jdbc.Driver";
			constring="jdbc:mysql://10.2.17.217/unimap?user=root&password=password";
		}
		public void init()
		{
			try
			{
				Class.forName(classname);
				con=DriverManager.getConnection(constring);
				//System.out.println("Connection established");
			}
			catch(Exception e)
			{System.out.println(e);}
		}
		public boolean validate(String username,String password)
		{
			try
			{
				sql="select fullname from users where";
				sql=sql+" username=? and password=?";
				st=con.prepareStatement(sql);
				st.setString(1,username);
				st.setString(2,password);
				rs=st.executeQuery();
				if(rs.next())
				{
					fullname=rs.getString("fullname");
					return true;
				}
				else
				{
					return false;
				}

			}
			catch(Exception e)
			{
				e.printStackTrace();
				return false;
			}

		}
		public boolean adduser(String username,String password,String fullname)
		{
			try
			{
				sql="insert into users(username,password,fullname)";
				sql=sql+" values(?,?,?)";
				st=con.prepareStatement(sql);
				st.setString(1,username);
				st.setString(2,password);
				st.setString(3,fullname);
				if(st.executeUpdate()==1)
					return true;
				else
					return false;

			}
			catch(Exception e)
			{
				e.printStackTrace();
				return false;
			}
		}
		public boolean update(String username, String fullname)
		{
			try
			{
				sql= "update users";
				sql = sql +" set fullname=? where username=?";
				st=con.prepareStatement(sql);
				st.setString(1,fullname);
				st.setString(2,username);
				if(st.executeUpdate()==1)
					return true;
				else
					return false;
			}

			catch(Exception e)
			{
				e.printStackTrace();
				return false;
			}

		}

}