📄 xinxifind.java
字号:
ta1.setText(str13);
}
if(e.getSource()==bu15)
{
rs1=st1.executeQuery("select * from 2号楼住宿花名册 WHERE xibie='"+pp3+"' OR fanghao='房号'");
// rs1=st1.executeQuery("select * from 2号楼住宿花名册,3号楼住宿花名册,5号楼住宿花名册,7号楼住宿花名册,8号楼住宿花名册,13号楼住宿花名册,14号楼住宿花名册,明煌楼学生住宿花名册,学生公寓楼住宿花名册 WHERE zhuanye='"+pp4+"' OR fanghao='房号'");
str13="";
while(rs1.next())
{
str13=str13+rs1.getString(1)+"\t"+rs1.getString(2)+"\t"+rs1.getString(3)+"\t"+
rs1.getString(5)+"\t"+rs1.getString(6)+"\t"+rs1.getString(7)+"\n";
}
ta1.setText(str13);
ResultSet rs2=st1.executeQuery("select * from 3号楼住宿花名册 WHERE xibie='"+pp3+"'");
str13="";
while(rs2.next())
{
str13=str13+rs2.getString(1)+"\t"+rs2.getString(2)+"\t"+rs2.getString(3)+"\t"+
rs2.getString(5)+"\t"+rs2.getString(6)+"\t"+rs2.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs3=st1.executeQuery("select * from 5号楼住宿花名册 WHERE xibie='"+pp3+"'");
str13="";
while(rs3.next())
{
str13=str13+rs3.getString(1)+"\t"+rs3.getString(2)+"\t"+rs3.getString(3)+"\t"+
rs3.getString(5)+"\t"+rs3.getString(6)+"\t"+rs3.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs4=st1.executeQuery("select * from 7号楼住宿花名册 WHERE xibie='"+pp3+"'");
str13="";
while(rs4.next())
{
str13=str13+rs4.getString(1)+"\t"+rs4.getString(2)+"\t"+rs4.getString(3)+"\t"+
rs4.getString(5)+"\t"+rs4.getString(6)+"\t"+rs4.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs5=st1.executeQuery("select * from 8号楼住宿花名册 WHERE xibie='"+pp3+"'");
str13="";
while(rs5.next())
{
str13=str13+rs5.getString(1)+"\t"+rs5.getString(2)+"\t"+rs5.getString(3)+"\t"+
rs5.getString(5)+"\t"+rs5.getString(6)+"\t"+rs5.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs6=st1.executeQuery("select * from 13号楼住宿花名册 WHERE xibie='"+pp3+"'");
str13="";
while(rs6.next())
{
str13=str13+rs6.getString(1)+"\t"+rs6.getString(2)+"\t"+rs6.getString(3)+"\t"+
rs6.getString(5)+"\t"+rs6.getString(6)+"\t"+rs6.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs7=st1.executeQuery("select * from 14号楼住宿花名册 WHERE xibie='"+pp3+"'");
str13="";
while(rs7.next())
{
str13=str13+rs7.getString(1)+"\t"+rs7.getString(2)+"\t"+rs7.getString(3)+"\t"+
rs7.getString(5)+"\t"+rs7.getString(6)+"\t"+rs7.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs8=st1.executeQuery("select * from 明煌楼住宿花名册 WHERE xibie='"+pp3+"'");
str13="";
while(rs8.next())
{
str13=str13+rs8.getString(1)+"\t"+rs8.getString(2)+"\t"+rs8.getString(3)+"\t"+
rs8.getString(5)+"\t"+rs8.getString(6)+"\t"+rs8.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs9=st1.executeQuery("select * from 学生公寓楼住宿花名册 WHERE xibie='"+pp3+"'");
str13="";
while(rs9.next())
{
str13=str13+rs9.getString(1)+"\t"+rs9.getString(2)+"\t"+rs9.getString(3)+"\t"+
rs9.getString(5)+"\t"+rs9.getString(6)+"\t"+rs9.getString(7)+"\n";
}
ta1.append(str13);
}
if(e.getSource()==bu16)
{
rs1=st1.executeQuery("select * from 2号楼住宿花名册 WHERE zhuanye='"+pp4+"' OR fanghao='房号'");
// rs1=st1.executeQuery("select * from 2号楼住宿花名册,3号楼住宿花名册,5号楼住宿花名册,7号楼住宿花名册,8号楼住宿花名册,13号楼住宿花名册,14号楼住宿花名册,明煌楼学生住宿花名册,学生公寓楼住宿花名册 WHERE zhuanye='"+pp4+"' OR fanghao='房号'");
str13="";
while(rs1.next())
{
str13=str13+rs1.getString(1)+"\t"+rs1.getString(2)+"\t"+rs1.getString(3)+"\t"+
rs1.getString(5)+"\t"+rs1.getString(6)+"\t"+rs1.getString(7)+"\n";
}
ta1.setText(str13);
ResultSet rs2=st1.executeQuery("select * from 3号楼住宿花名册 WHERE zhuanye='"+pp4+"'");
str13="";
while(rs2.next())
{
str13=str13+rs2.getString(1)+"\t"+rs2.getString(2)+"\t"+rs2.getString(3)+"\t"+
rs2.getString(5)+"\t"+rs2.getString(6)+"\t"+rs2.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs3=st1.executeQuery("select * from 5号楼住宿花名册 WHERE zhuanye='"+pp4+"'");
str13="";
while(rs3.next())
{
str13=str13+rs3.getString(1)+"\t"+rs3.getString(2)+"\t"+rs3.getString(3)+"\t"+
rs3.getString(5)+"\t"+rs3.getString(6)+"\t"+rs3.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs4=st1.executeQuery("select * from 7号楼住宿花名册 WHERE zhuanye='"+pp4+"'");
str13="";
while(rs4.next())
{
str13=str13+rs4.getString(1)+"\t"+rs4.getString(2)+"\t"+rs4.getString(3)+"\t"+
rs4.getString(5)+"\t"+rs4.getString(6)+"\t"+rs4.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs5=st1.executeQuery("select * from 8号楼住宿花名册 WHERE zhuanye='"+pp4+"'");
str13="";
while(rs5.next())
{
str13=str13+rs5.getString(1)+"\t"+rs5.getString(2)+"\t"+rs5.getString(3)+"\t"+
rs5.getString(5)+"\t"+rs5.getString(6)+"\t"+rs5.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs6=st1.executeQuery("select * from 13号楼住宿花名册 WHERE zhuanye='"+pp4+"'");
str13="";
while(rs6.next())
{
str13=str13+rs6.getString(1)+"\t"+rs6.getString(2)+"\t"+rs6.getString(3)+"\t"+
rs6.getString(5)+"\t"+rs6.getString(6)+"\t"+rs6.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs7=st1.executeQuery("select * from 14号楼住宿花名册 WHERE zhuanye='"+pp4+"'");
str13="";
while(rs7.next())
{
str13=str13+rs7.getString(1)+"\t"+rs7.getString(2)+"\t"+rs7.getString(3)+"\t"+
rs7.getString(5)+"\t"+rs7.getString(6)+"\t"+rs7.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs8=st1.executeQuery("select * from 明煌楼住宿花名册 WHERE zhuanye='"+pp4+"'");
str13="";
while(rs8.next())
{
str13=str13+rs8.getString(1)+"\t"+rs8.getString(2)+"\t"+rs8.getString(3)+"\t"+
rs8.getString(5)+"\t"+rs8.getString(6)+"\t"+rs8.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs9=st1.executeQuery("select * from 学生公寓楼住宿花名册 WHERE zhuanye='"+pp4+"'");
str13="";
while(rs9.next())
{
str13=str13+rs9.getString(1)+"\t"+rs9.getString(2)+"\t"+rs9.getString(3)+"\t"+
rs9.getString(5)+"\t"+rs9.getString(6)+"\t"+rs9.getString(7)+"\n";
}
ta1.append(str13);
}
if(e.getSource()==bu17)
{
rs1=st1.executeQuery("select * from 2号楼住宿花名册 WHERE (name LIKE '%"+str4+"%' OR name LIKE '%"+str4+"' OR name LIKE '"+str4+"%') OR fanghao='房号'");
// rs1=st1.executeQuery("select * from 2号楼住宿花名册,3号楼住宿花名册,5号楼住宿花名册,7号楼住宿花名册,8号楼住宿花名册,13号楼住宿花名册,14号楼住宿花名册,明煌楼学生住宿花名册,学生公寓楼住宿花名册 WHERE zhuanye='"+pp4+"' OR fanghao='房号'");
str13="";
while(rs1.next())
{
str13=str13+rs1.getString(1)+"\t"+rs1.getString(2)+"\t"+rs1.getString(3)+"\t"+
rs1.getString(5)+"\t"+rs1.getString(6)+"\t"+rs1.getString(7)+"\n";
}
ta1.setText(str13);
ResultSet rs2=st1.executeQuery("select * from 3号楼住宿花名册 WHERE (name LIKE '%"+str4+"%' OR name LIKE '%"+str4+"' OR name LIKE '"+str4+"%')");
str13="";
while(rs2.next())
{
str13=str13+rs2.getString(1)+"\t"+rs2.getString(2)+"\t"+rs2.getString(3)+"\t"+
rs2.getString(5)+"\t"+rs2.getString(6)+"\t"+rs2.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs3=st1.executeQuery("select * from 5号楼住宿花名册 WHERE (name LIKE '%"+str4+"%' OR name LIKE '%"+str4+"' OR name LIKE '"+str4+"%')");
str13="";
while(rs3.next())
{
str13=str13+rs3.getString(1)+"\t"+rs3.getString(2)+"\t"+rs3.getString(3)+"\t"+
rs3.getString(5)+"\t"+rs3.getString(6)+"\t"+rs3.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs4=st1.executeQuery("select * from 7号楼住宿花名册 WHERE (name LIKE '%"+str4+"%' OR name LIKE '%"+str4+"' OR name LIKE '"+str4+"%')");
str13="";
while(rs4.next())
{
str13=str13+rs4.getString(1)+"\t"+rs4.getString(2)+"\t"+rs4.getString(3)+"\t"+
rs4.getString(5)+"\t"+rs4.getString(6)+"\t"+rs4.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs5=st1.executeQuery("select * from 8号楼住宿花名册 WHERE (name LIKE '%"+str4+"%' OR name LIKE '%"+str4+"' OR name LIKE '"+str4+"%')");
str13="";
while(rs5.next())
{
str13=str13+rs5.getString(1)+"\t"+rs5.getString(2)+"\t"+rs5.getString(3)+"\t"+
rs5.getString(5)+"\t"+rs5.getString(6)+"\t"+rs5.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs6=st1.executeQuery("select * from 13号楼住宿花名册 WHERE (name LIKE '%"+str4+"%' OR name LIKE '%"+str4+"' OR name LIKE '"+str4+"%')");
str13="";
while(rs6.next())
{
str13=str13+rs6.getString(1)+"\t"+rs6.getString(2)+"\t"+rs6.getString(3)+"\t"+
rs6.getString(5)+"\t"+rs6.getString(6)+"\t"+rs6.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs7=st1.executeQuery("select * from 14号楼住宿花名册 WHERE (name LIKE '%"+str4+"%' OR name LIKE '%"+str4+"' OR name LIKE '"+str4+"%')");
str13="";
while(rs7.next())
{
str13=str13+rs7.getString(1)+"\t"+rs7.getString(2)+"\t"+rs7.getString(3)+"\t"+
rs7.getString(5)+"\t"+rs7.getString(6)+"\t"+rs7.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs8=st1.executeQuery("select * from 明煌楼住宿花名册 WHERE (name LIKE '%"+str4+"%' OR name LIKE '%"+str4+"' OR name LIKE '"+str4+"%')");
str13="";
while(rs8.next())
{
str13=str13+rs8.getString(1)+"\t"+rs8.getString(2)+"\t"+rs8.getString(3)+"\t"+
rs8.getString(5)+"\t"+rs8.getString(6)+"\t"+rs8.getString(7)+"\n";
}
ta1.append(str13);
ResultSet rs9=st1.executeQuery("select * from 学生公寓楼住宿花名册 WHERE (name LIKE '%"+str4+"%' OR name LIKE '%"+str4+"' OR name LIKE '"+str4+"%')");
str13="";
while(rs9.next())
{
str13=str13+rs9.getString(1)+"\t"+rs9.getString(2)+"\t"+rs9.getString(3)+"\t"+
rs9.getString(5)+"\t"+rs9.getString(6)+"\t"+rs9.getString(7)+"\n";
}
ta1.append(str13);
}
//System.out.println("成功！！");
}
catch(SQLException e2)
{
//System.out.println("error");
}
}
//======================================================================================
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -