📄 main_interface.java
字号:
, GridBagConstraints.CENTER, GridBagConstraints.NONE,
new Insets(37, 35, 0, 0), 0, -7));
jPanel2.add(jLabel_Profession, new GridBagConstraints(4, 3, 1, 1, 0.0, 0.0
, GridBagConstraints.WEST, GridBagConstraints.NONE,
new Insets(35, 0, 0, 0), 0, 0));
jPanel2.add(jLabel_Sex, new GridBagConstraints(1, 3, 1, 1, 0.0, 0.0
, GridBagConstraints.WEST, GridBagConstraints.NONE,
new Insets(35, 0, 0, 12), 0, 0));
jPanel2.add(jCheckBox_Profession, new GridBagConstraints(3, 3, 1, 1, 0.0, 0.0
, GridBagConstraints.CENTER, GridBagConstraints.NONE,
new Insets(31, 14, 0, 0), 0, 0));
jPanel2.add(jTextField_Profession, new GridBagConstraints(5, 3, 1, 1, 1.0, 0.0
, GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL,
new Insets(30, 12, 0, 43), 86, 0));
jPanel2.add(jTextField_Sex, new GridBagConstraints(2, 3, 1, 1, 1.0, 0.0
, GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL,
new Insets(30, 0, 0, 0), 86, 0));
jPanel2.add(jCheckBox_Name, new GridBagConstraints(0, 2, 1, 1, 0.0, 0.0
, GridBagConstraints.CENTER, GridBagConstraints.NONE,
new Insets(37, 35, 0, 0), 0, -7));
jPanel2.add(jLabel_Home, new GridBagConstraints(4, 2, 1, 1, 0.0, 0.0
, GridBagConstraints.WEST, GridBagConstraints.NONE,
new Insets(35, 0, 0, 0), 0, 0));
jPanel2.add(jLabel_Name, new GridBagConstraints(1, 2, 1, 1, 0.0, 0.0
, GridBagConstraints.WEST, GridBagConstraints.NONE,
new Insets(35, 0, 0, 12), 0, 0));
jPanel2.add(jTextField_Home, new GridBagConstraints(5, 2, 1, 1, 1.0, 0.0
, GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL,
new Insets(31, 12, 0, 43), 86, 0));
jPanel2.add(jCheckBox_Home, new GridBagConstraints(3, 2, 1, 1, 0.0, 0.0
, GridBagConstraints.CENTER, GridBagConstraints.NONE,
new Insets(30, 14, 0, 0), 0, 0));
jPanel2.add(jTextField_Name, new GridBagConstraints(2, 2, 1, 1, 1.0, 0.0
, GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL,
new Insets(30, 0, 0, 0), 86, 0));
jPanel2.add(jTextField_Race, new GridBagConstraints(5, 1, 1, 1, 1.0, 0.0
, GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL,
new Insets(13, 12, 0, 43), 86, 0));
jPanel2.add(jLabel_Race, new GridBagConstraints(4, 1, 1, 1, 0.0, 0.0
, GridBagConstraints.WEST, GridBagConstraints.NONE,
new Insets(15, 0, 0, 0), 0, 0));
jPanel2.add(jCheckBox_Race, new GridBagConstraints(3, 1, 1, 1, 0.0, 0.0
, GridBagConstraints.CENTER, GridBagConstraints.NONE,
new Insets(13, 14, 0, 0), 0, 0));
jPanel2.add(jTextField_Num, new GridBagConstraints(2, 1, 1, 1, 1.0, 0.0
, GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL,
new Insets(13, 0, 0, 0), 86, 0));
jPanel2.add(jLabel_Num, new GridBagConstraints(1, 1, 1, 1, 0.0, 0.0
, GridBagConstraints.WEST, GridBagConstraints.NONE,
new Insets(15, 0, 0, 12), 0, 0));
jPanel2.add(jCheckBox_Num, new GridBagConstraints(0, 1, 1, 1, 0.0, 0.0
, GridBagConstraints.CENTER, GridBagConstraints.NONE,
new Insets(16, 35, 0, 0), 1, -7));
jPanel2.add(jTextField_Expression, new GridBagConstraints(2, 4, 4, 1, 1.0, 0.0
, GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL,
new Insets(36, 0, 23, 43), 254, 1));
jPanel2.add(jLabel1, new GridBagConstraints(0, 4, 2, 1, 0.0, 0.0
, GridBagConstraints.WEST,GridBagConstraints.NONE,
new Insets(38, 47, 23, 0), 11,5));
jPanel2.add(jButton_AND, new GridBagConstraints(2, 0, 1, 1, 0.0, 0.0
, GridBagConstraints.CENTER, GridBagConstraints.NONE,
new Insets(24, 13, 0, 12), 17, -2));
jPanel2.add(jButton_OR, new GridBagConstraints(5, 0, 1, 1, 0.0, 0.0
, GridBagConstraints.CENTER, GridBagConstraints.NONE,
new Insets(24, 23, 0, 57), 25, -2));
setSize(new Dimension(400, 300));
setTitle("Search_Dialog");
}
//************************************
public void jButton_Search_actionPerformed(ActionEvent e)
{
Info_search_Method("Search");
}
public void jButton_Close_actionPerformed(ActionEvent e)
{
Info_search_Method("Close");
}
//*************************************
public void Info_search_Method(String action) //Include "Search,Close"
{
ResultSet rs=null;
Database_operate DB=new Database_operate();
String sql=new String();
String string_list[]={" Race"," Name"," Home"," Sex"," Profession"};
int p=0; //在字符串中查找的起始点
if(action.equals("Search")) ///信息查询-->关键字查询-->查询
{
if(jCheckBox_Num.isSelected()==true)
{
sql="select * from studentInfo where Num='"+jTextField_Num.getText()+"'";
}
else
{
sql="select * from studentInfo where ";
for(int i=0;i<string_list.length;i++)
{
if(jTextField_Expression.getText().startsWith(string_list[i],p)==true)
{
if(string_list[i].compareTo(" Name")==0)
{
sql=sql+string_list[i]+" like'%"+jTextField_Name.getText()+"%'";
}
else if(string_list[i].compareTo(" Race")==0)
{
sql=sql+string_list[i]+"='"+jTextField_Race.getText()+"'";
}
else if(string_list[i].compareTo(" Home")==0)
{
sql=sql+string_list[i]+"='"+jTextField_Home.getText()+"'";
}
else if(string_list[i].compareTo(" Sex")==0)
{
sql=sql+string_list[i]+"='"+jTextField_Sex.getText()+"'";
}
else if(string_list[i].compareTo(" Profession")==0)
{
sql=sql+string_list[i]+"='"+jTextField_Profession.getText()+"'";
}
else {}
p=p+string_list[i].length();
if(jTextField_Expression.getText().startsWith(" AND",p)==true)
{
sql=sql+" AND";
p=p+4;
System.out.println(" AND");
}
else if(jTextField_Expression.getText().startsWith(" OR",p)==true)
{
sql=sql+" OR";
p=p+3;
System.out.println(" OR");
}
else
{
///JOptionPane.showMessageDialog(null,"表达式错误！");
}
}
}
}
rs=DB.getResult(sql);
clearShow();
resultShow(rs);
}
if(action.equals("Close"))
{
this.dispose();
}
}
//********************************************
String s=new String();
String s1=new String();
String s2=new String();
public void jCheckBox_Num_actionPerformed(ActionEvent e)
{
if(jCheckBox_Num.isSelected()==true) // jCheckBox_Num处于选中状态
{
jTextField_Num.setEnabled(true);
jTextField_Race.setText("");
jTextField_Name.setText("");
jTextField_Home.setText("");
jTextField_Sex.setText("");
jTextField_Profession.setText("");
jTextField_Race.setEnabled(false);
jTextField_Name.setEnabled(false);
jTextField_Home.setEnabled(false);
jTextField_Sex.setEnabled(false);
jTextField_Profession.setEnabled(false);
s="";
jTextField_Expression.setText(" Num");
jCheckBox_Race.setEnabled(false);
jCheckBox_Name.setEnabled(false);
jCheckBox_Home.setEnabled(false);
jCheckBox_Sex.setEnabled(false);
jCheckBox_Profession.setEnabled(false);
jButton_AND.setEnabled(false);
jButton_OR.setEnabled(false);
jCheckBox_Race.setSelected(false);
jCheckBox_Name.setSelected(false);
jCheckBox_Home.setSelected(false);
jCheckBox_Sex.setSelected(false);
jCheckBox_Profession.setSelected(false);
}
if(jCheckBox_Num.isSelected()==false) // jCheckBox_Num处于非选中状态
{
jTextField_Num.setEnabled(false);
jTextField_Race.setEnabled(true);
jTextField_Name.setEnabled(true);
jTextField_Home.setEnabled(true);
jTextField_Sex.setEnabled(true);
jTextField_Profession.setEnabled(true);
s="";
jTextField_Expression.setText("");
jCheckBox_Race.setEnabled(true);
jCheckBox_Name.setEnabled(true);
jCheckBox_Home.setEnabled(true);
jCheckBox_Sex.setEnabled(true);
jCheckBox_Profession.setEnabled(true);
jButton_AND.setEnabled(true);
jButton_OR.setEnabled(true);
}
}
public void jCheckBox_Race_actionPerformed(ActionEvent e)
{
if(s.indexOf(" Race")==-1) //不存在
{
if(jCheckBox_Race.isSelected()==true) // jCheckBox_Race处于选中状态
{
///System.out.println(s.indexOf(" Race")+" "+"不存在 选中");
s=jTextField_Expression.getText()+" Race";
jTextField_Expression.setText(s);
}
else
{
///System.out.println(s.indexOf(" Race")+" "+"不存在 非选中");
}
}
else //已经存在
{
if(jCheckBox_Race.isSelected()==false) // jCheckBox_Race处于非选中状态
{
///System.out.println(s.indexOf(" Race")+" "+"已经存在 非选中");
jTextField_Expression.select(s.indexOf(" Race"),s.indexOf(" Race")+5);
jTextField_Expression.select(0,s.indexOf(" Race"));
if(jTextField_Expression.getSelectedText()==null)
{
s1="";
}
else
{
s1=jTextField_Expression.getSelectedText();
}
jTextField_Expression.select(s.indexOf(" Race")+5,100);
if(jTextField_Expression.getSelectedText()==null)
{
s2="";
}
else
{
s2=jTextField_Expression.getSelectedText();
}
jTextField_Expression.setText(s1+s2);
s=jTextField_Expression.getText();
if(s.startsWith(" AND")==true)
{
jTextField_Expression.select(4,s.length());
if(jTextField_Expression.getSelectedText()==null)
s="";
else
s=jTextField_Expression.getSelectedText();
}
if(s.startsWith(" OR")==true)
{
jTextField_Expression.select(3,s.length());
if(jTextField_Expression.getSelectedText()==null)
s="";
else
s=jTextField_Expression.getSelectedText();
}
jTextField_Expression.setText(s);
}
else
{
///System.out.println(s.indexOf(" Race")+" "+"已经存在 选中");
}
}
}
public void jCheckBox_Name_actionPerformed(ActionEvent e)
{
if(s.indexOf(" Name")==-1) //不存在
{
if(jCheckBox_Name.isSelected()==true) // jCheckBox_Name处于选中状态
{
///System.out.println(s.indexOf(" Name")+" "+"不存在 选中");
s=jTextField_Expression.getText()+" Name";
jTextField_Expression.setText(s);
}
else
{
///System.out.println(s.indexOf(" Name")+" "+"不存在 非选中");
}
}
else //已经存在
{
if(jCheckBox_Name.isSelected()==false) // jCheckBox_Name处于非选中状态
{
///System.out.println(s.indexOf(" Name")+" "+"已经存在 非选中");
jTextField_Expression.select(s.indexOf(" Name"),s.indexOf(" Name")+5);
jTextField_Expression.select(0,s.indexOf(" Name"));
if(jTextField_Expression.getSelectedText()==null)
{
s1="";
}
else
{
s1=jTextField_Expression.getSelectedText();
}
jTextField_Expression.select(s.indexOf(" Name")+5,100);
if(jTextField_Expression.getSelectedText()==null)
{
s2="";
}
else
{
s2=jTextField_Expression.getSelectedText();
}
jTextField_Expression.setText(s1+s2);
s=jTextField_Expression.getText();
if(s.startsWith(" AND")==true)
{
jTextField_Expression.select(4,s.length());
if(jTextField_Expression.getSelectedText()==null)
s="";
else
s=jTextField_Expression.getSelectedText();
}
if(s.startsWith(" OR")==true)
{
jTextField_Expression.select(3,s.length());
if(jTextField_Expression.getSelectedText()==null)
s="";
else
s=jTextField_Expression.getSelectedText();
}
jTextField_Expression.setText(s);
}
else
{
///System.out.println(s.indexOf(" Name")+" "+"已经存在 选中");
}
}
}
public void jCheckBox_Home_actionPerformed(ActionEvent e)
{
if(s.indexOf(" Home")==-1) //不存在
{
if(jCheckBox_Home.isSelected()==true) // jCheckBox_Home处于选中状态
{
///System.out.println(s.indexOf(" Home")+" "+"不存在 选中");
s=jTextField_Expression.getText()+" Home";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -