ارجو مساعده سريعا

السلام عليكم ورحمة الله وبركاته

لديه مشكله فى كود انا عندى بيانات فى داتا بيز عايزه اعرضها

فهو بيجيب او بيان والوب بتقف ولا ياتى بالباقى

وسعرض الكود الان

package task_chat;

import java.awt.Container;

import java.awt.event.MouseEvent;

import java.awt.event.MouseListener;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import javax.swing.JFrame;

import javax.swing.*;

public class entro {

public entro() {

entroGUI();

}

JFrame fram1;

Container cont1;

Container cont5;

JPanel pan1;

JPanel pan2;

JPanel pan0 ;

JPanel pan3;

JPanel pan4;

JPanel pan60;

JLabel lab1;

JLabel lab2;

JTextField text1;

JTextField text2;

JButton forget;

JButton register;

JButton sign_in;

Connection con1;

Statement st1;

ResultSet res1;

ResultSet res6;

ResultSet res7;

String query1="";

String query6="";

String query7="";

public void Action_Edit1()

{

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String sourceURL = "jdbc:odbc:chating";

con1 = DriverManager.getConnection(sourceURL, "root", "1234");

st1 = con1.createStatement();

}

catch (Exception ex)

{

ex.printStackTrace();

}

}

public void entroGUI()

{

fram1 =new JFrame();

cont1 = fram1.getContentPane();

pan60 =new JPanel();

pan1 =new JPanel();

pan2 =new JPanel();

pan0 =new JPanel();

pan3 =new JPanel();

pan4 =new JPanel();

lab1 =new JLabel("Nick Name");

lab2 =new JLabel("Password");

text1 =new JTextField(10);

text2 =new JTextField(10);

forget =new JButton("Forget Password ");

register =new JButton("Register");

sign_in =new JButton("Sign In");

mymouse2 kj=new mymouse2();

sign_in.addMouseListener(kj);

register.addMouseListener(kj);

forget.addMouseListener(kj);

cont1.add(pan60);

BoxLayout layout = new BoxLayout(pan60, BoxLayout.Y_AXIS);

pan60.setLayout(layout);

// cont1.setLayout(new BoxLayout(vertPanel,BoxLayout.Y_AXIS));

pan60.add(pan1);

pan60.add(pan2);

pan60.add(pan3);

pan60.add(pan0);

pan60.add(pan4);

pan2.add(lab1);

pan2.add(text1);

pan3.add(lab2);

pan3.add(text2);

pan0.add(sign_in);

pan4.add(register);

pan4.add(forget);

fram1.setBounds(300, 300, 500, 300);

fram1.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);

fram1.setVisible(true);

fram1.setResizable(false);

}

public class mymouse2 implements MouseListener {

String te11;

String te12;

String id;

String frind;

String id_frind;

String nick_name_frind;

JLabel lab21;

ArrayList arr=new ArrayList();

public void mouseClicked(MouseEvent e) {

if(e.getSource()==sign_in)

{

te11= text1.getText();

te12= text2.getText();

Action_Edit1();

query1="select * from register where nick_name = '"+ te11 +"' and password='" + te12 + "'";

try {

res1=st1.executeQuery(query1);

if(res1.next())

{

id= res1.getString(1);

pan60.setVisible(false);

JPanel pan50=new JPanel();

JPanel pan51=new JPanel();

JPanel pan52=new JPanel();

JLabel lab20=new JLabel("My Frinds");

cont1.add(pan52);

BoxLayout layout = new BoxLayout(pan52, BoxLayout.Y_AXIS);

pan52.setLayout(layout);

pan52.add(pan50);

pan52.add(pan51);

pan50.add(lab20);

query6="select * from frind where my_id = '"+ id +"'";

try {

res6=st1.executeQuery(query6);

while(res6.next())

{

arr.add(res6.getString(3));

for(int i=0;i<arr.size();i++)

{

System.out.println(arr.get(i));

query7="select * from register where id_user = '"+ arr.get(i) +"'";

JOptionPane.showMessageDialog(null,arr.get(i));

// id_frind =res6.getString(3);

try {

res7=st1.executeQuery(query7);

if(res7.next())

{

nick_name_frind =res7.getString(9);

lab21=new JLabel(nick_name_frind);

pan51.add(lab21);

}

} catch (SQLException ex) {

ex.printStackTrace();

}

}}

} catch (SQLException ex) {

ex.printStackTrace();

}

}

} catch (SQLException ex) {

ex.printStackTrace();

}

}

if(e.getSource()==register)

{

fram1.setVisible(false);

register hh=new register();

}

if(e.getSource()==forget)

{

fram1.setVisible(false);

FPassword gg=new FPassword();

}

/* if(e.getSource()==lab21)

{

fram1.setVisible(false);

// FPassword gg=new FPassword();

chat n =new chat();

}*/

}

public void mousePressed(MouseEvent e) {

}

public void mouseReleased(MouseEvent e) {

}

public void mouseEntered(MouseEvent e) {

}

public void mouseExited(MouseEvent e) {

}

}

}