java项目连接mysql卡死_我的Java连接数据库之后就卡住了 不能输出结果 到底是为什么呢？程序的功能是要完成一个地址的最大正向查...

以下是基本的函数实现最重要的是第四个要实现街道的最大正向查找：ResultSetrs=s.executeQuery(sql);if(rs.next()){Stringpostaddress=rs.getString(1);Joutput.setText(postaddress)...

以下是基本的函数实现 最重要的是第四个 要实现街道的最大正向查找：

ResultSet rs=s.executeQuery(sql);

if(rs.next())

{

String postaddress=rs.getString(1);

Joutput.setText(postaddress);

ResultSet rs2=s.executeQuery(sql2);

if(rs2.next())

{

String postaddress2=rs2.getString(1);

Joutput.setText(postaddress2);

ResultSet rs3=s.executeQuery(sql3);

if(rs3.next()){

String postaddress3=rs3.getString(1);

Joutput.setText(postaddress3);

ResultSet rs4=s.executeQuery(sql4);

if(rs4.next()){

String postaddress4=rs4.getString(1);

int k=5;

int n=5;

int x=0;

int y=x+k;

//String q=postaddress4.substring(x, y);

Joutput.setText(postaddress4);

int len=postaddress4.length();

while(x

if(postaddress4.substring(x, y)==sql4.substring(x, y)){

x=y+1;

k=n;

if(x+k>len){

k=len-x;

//JOptionPane.showMessageDialog(null,postaddress4.substring(i, y));

postaddress4.substring(x, y);

}

else{

k=k-1;

postaddress4.substring(x, y);

break;

}

}

}

JOptionPane.showMessageDialog(null,"查询成功");

}

else{

JOptionPane.showMessageDialog(null,"查询失败");

}

}

else{

JOptionPane.showMessageDialog(null,"查询失败");

}

}

else{

JOptionPane.showMessageDialog(null,"查询失败");

}

Qu_Detail第一列是一些街道名

把while(rs.next)改到 if(rs4.next)后会出现异常

展开