/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package javasqlproject;

import java.sql.*;

/**
 *
 * @author bruger
 */
public class register {
    
    private Connection con;
    private Statement st;
    private ResultSet rs;
    public register(){
        try {
            Class.forName("com.mysql.jdbc.Driver");
            
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/javaii", "root", "12345678");
            st = con.createStatement();
            
            
        }catch(Exception ex){
            System.out.println("Error: "+ex);
        }        
    }
    public void getData(){
        try{
            
            String query = "SELECT * FROM test";
            rs = st.executeQuery(query);
            System.out.println("Records from Database");
            while(rs.next()){
                String name = rs.getString("name");
                String age = rs.getString("age");
                System.out.println("Name: "+name+" Age: "+age);
            }
            
        }catch(Exception ex ){
            System.out.println(ex);
        }
    }
    public void registerUser(String username, String password, String gender){
        try{
            Statement stmt = con.createStatement();
            if(gender.equals("1")){
                gender = "male";
            }else {
                gender = "female";
            }
            String User = null;
            //stmt.executeUpdate("create table");
            String sql = "SELECT username FROM register WHERE username='" + username + "'";
            rs = st.executeQuery(sql);
            
            if(rs.next()){
                User = rs.getString("username");
            } if(User != null && username.equals(User)){
                System.out.println("Username already exists");
            } else { 
                stmt.executeUpdate("INSERT INTO register (username, password, gender )VALUES('"+username+"', '"+password+"', '"+gender+"')");
            }  
        }catch(Exception ex){
            System.out.println(ex);
        }
    }
}