package other_package;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import main_package.DataBaseConnection;

public class MyTest6 {

	public static void main(String[] args) 
	{
		/*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();
		}*/
		
		String text="AG-P0008";
		String numbers = text.substring(text.length() - 4);
		System.out.println(numbers);
		
	}

}
