帮我分析代码
@Override
public void actionPerformed(ActionEvent actionEvent) {
System.exit(10);
}
});
c.add(juj);
jButton=new JButton("交流");
jButton.setFont(new Font("黑体", 0, 15));
jButton.setBounds(1045, 198, 80, 40);
jButton.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent actionEvent) {
new Login();
}
});
c.add(jButton);
JTabbedPane jtb = new JTabbedPane();
jtb.setFont(new Font("黑体",4,26));
jtb.setBounds(43, 200, 1200, 780);
c.add(jtb);
JTabbedPane jtbp = new JTabbedPane();
jtbp.setFont(new Font("黑体",4,20));
jtbp.setBounds(43, 200, 1200, 780);
Object[][] tableDate = new Object[40][3];
Object[] name = {"id", "设备编号", "类别名称"};
JPanel p1 = new JPanel();
p1.setLayout(null);
p1.setBounds(0, 100, 800, 900);
JTable d=new JTable(tableDate,name);
d.setRowHeight(25);
JScrollPane js = new JScrollPane(d);
js.setBounds(0, 0, 700, 500);
p1.add(js);
jb = new JButton("查询全部");
jb.setIcon(new ImageIcon("C:\\Users\\Lenovo-pc\\IdeaProjects\\ShiXun\\src\\image\\2.png"));
jb.setBounds(730, 35, 120, 35);
jb.setFont(new Font("黑体", 0, 15));
jb.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent actionEvent) {
try {
bw.write(myfmt.format(new java.util.Date()).toString()+"\n");
bw.write("查询全部设备类别信息\n");
bw.flush();
}catch (Exception e){
e.printStackTrace();
}
for(int i=0;i<40;i++)
{
for(int j=0;j<3;j++)
{
d.setValueAt(" ",i,j);
}
}
try {
ps = con.prepareStatement("select * from device1");
rs = ps.executeQuery();
for (int i = 0; rs.next(); i++) {
int id = rs.getInt(1);
int num = rs.getInt(2);
String name = rs.getString(3);
d.setValueAt(Integer.toString(id), i, 0);
d.setValueAt(Integer.toString(num), i, 1);
d.setValueAt(name, i, 2);
}
} catch (Exception throwables) {
throwables.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
if (ps != null) {
ps.close();
}
} catch (SQLException a) {
a.printStackTrace();
}
}
}
});
p1.add(jb);
jb1 = new JButton("查询");
jb1.setBounds(730, 80, 120, 35);
jb1.setIcon(new ImageIcon("C:\\Users\\Lenovo-pc\\IdeaProjects\\ShiXun\\src\\image\\3.png"));
jb1.setFont(new Font("黑体", 0, 15));
jb1.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent actionEvent) {
String st1 = JOptionPane.showInputDialog(null, "设备编号", "查询", 1);
System.out.println(st1);
int m = 0;
try {
ps = con.prepareStatement("select * from device1");
rs = ps.executeQuery();
while (rs.next()) {
int num = rs.getInt(2);
String a = "" + num;
if (st1.equals(a)) {
m = 1;
int id = rs.getInt(1);
String name = rs.getString(3);
d.setValueAt(Integer.toString(id), 0, 0);
d.setValueAt(Integer.toString(num), 0, 1);
d.setValueAt(name, 0, 2);
}
}
if (m == 0) { try {
bw.write(myfmt.format(new java.util.Date()).toString()+"\n");
bw.write("查询的设备类别数据不存在");
bw.flush();
bw.close();
}catch (Exception e){
e.printStackTrace();
}
JOptionPane.showMessageDialog(null, "您查找的数据不存在", "提示:", JOptionPane.ERROR_MESSAGE);
}
} catch (Exception throwables) {
throwables.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
if (ps != null) {
ps.close();
}
} catch (SQLException a) {
a.printStackTrace();
}
}
}
});
p1.add(jb1);
jb2 = new JButton("增加");
jb2.setBounds(730, 125, 120, 35);
jb2.setIcon(new ImageIcon("C:\\Users\\Lenovo-pc\\IdeaProjects\\ShiXun\\src\\image\\4.png"));
jb2.setFont(new Font("黑体", 0, 15));
jb2.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent actionEvent) {
JDialog jd1 = new JDialog();
jd1.setLayout(null);
jd1.setTitle("增加");
jd1.setBounds(900, 200, 600, 600);
JLabel ja=new JLabel("请输入新的信息");
ja.setFont(new Font("华文行楷",4,20));
ja.setBounds(225,-80,200,200);
jd1.add(ja,BorderLayout.NORTH);
JLabel ja1=new JLabel("id:");
ja1.setFont(new Font("华文行楷",4,18));
ja1.setBounds(40,48,40,40);
jd1.add(ja1 );
SimpleDateFormat myfmt = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
Integer qw=myfmt.format(new java.util.Date()).toString().hashCode();
JLabel jt1=new JLabel();
jt1.setFont(new Font("黑体",4,19));
jt1.setText(qw.toString());
jt1.setBounds(110,58,180,25);
jd1.add(jt1 );
JLabel ja2=new JLabel("设备编号:");
ja2.setFont(new Font("华文行楷",4,18));
ja2.setBounds(20,120,80,40);
jd1.add(ja2 );
JTextField jt2=new JTextField();
jt2.setColumns(20);
jt2.setBounds(110,128,100,25);
jd1.add(jt2 );
JLabel ja3=new JLabel("类别名称:");
ja3.setFont(new Font("华文行楷",4,18));
ja3.setBounds(20,180,80,40);
jd1.add(ja3 );
JTextField jt3=new JTextField();
jt3.setColumns(20);
jt3.setBounds(110,190,100,25);
jd1.add(jt3 );
JButton jb = new JButton("确定");
jb.setBounds(110,320,90,30);
jd1.add(jb);
jd1.setVisible(true);
jb.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent actionEvent) {
Integer a=Integer.valueOf(jt1.getText());
Integer b=Integer.valueOf(jt2.getText());
String c=jt3.getText();
try {
String sql = "insert into device1 values" +"(" + a + "," +b + ",'" + c + "'"+ ")";
PreparedStatement ps = con.prepareStatement(sql);
ps.executeUpdate();
}catch (Exception throwables) {
throwables.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
if (ps != null) {
ps.close();
}
} catch (SQLException a1) {
a1.printStackTrace();
}
}
}
});
}
});
p1.add(jb2);
jb3 = new JButton("删除");
jb3.setBounds(730, 170, 120, 35);
jb3.setIcon(new ImageIcon("C:\\Users\\Lenovo-pc\\IdeaProjects\\ShiXun\\src\\image\\5.png"));
jb3.setFont(new Font("黑体", 0, 15));
jb3.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent actionEvent) {
int row=d.getSelectedRow();
if(row!=-1) {
int result = JOptionPane.showConfirmDialog(null, "确定要删除吗?","请确认",JOptionPane.YES_NO_OPTION);
if(result==JOptionPane.OK_OPTION)
{
try {
String sql = "DELETE FROM device1 WHERE num"+"="+Integer.parseInt(d.getValueAt(row,1).toString());
PreparedStatement ps = con.prepareStatement(sql);
ps.executeUpdate();
} catch (Exception throwables) {
throwables.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
if (ps != null) {
ps.close();
}
} catch (SQLException a1) {
a1.printStackTrace();
}
}
}
}else{
JOptionPane.showMessageDialog(null, "请选择要删除的行!","提示:",JOptionPane.ERROR_MESSAGE);
}
}
});
p1.add(jb3);
jb4 = new JButton("修改");
jb4.setBounds(730, 215, 120, 35);
jb4.setIcon(new ImageIcon("C:\\Users\\Lenovo-pc\\IdeaProjects\\ShiXun\\src\\image\\6.png"));
jb4.setFont(new Font("黑体", 0, 15));
p1.add(jb4);
jb4.addActionListener(new ActionListener() {
@Override
public void actionPerformed (ActionEvent act) {
int row=d.getSelectedRow();
if(row!=-1) {
int result = JOptionPane.showConfirmDialog(null, "确定要修改吗?","请确认",JOptionPane.YES_NO_OPTION);
if(result==JOptionPane.OK_OPTION)
{
JDialog jd1 = new JDialog();
jd1.setLayout(null);
jd1.setTitle("修改");
jd1.setBounds(900, 200, 600, 600);
JLabel ja=new JLabel("请输入新的信息");
ja.setFont(new Font("华文行楷",4,20));
ja.setBounds(225,-80,200,200);
jd1.add(ja,BorderLayout.NORTH);
JLabel ja1=new JLabel("编号:");
ja1.setFont(new Font("华文行楷",4,18));
ja1.setBounds(20,48,60,40);
jd1.add(ja1 );
JTextField jt1=new JTextField();
jt1.setText(d.getValueAt(row,1).toString());
jt1.setColumns(20);
jt1.setBounds(110,58,100,25);
jd1.add(jt1 );
JLabel ja2=new JLabel("类别名称:");
ja2.setFont(new Font("华文行楷",4,18));
ja2.setBounds(20,120,80,40);
jd1.add(ja2 );
JTextField jt2=new JTextField();
jt2.setText(d.getValueAt(row,2).toString());
jt2.setColumns(20);
jt2.setBounds(110,128,100,25);
jd1.add(jt2 );
JButton jb = new JButton("确定");
jb.setBounds(110,320,90,30);
jd1.add(jb);
jd1.setVisible(true);
jb.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent actionEvent) {
String st2=jt2.getText();
String st1=jt1.getText();
Integer a=Integer.parseInt(jt1.getText());
String b=jt2.getText();
try {
String sql="update device1 set name='"+b+"' where num="+Integer.parseInt(d.getValueAt(row,1).toString());
ps= con.prepareStatement(sql);
ps.executeUpdate();
}catch (Exception throwables) {
throwables.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
}
if (ps != null) {
ps.close();
}
} catch (SQLException y) {
y.printStackTrace();
}
}
}
});
}
}else{
JOptionPane.showMessageDialog(null, "请选择修改的行!","提示:",JOptionPane.ERROR_MESSAGE);
}
}
});
jtb.add("设备类别管理",p1);
Object[][] table1 = new Object[40][4];
Object[] name2 = {"部门编号", "部门名称", "负责人","电话"};
JPanel p2 = new JPanel();
p2.setLayout(null);
p2.setBounds(0, 100, 800, 500);
JTable d3=new JTable(table1,name2);
d3.setRowHeight(25);
JScrollPane js3 = new JScrollPane(d3);
js3.setBounds(0, 0, 700, 400);
p2.add(js3);
jn = new JButton("查询全部");
jn.setIcon(new ImageIcon("C:\\Users\\Lenovo-pc\\IdeaProjects\\ShiXun\\src\\image\\2.png"));
jn.setBounds(730, 35, 120, 35);
jn.setFont(new Font("黑体", 0, 15));
最新发布