📄 factory.java
字号:
int cout=0;
while(dbse.rs.next())
{
cout++;
if(dbse.rs.getString(1).equalsIgnoreCase(str)==true)
break;
}
pane.removeAll();
pane.add(paneFactory,BorderLayout.NORTH);
pane.add(lockZhaopin.scroll,BorderLayout.CENTER);
getinfo(cout);
pane.setVisible(false);
pane.setVisible(true);
}catch(SQLException e){}
}
else
JOptionPane.showMessageDialog(null,"改记录添加失败!!!");
}
//更新记录
if(parm1.getSource()==toolZhaopin[2])
{
int op=JOptionPane.showConfirmDialog(null,"确定要更新这条记录吗?","提示",JOptionPane.YES_NO_OPTION);
if(op==JOptionPane.YES_OPTION)
{
String s1=txtMinxiNo.getText();
String s2=txtMinxizp[0].getText();
DataBase db=new DataBase();
db.GetResultSet("select * from 招聘信息 where 单位编号 = '"+s1+"' and 招聘专业 = '"+s2+"'");
try
{
db.rs.next();
db.rs.updateString(1,txtMinxiNo.getText());
for(int i=2;i<db.rsmd.getColumnCount()-1;i++)
db.rs.updateString(i,txtMinxizp[i-2].getText());
db.rs.updateString(db.rsmd.getColumnCount(),areaMinxizp.getText());
db.rs.updateRow();
db.st.close();
}catch(SQLException e){}
JOptionPane.showMessageDialog(null,"记录更新成功!!!");
///////
String str=txtMinxiNo.getText();
DataBase dbse=new DataBase();
dbse.GetResultSet("select * from 企业信息 ");
try
{
int cout=0;
while(dbse.rs.next())
{
cout++;
if(dbse.rs.getString(1).equalsIgnoreCase(str)==true)
break;
}
pane.removeAll();
pane.add(paneFactory,BorderLayout.NORTH);
pane.add(lockZhaopin.scroll,BorderLayout.CENTER);
getinfo(cout);
pane.setVisible(false);
pane.setVisible(true);
}catch(SQLException e){}
}
else
JOptionPane.showMessageDialog(null,"记录更新失败!!!");
}
//删除记录
if(parm1.getSource()==toolZhaopin[3])
{
int op=JOptionPane.showConfirmDialog(null,"确定要删除这条记录吗?","提示",JOptionPane.YES_NO_OPTION);
if(op==JOptionPane.YES_OPTION)
{
String s1=txtMinxiNo.getText();
String s2=txtMinxizp[0].getText();
DataBase db=new DataBase();
try
{
db.GetResultSet("select * from 招聘信息");
db.st.execute("delete from 招聘信息 where 单位编号 = '"+s1+"' and 招聘专业 = '"+s2+"'");
db.st.close();
}catch(SQLException e){}
JOptionPane.showMessageDialog(null,"该记录已经删除!!!");
for(int i=0;i<10;i++)
txtMinxizp[i].setText("");
areaMinxizp.setText("");
txtMinxiNo.setEditable(true);
toolZhaopin[1].setEnabled(true);
toolZhaopin[2].setEnabled(false);
String str=txtMinxiNo.getText();
DataBase dbse=new DataBase();
dbse.GetResultSet("select * from 企业信息 ");
try
{
int cout=0;
while(dbse.rs.next())
{
cout++;
if(dbse.rs.getString(1).equalsIgnoreCase(str)==true)
break;
}
pane.removeAll();
pane.add(paneFactory,BorderLayout.NORTH);
pane.add(lockZhaopin.scroll,BorderLayout.CENTER);
getinfo(cout);
pane.setVisible(false);
pane.setVisible(true);
}catch(SQLException e){}
}
else
JOptionPane.showMessageDialog(null,"该记录删除失败!!!");
}
//更多条件查询标签
if(parm1.getSource()==lblMore)
{
pane.removeAll();
pane.add(paneMore,BorderLayout.CENTER);
pane.setVisible(false);
pane.setVisible(true);
}
//toolMore企业
if(parm1.getSource()==toolMore[0])
{
paneMore.removeAll();
paneMore.add(barMore,BorderLayout.WEST);
paneMore.add(paneMoreFactory,BorderLayout.CENTER);
paneMore.setVisible(false);
paneMore.setVisible(true);
}
//toolMore招聘
if(parm1.getSource()==toolMore[1])
{
paneMore.removeAll();
paneMore.add(barMore,BorderLayout.WEST);
paneMore.add(paneMoreZhaopin,BorderLayout.CENTER);
paneMore.setVisible(false);
paneMore.setVisible(true);
}
//toolMore返回标签
if(parm1.getSource()==toolMore[2])
{
pane.removeAll();
pane.add(paneFactory,BorderLayout.NORTH);
pane.add(lockZhaopin.scroll,BorderLayout.CENTER);
getinfo(1);
pane.setVisible(false);
pane.setVisible(true);
}
}
public void mouseReleased(MouseEvent parm1) {
// TODO: Add your code here
}
public void mouseEntered(MouseEvent parm1)
{
//工具条鼠标进入事件
for(int i=0;i<8;i++)
{
if(parm1.getSource()==lblTool[i])
{
lblTool[i].setBorder(BorderFactory.createMatteBorder(1,1,1,1,Color.red));
}
}
for(int i=0;i<4;i++)
{
if(parm1.getSource()==toolZhaopin[i])
{
toolZhaopin[i].setBorder(BorderFactory.createMatteBorder(1,1,1,1,Color.red));
f.pack();
}
}
//更多查询标签
if(parm1.getSource()==lblMore)
{
lblMore.setBorder(BorderFactory.createMatteBorder(0,0,1,0,Color.blue));
lblMore.setForeground(Color.red);
}
//列表工具条
for(int i=0;i<3;i++)
{
if(parm1.getSource()==toolMore[i])
toolMore[i].setBorder(BorderFactory.createMatteBorder(1,1,1,1,Color.red));
}
}
public void mouseExited(MouseEvent parm1)
{
//工具条鼠标离开事件
for(int i=0;i<8;i++)
{
if(parm1.getSource()==lblTool[i])
lblTool[i].setBorder(null);
}
for(int i=0;i<4;i++)
{
if(parm1.getSource()==toolZhaopin[i])
{
toolZhaopin[i].setBorder(null);
}
}
//更多查询标签
if(parm1.getSource()==lblMore)
{
lblMore.setBorder(BorderFactory.createMatteBorder(0,0,1,0,Color.red));
lblMore.setForeground(Color.blue);
}
//列表工具条
for(int i=0;i<3;i++)
{
if(parm1.getSource()==toolMore[i])
toolMore[i].setBorder(null);
}
}
public void insertUpdate(DocumentEvent parm1)
{
if(parm1.getDocument()==txtNo.getDocument())
{
try
{
String s=txtNo.getText().trim();
DataBase db=new DataBase();
db.GetResultSet("select * from 企业信息 where 单位编号 like "+"'%"+s+"%'");
db.rs.next();
for(int i=0;i<10;i++)
txtFactory[i].setText(db.rs.getString(i+1));
areaFactory.setText(db.rs.getString(11));
db.st.close();
String ss=txtFactory[0].getText().trim();
getmodel("select * from 招聘信息 where 单位编号 = "+"'"+ss+"'",1);
lockZhaopin.tableOne.setModel(model);
getmodel("select * from 招聘信息 where 单位编号 = "+"'"+ss+"'",4);
lockZhaopin.tableTwo.setModel(model);
}catch(SQLException e){}
}
//////////企业一级查询
if(parm1.getDocument()==txtMoreFactory[0].getDocument())
{
String s1=choiceFactory1.getSelectedItem().trim();
String s2=txtMoreFactory[0].getText().trim();
getmodel("select * from 企业信息 where "+s1+" like"+" '%"+s2+"%'",0);
lockMoreFactory.tableOne.setModel(model);
getmodel("select * from 企业信息 where "+s1+" like"+" '%"+s2+"%'",2);
lockMoreFactory.tableTwo.setModel(model);
}
//////////企业二级查询
if(parm1.getDocument()==txtMoreFactory[1].getDocument())
{
String s1=choiceFactory1.getSelectedItem().trim();
String s2=txtMoreFactory[0].getText().trim();
String s3=choice1.getSelectedItem().trim();
String s4=choiceFactory2.getSelectedItem().trim();
String s5=txtMoreFactory[1].getText();
getmodel("select * from 企业信息 where "+s1+" like"+" '%"+s2+"%' "+s3+" "+s4+" like"+" '%"+s5+"%' ",0);
lockMoreFactory.tableOne.setModel(model);
getmodel("select * from 企业信息 where "+s1+" like"+" '%"+s2+"%' "+s3+" "+s4+" like"+" '%"+s5+"%' ",2);
lockMoreFactory.tableTwo.setModel(model);
}
//////////招聘一级查询
if(parm1.getDocument()==txtMoreZhaopin[0].getDocument())
{
String s1=choiceZhaopin1.getSelectedItem().trim();
String s2=txtMoreZhaopin[0].getText().trim();
getmodel("select * from 招聘信息 where "+s1+" like"+" '%"+s2+"%'",0);
lockMoreZhaopin.tableOne.setModel(model);
getmodel("select * from 招聘信息 where "+s1+" like"+" '%"+s2+"%'",2);
lockMoreZhaopin.tableTwo.setModel(model);
}
//////////招聘二级查询
if(parm1.getDocument()==txtMoreZhaopin[1].getDocument())
{
String s1=choiceZhaopin1.getSelectedItem().trim();
String s2=txtMoreZhaopin[0].getText().trim();
String s3=choice2.getSelectedItem().trim();
String s4=choiceZhaopin2.getSelectedItem().trim();
String s5=txtMoreZhaopin[1].getText();
getmodel("select * from 招聘信息 where "+s1+" like"+" '%"+s2+"%' "+s3+" "+s4+" like"+" '%"+s5+"%' ",0);
lockMoreZhaopin.tableOne.setModel(model);
getmodel("select * from 招聘信息 where "+s1+" like"+" '%"+s2+"%' "+s3+" "+s4+" like"+" '%"+s5+"%' ",2);
lockMoreZhaopin.tableTwo.setModel(model);
}
}
public void removeUpdate(DocumentEvent parm1)
{
if(parm1.getDocument()==txtNo.getDocument())
{
try
{
String s=txtNo.getText().trim();
DataBase db=new DataBase();
db.GetResultSet("select * from 企业信息 where 单位编号 like "+"'%"+s+"%'");
db.rs.next();
for(int i=0;i<10;i++)
txtFactory[i].setText(db.rs.getString(i+1));
areaFactory.setText(db.rs.getString(11));
db.st.close();
String ss=txtFactory[0].getText().trim();
getmodel("select * from 招聘信息 where 单位编号 = "+"'"+ss+"'",1);
lockZhaopin.tableOne.setModel(model);
getmodel("select * from 招聘信息 where 单位编号 = "+"'"+ss+"'",4);
lockZhaopin.tableTwo.setModel(model);
}catch(SQLException e){}
}
//////////企业一级查询
if(parm1.getDocument()==txtMoreFactory[0].getDocument())
{
String s1=choiceFactory1.getSelectedItem().trim();
String s2=txtMoreFactory[0].getText().trim();
getmodel("select * from 企业信息 where "+s1+" like"+" '%"+s2+"%'",0);
lockMoreFactory.tableOne.setModel(model);
getmodel("select * from 企业信息 where "+s1+" like"+" '%"+s2+"%'",2);
lockMoreFactory.tableTwo.setModel(model);
}
//////////企业二级查询
if(parm1.getDocument()==txtMoreFactory[1].getDocument())
{
String s1=choiceFactory1.getSelectedItem().trim();
String s2=txtMoreFactory[0].getText().trim();
String s3=choice1.getSelectedItem().trim();
String s4=choiceFactory2.getSelectedItem().trim();
String s5=txtMoreFactory[1].getText();
getmodel("select * from 企业信息 where "+s1+" like"+" '%"+s2+"%' "+s3+" "+s4+" like"+" '%"+s5+"%' ",0);
lockMoreFactory.tableOne.setModel(model);
getmodel("select * from 企业信息 where "+s1+" like"+" '%"+s2+"%' "+s3+" "+s4+" like"+" '%"+s5+"%' ",2);
lockMoreFactory.tableTwo.setModel(model);
}
//////////招聘一级查询
if(parm1.getDocument()==txtMoreZhaopin[0].getDocument())
{
String s1=choiceZhaopin1.getSelectedItem().trim();
String s2=txtMoreZhaopin[0].getText().trim();
getmodel("select * from 招聘信息 where "+s1+" like"+" '%"+s2+"%'",0);
lockMoreZhaopin.tableOne.setModel(model);
getmodel("select * from 招聘信息 where "+s1+" like"+" '%"+s2+"%'",2);
lockMoreZhaopin.tableTwo.setModel(model);
}
//////////招聘二级查询
if(parm1.getDocument()==txtMoreZhaopin[1].getDocument())
{
String s1=choiceZhaopin1.getSelectedItem().trim();
String s2=txtMoreZhaopin[0].getText().trim();
String s3=choice2.getSelectedItem().trim();
String s4=choiceZhaopin2.getSelectedItem().trim();
String s5=txtMoreZhaopin[1].getText();
getmodel("select * from 招聘信息 where "+s1+" like"+" '%"+s2+"%' "+s3+" "+s4+" like"+" '%"+s5+"%' ",0);
lockMoreZhaopin.tableOne.setModel(model);
getmodel("select * from 招聘信息 where "+s1+" like"+" '%"+s2+"%' "+s3+" "+s4+" like"+" '%"+s5+"%' ",2);
lockMoreZhaopin.tableTwo.setModel(model);
}
}
public void changedUpdate(DocumentEvent parm1) {
// TODO: Add your code here
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -