📄 bikeinfo.java
字号:
leftBox.add(Box.createVerticalStrut(10));
leftBox.add(adressBox);
leftBox.add(Box.createVerticalStrut(10));
leftBox.add(colorBox);
leftBox.add(Box.createVerticalStrut(10));
leftBox.add(Box.createHorizontalGlue());
Box rightBox=Box.createVerticalBox();
rightBox.add(Box.createHorizontalGlue());
rightBox.add(Box.createHorizontalStrut(5));
add=new JButton("确认添加");
add.addActionListener(this);
rightBox.add(add);
rightBox.add(Box.createHorizontalStrut(5));
delete=new JButton("删除");
delete.addActionListener(this);
rightBox.add(delete);
rightBox.add(Box.createHorizontalStrut(5));
search=new JButton("查找");
search.addActionListener(this);
rightBox.add(search);
rightBox.add(Box.createHorizontalStrut(5));
change=new JButton("修改");
rightBox.add(change);
change.addActionListener(this);
rightBox.add(Box.createHorizontalStrut(5));
previous=new JButton("上一个");
previous.addActionListener(this);
rightBox.add(previous);
rightBox.add(Box.createHorizontalStrut(5));
next=new JButton("下一个");
next.addActionListener(this);
rightBox.add(next);
rightBox.add(Box.createHorizontalStrut(5));
first=new JButton("第一个");
first.addActionListener(this);
rightBox.add(first);
rightBox.add(Box.createHorizontalStrut(5));
last=new JButton("最后一个");
last.addActionListener(this);
rightBox.add(last);
rightBox.add(Box.createHorizontalStrut(5));
JLabel rightpanel=new JLabel();
rightBox.add(rightpanel);
rightBox.add(Box.createHorizontalGlue());
split_one=new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,false,leftBox,photoBox);
split_one.setSize(0,50);
split_two=new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,false,split_one,resumeBox);
split_three=new JSplitPane(JSplitPane.HORIZONTAL_SPLIT,false,split_two,rightBox);
Box inputBox=Box.createHorizontalBox();
inputBox.add(split_three,BorderLayout.CENTER);
Border border=BorderFactory.createTitledBorder(
BorderFactory.createLineBorder(Color.BLACK,2),
"自行车销售管理系统",
TitledBorder.CENTER,TitledBorder.ABOVE_TOP,
new Font("GB_2312",Font.BOLD,28),
Color.BLACK);
inputBox.setBorder(border);
Object[][] data={};
Object[] column={"代号","型号","大小","样式","数量","等级","合格","电话","地址","照片","简介"};
model=new DefaultTableModel(data,column);
table=new JTable(model);
table.setShowGrid(true);
JScrollPane tablepane=new JScrollPane(table);
JSplitPane pane=new JSplitPane(JSplitPane.VERTICAL_SPLIT,true,inputBox,tablepane);
con.add(pane,BorderLayout.CENTER);
setSize(600,400);
setVisible(true);
setExtendedState(MAXIMIZED_BOTH);
setResizable(false);
//setSizable(false);
Box bottomBox=Box.createHorizontalBox();
dispTime=new JLabel();
dispTime.setHorizontalAlignment(JLabel.LEFT);
dispTime.setForeground(Color.BLACK);
position.setHorizontalAlignment(JLabel.RIGHT);
position.setText("^-^ 伟伟制作 济南大学 计0239 2002033155 ");
bottomBox.add(position);
bottomBox.add(dispTime);
con.add(bottomBox,BorderLayout.SOUTH);
bottomBox.add(Box.createHorizontalGlue());
ActionListener time=new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
dispTime.setText(new java.util.Date().toString());
}
};
new Timer(1000,time).start();
}
//-----------------------------------------------------------------------------------------------------------
public void actionPerformed(ActionEvent e)
{
if (e.getSource()==toolbarVisible)
{
toolbar.setVisible(toolbarVisible.getState());
}
if (e.getActionCommand().equals("count"))
{
JOptionPane.showMessageDialog(this,"当前人数："+String.valueOf(num),"统计结果",JOptionPane.INFORMATION_MESSAGE);
}
//退出
if (e.getActionCommand().equals("exit"))
{
if (JOptionPane.YES_OPTION==JOptionPane.showConfirmDialog(this,"你确定要退出本系统吗？","确认",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE))
{
System.runFinalization();
}
}
if (e.getSource()==forcolor)
{
JColorChooser colorChooser=new JColorChooser();
Color colors=colorChooser.showDialog(this,"请选择颜色",Color.green);
resume.setForeground(colors);
}
if (e.getSource()==backcolor)
{
JColorChooser colorChooser=new JColorChooser();
Color colors=colorChooser.showDialog(this,"请选择颜色",Color.green);
resume.setBackground(colors);
}
if (e.getSource()==photoButton)
{
JFileChooser photoChooser=new JFileChooser();
if (JFileChooser.APPROVE_OPTION==photoChooser.showOpenDialog(this))
{
filenamepath=photoChooser.getSelectedFile().getPath();
photo.setIcon(new ImageIcon(filenamepath));
}
}
if (e.getSource()==add)
{
if (JOptionPane.YES_OPTION==JOptionPane.showConfirmDialog(this,"你确认要添加吗？","确认",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE))
{
Connection con=null;
Statement sql=null;
Statement sql2=null;
Statement sql3=null;
Statement sql4=null;
ResultSet result;
ResultSet result2;
ResultSet result3;
ResultSet result4;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ee)
{
System.out.println(""+ee);
}
try
{
Object[] object=
{
studentnumber.getText(),
name.getText(),
new String(password.getText()),
sex.getSelectedItem(),
age.getText(),
grade.getSelectedItem(),
new Boolean(party.isSelected()),
telephone.getText(),
adress.getText(),
photo.getIcon(),
resume.getText(),
};
model.addRow(object);
num++;
con=DriverManager.getConnection("jdbc:odbc:me2","zww","123");
sql=con.createStatement();
sql2=con.createStatement();
sql3=con.createStatement();
sql4=con.createStatement();
result2=sql2.executeQuery("SELECT * FROM student1");
result4=sql4.executeQuery("SELECT * FROM student");
String temps=studentnumber.getText();
long templong=Long.parseLong(temps);
boolean tempbool=false;
while(result4.next())
{
if(result4.getLong("sn")==templong)
{
JOptionPane.showMessageDialog(this,"该代号已存在，请重新输入！","警告",JOptionPane.WARNING_MESSAGE);
studentnumber.setText("");
name.setText("");
password.setText("");
telephone.setText("");
adress.setText("");
sex.setSelectedIndex(0);
party.setSelected(false);
age.setText("");
grade.setSelectedIndex(0);
resume.setText("");
photo.setIcon(new ImageIcon("2.gif"));
con.close();
tempbool=true;
}
}
//name.setText("===============3");
if(tempbool==false)
{
//name.setText("===============2");
while(result2.next())
{
idcount=result2.getInt("ID");
idcount2=idcount+1;
}
//name.setText("===============1");
String s1=studentnumber.getText();
long t1=Long.parseLong(s1);
String s2="'"+name.getText()+"'";
String temps3=new String(password.getText());
String s3="'"+temps3+"'";
int t4=sex.getSelectedIndex();
String s5=age.getText();
int t5=Integer.parseInt(s5);
int t6=grade.getSelectedIndex();
//boolean bool7;
String s8="'"+telephone.getText()+"'";
String s9="'"+adress.getText()+"'";
String s10="'"+filenamepath+"'";
String s11="'"+resume.getText()+"'";
String temp="INSERT INTO studentb VALUES("+idcount+","+t1+","+s2+","+s3+","+t4+","+t5+","+t6+","+new Boolean(party.isSelected())+","+s8+","+s9+","+s10+","+s11+")";
sql.executeUpdate(temp);
String temp2="UPDATE studentb1 SET ID="+idcount2+" WHERE ID="+idcount+"";
sql3.executeUpdate(temp2);
con.close();
JOptionPane.showMessageDialog(this,"输入成功！","消息提示",JOptionPane.INFORMATION_MESSAGE);
studentnumber.setText("");
name.setText("");
password.setText("");
telephone.setText("");
adress.setText("");
sex.setSelectedIndex(0);
party.setSelected(false);
age.setText("");
grade.setSelectedIndex(0);
resume.setText("");
photo.setIcon(new ImageIcon("2.gif"));
con.close();
}
}
catch(SQLException e1)
{
}
}
}
if(e.getSource()==delete)
{
Connection con=null;
Statement sql=null;
Statement sql2=null;
ResultSet result2;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e2)
{
System.out.println(""+e);
}
try
{
if (JOptionPane.YES_OPTION==JOptionPane.showConfirmDialog(this,"你确认要删除吗？","确认",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE))
{
con=DriverManager.getConnection("jdbc:odbc:me2","zww","123");
sql=con.createStatement();
sql2=con.createStatement();
result2=sql2.executeQuery("SELECT * FROM student");
String temps=studentnumber.getText();
long templong=Long.parseLong(temps);
boolean tempbool=false;
while(result2.next())
{
if(result2.getLong("sn")==templong)
{
sql.executeUpdate("DELETE FROM studentb WHERE sn="+templong+"");
tempbool=true;
JOptionPane.showMessageDialog(this,"删除成功！","提示",JOptionPane.INFORMATION_MESSAGE);
studentnumber.setText("");
name.setText("");
password.setText("");
telephone.setText("");
adress.setText("");
sex.setSelectedIndex(0);
party.setSelected(false);
age.setText("");
grade.setSelectedIndex(0);
resume.setText("");
photo.setIcon(new ImageIcon("2.gif"));
con.close();
}
}
if(tempbool==false)
{
studentnumber.setText("");
name.setText("");
password.setText("");
telephone.setText("");
adress.setText("");
sex.setSelectedIndex(0);
party.setSelected(false);
age.setText("");
grade.setSelectedIndex(0);
resume.setText("");
photo.setIcon(new ImageIcon("2.gif"));
con.close();
JOptionPane.showMessageDialog(this,"该代号不存在，请重新输入！","警告",JOptionPane.WARNING_MESSAGE);
}
}
}
catch(SQLException ee2)
{
}
}
if(e.getSource()==search)
{
Connection con=null;
Statement sql=null;
ResultSet result;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e3)
{
System.out.println(""+e);
}
try
{
con=DriverManager.getConnection("jdbc:odbc:me2","zww","123");
sql=con.createStatement();
result=sql.executeQuery("SELECT * FROM studentb");
String temps=studentnumber.getText();
long templong=Long.parseLong(temps);
boolean tempbool=false;
while(result.next())
{
if(result.getLong("sn")==templong)
{
tempbool=true;
String tempsn=String.valueOf(templong);
studentnumber.setText(tempsn);
name.setText(result.getString("name"));
password.setText(result.getString("password"));
telephone.setText(result.getString("telephone"));
adress.setText(result.getString("adress"));
sex.setSelectedIndex(result.getInt("sex"));
party.setSelected(result.getBoolean("party"));
age.setText(result.getString("age"));
grade.setSelectedIndex(result.getInt("grade"));
resume.setText(result.getString("resume"));
photo.setIcon(new ImageIcon(result.getString("photo")));
}
}
if(tempbool==false)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -