package group_head_package;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;

import main_package.DataBaseConnection;


@ManagedBean(name="memberDsaUpdate")
@ViewScoped
public class MemberDsaUpdate implements Serializable
{
	public void dsaUpdate()
	{
		try(Connection conn=DataBaseConnection.JAVAConnection())
		{
			Statement st=conn.createStatement();
			String qq="select teamLeader,dsacode from grouploan";
			ResultSet rr=st.executeQuery(qq);
			while(rr.next())
			{
				//System.out.println(rr.getString("teamLeader")+" == "+rr.getString("dsacode"));
				Statement st2=conn.createStatement();
				String qq2="update shareholder_info set dsacode='"+rr.getString("dsacode")+"' where shareholderno='"+rr.getString("teamLeader")+"' ";
				//System.out.println(qq2);
				st2.executeUpdate(qq2);
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		
	}
}
