📄 basicinfo.java
字号:
+ Sdate.getText() + "',Edate='"
+ Edate.getText() + "',Company='"
+ Company.getText() + "',Dep='"
+ eDep.getText() + "',Duty='"
+ eDuty.getText()+ "'WHERE Sid='"
+ sid + "'");
}
stmt.close();
break;
case 2:// 更新家庭成员
rs = stmt.executeQuery("select * from Family where Sid='"
+ sid + "'");// 基本资料数据库查询
if (!rs.next())// 没有查询结果,则需要在数据库中新增界面上的信息
{
System.out.println("需要插入新行");
String str;
str="insert into Family";
str=str+"(";
str=str+"Sid,"+"Name,"+"Relation,"+"Tel,"+"Com,"+"Brief";
str=str+")"+"values(";
str=str+"'"+sid+"',";
str=str+"'"+pName.getText()+"',";
str=str+"'"+Relation.getText()+"',";
str=str+"'"+Tel.getText()+"',";
str=str+"'"+Com.getText()+"',";
str=str+"'"+Brief.getText()+"'";
str=str+")";
stmt.executeUpdate(str);
} else {// 修改新输入的内容
System.out.println("需要更新列表");
stmt.executeUpdate("update Family SET Sid='"
+ sid + "',Name='"
+ pName.getText() + "',Relation='"
+ Relation.getText() + "',Tel='"
+ Tel.getText() + "',Com='"
+ Com.getText() + "',Brief='"
+ Brief.getText()+ "'WHERE Sid='"
+ sid + "'");
}
stmt.close();
break;
case 3:// 更新奖惩记录
rs = stmt.executeQuery("select * from Honor where Sid='"
+ sid + "'");// 基本资料数据库查询
if (!rs.next())// 没有查询结果,则需要在数据库中新增界面上的信息
{
System.out.println("需要插入新行");
String str;
str="insert into Honor";
str=str+"(";
str=str+"Sid,"+"Sort,"+"Topic,"+"Dep,"+"Mdate,"+"Des";
str=str+")"+"values(";
str=str+"'"+sid+"',";
str=str+"'"+Sort.getSelectedItem()+"',";
str=str+"'"+Topic.getText()+"',";
str=str+"'"+mDep.getText()+"',";
str=str+"'"+Mdate.getText()+"',";
str=str+"'"+Des.getText()+"'";
str=str+")";
stmt.executeUpdate(str);
System.out.println("更新列表结束");
} else {// 修改新输入的内容
System.out.println("需要更新列表");
stmt.executeUpdate("update Honor SET Sid='"
+ sid + "',Sort='"
+ Sort.getSelectedItem() + "',Topic='"
+ Topic.getText() + "',Dep='"
+ mDep.getText() + "',Mdate='"
+ Mdate.getText() + "',Des='"
+ Des.getText() + "'WHERE Sid='"
+ sid + "'");
}
stmt.close();
break;
default:
break;
}
// stmt.close();
conn.close();
} catch (Exception ex) {
//ex.printStackTrace();
JOptionPane.showMessageDialog(this, "没有填写员工信息，保存失败","提示",JOptionPane.ERROR_MESSAGE);
}
}
}
void delInfo(JTabbedPane tabbedPane4) {// 删除按钮的响应事件，使界面内容相应更新，删除数据库中相应内容
int number = 0;// 记录当前选中的行号,列表中的员工号和姓名应为空
number = table.getSelectedRow();
// System.out.println("sid="+number);
if (number < 0) {
return;
}
else
{
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:Password";
Connection conn = DriverManager.getConnection(url, "", "");
Statement stmt = conn.createStatement();
String sid;
sid = (String) table.getValueAt(number, 1);// 获得当前选中的员工列表中的员工号
switch (tabbedPane4.getSelectedIndex()) {
case 0:// 保存基本资料
ResultSet rs = stmt.executeQuery("select * from BaseInfo where Stano='"+ sid + "'");// 基本资料数据库查询
if (!rs.next())
{
tmodel.removeRow(number);
table.updateUI();
return;
}
else
{
stmt.executeUpdate("delete from BaseInfo where Stano='"
+ sid + "'");
tmodel.removeRow(number);
table.updateUI();
}
stmt.close();
break;
case 1:// 更新工作经历
rs = stmt.executeQuery("select * from History where Sid='"+ sid + "'");// 基本资料数据库查询
if (!rs.next())// 没有查询结果,则需要在数据库中新增界面上的信息
{
return;
}
else
{
stmt.executeUpdate("delete from History where Sid='"
+ sid + "'");
}
stmt.close();
break;
case 2:// 更新家庭成员
rs = stmt.executeQuery("select * from Family where Sid='"+ sid + "'");// 基本资料数据库查询
if (!rs.next())// 没有查询结果,则需要在数据库中新增界面上的信息
{
return;
}
else
{
System.out.println("需要删除列表");
stmt.executeUpdate("delete from Family where Sid='"
+ sid + "'");
}
stmt.close();
break;
case 3:// 更新奖惩记录
rs = stmt.executeQuery("select * from Honor where Sid='"+ sid + "'");// 基本资料数据库查询
if (!rs.next())// 没有查询结果,则需要在数据库中新增界面上的信息
{
return;
}
else
{
System.out.println("需要删除列表");
stmt.executeUpdate("delete from Honor where Sid='"
+ sid + "'");
System.out.println("更新列表结束");
}
stmt.close();
break;
default:
break;
}
// stmt.close();
conn.close();
} catch (Exception ex) {
// ex.printStackTrace();
JOptionPane.showMessageDialog(this, "没有选中员工信息，删除失败","提示",JOptionPane.ERROR_MESSAGE);
}
}
}
void otherRefresh(JTabbedPane tabbedPane1) {// 更新界面
// System.out.println("更新界面");
int number = 0;// 记录当前选中的行号
number = table.getSelectedRow();
// System.out.println("sid="+number);
if (number < 0) {
return;
} else {
String sid;
sid = (String) table.getValueAt(number, 1);// 获得当前选中的员工列表中的员工号
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:Password";
Connection conn = DriverManager.getConnection(url, "", "");
Statement stmt = conn.createStatement();
switch (tabbedPane1.getSelectedIndex()) {
case 0:// 更新基本资料
ResultSet rs = stmt
.executeQuery("select * from BaseInfo where Stano='"
+ sid + "'");// 基本资料数据库查询
if (!rs.next())// 没有查询结果
{
Stano.setText("");
SName.setText("");
Sex.setText("");
Birth.setText("");
SDep.setText("");
SDuty.setText("");
Folk.setText("");
studyLevel.setText("");
Special.setText("");
Cardno.setText("");
Recno.setText("");
Politics.setText("");
Married.setText("");
Indate.setText("");
Body.setText("");
Baryear.setText("");
Barstart.setText("");
Barend.setText("");
Address.setText("");
SBrief.setText("");
} else {
Stano.setText(rs.getString("Stano"));
SName.setText(rs.getString("Name"));
Sex.setText(rs.getString("Sex"));
Birth.setText(rs.getString("Birth"));
SDep.setText(rs.getString("Dep"));
SDuty.setText(rs.getString("Duty"));
Folk.setText(rs.getString("Folk"));
studyLevel.setText(rs.getString("studyLevel"));
Special.setText(rs.getString("Special"));
Cardno.setText(rs.getString("Cardno"));
Recno.setText(rs.getString("Recno"));
Politics.setText(rs.getString("Politics"));
Married.setText(rs.getString("Married"));
Indate.setText(rs.getString("Indate"));
Body.setText(rs.getString("Body"));
Baryear.setText(rs.getString("Baryear"));
Barstart.setText(rs.getString("Barstart"));
Barend.setText(rs.getString("Barend"));
Address.setText(rs.getString("Address"));
SBrief.setText(rs.getString("Brief"));
}
rs.close();
rs = null;
stmt.close();
break;
case 1:// 更新工作经历
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from History where Sid='"
+ sid + "'");// 工作经历数据库查询
if (!rs.next())// 没有查询结果
{
Sdate.setText("");
Edate.setText("");
Company.setText("");
eDep.setText("");
eDuty.setText("");
} else {
Sdate.setText(rs.getString("Sdate"));
Edate.setText(rs.getString("Edate"));
Company.setText(rs.getString("Company"));
eDep.setText(rs.getString("Dep"));
eDuty.setText(rs.getString("Duty"));
}
rs.close();
rs = null;
stmt.close();
break;
case 2:// 更新家庭成员
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from Family where Sid='"
+ sid + "'");// 工作经历数据库查询
if (!rs.next())// 没有查询结果
{
pName.setText("");
Relation.setText("");
Tel.setText("");
Com.setText("");
Brief.setText("");
} else {
pName.setText(rs.getString("Name"));
Relation.setText(rs.getString("Relation"));
Tel.setText(rs.getString("Tel"));
Com.setText(rs.getString("Com"));
Brief.setText(rs.getString("Brief"));
}
rs.close();
rs = null;
stmt.close();
break;
case 3:// 更新奖惩记录
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from Honor where Sid='"
+ sid + "'");// 工作经历数据库查询
if (!rs.next())// 没有查询结果
{
Sort.setSelectedItem("");
Topic.setText("");
mDep.setText("");
Mdate.setText("");
Des.setText("");
} else {
Sort.setSelectedItem(rs.getString("Sort"));
Topic.setText(rs.getString("Topic"));
mDep.setText(rs.getString("Dep"));
Mdate.setText(rs.getString("Mdate"));
Des.setText(rs.getString("Des"));
}
rs.close();
rs = null;
stmt.close();
break;
default:
break;
}
// stmt.close();
// conn.close();
} catch (Exception ex) {
JOptionPane.showMessageDialog(this, ex.toString());
}
}
}
public static void main(String args[]) {
try {
BasicInfo frame = new BasicInfo();
frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* Create the frame
*/
public BasicInfo() {
super();
setTitle("基本档案管理");
setBounds(100, 100, 673, 453);
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
final JTabbedPane tabbedPane = new JTabbedPane();
final JPanel panel = new JPanel();
panel.setLayout(new GridBagLayout());
getContentPane().add(panel, BorderLayout.CENTER);
final JScrollPane scrollPane;
// = new JScrollPane();
final GridBagConstraints gridBagConstraints = new GridBagConstraints();
gridBagConstraints.ipady = 305;
gridBagConstraints.ipadx = 185;
gridBagConstraints.insets = new Insets(0, 0, 0, 20);
gridBagConstraints.gridy = 0;
gridBagConstraints.gridx = 0;
table = new JTable(tmodel);
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:Password";
Connection conn = DriverManager.getConnection(url, "", "");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select Stano,Name from BaseInfo ");// 基本资料数据库查询
//System.out.println("Stano=",rs)
while(rs.next())
{
tmodel.addRow(rs.getString("Stano"), rs.getString("Name"));
}
} catch (Exception ex) {
JOptionPane.showMessageDialog(this, ex.toString());
}
table.setBackground(new Color(128, 128, 255));
// table.setModel(tmodel);
// table.setCellEditor(null);
table.updateUI();
scrollPane = new JScrollPane(table);
table.addMouseListener(new MouseAdapter() {
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -