📄 jiemian.java
字号:
*/
private JComboBox getJComboBox2() {
if (jComboBox2 == null) {
String jc_checi[]={"P001","Z020"};
jComboBox2 = new JComboBox(jc_checi);
jComboBox2.setBounds(new Rectangle(91, 14, 98, 32));
jComboBox2.addItemListener(new java.awt.event.ItemListener() {
public void itemStateChanged(java.awt.event.ItemEvent e) {
System.out.println("itemStateChanged()"); // TODO Auto-generated Event stub itemStateChanged()
checi=(String)e.getItem();
System.out.print((String)e.getItem());
}
});
}
return jComboBox2;
}
/**
* This method initializes jButton2
*
* @return javax.swing.JButton
*/
private JButton getJButton2() {
if (jButton2 == null) {
jButton2 = new JButton();
jButton2.setBounds(new Rectangle(377, 14, 80, 32));
jButton2.setFont(new Font("\u6977\u4f53_GB2312", Font.BOLD, 12));
jButton2.setText(" 查 询");
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
String sql=null;
//sql="select * from chapiao where 车次=" + checi + " and " + "时间=" + date ;
sql="select * from chapiao where 车次=" + "'" + checi +"'" + " and " + "日期=" + "'" + date + "'" ;
//tt=new TrainTable();
// if(tt==null)
// {System.out.print(2);}
//jScrollPane.add(getJTable(tt));
//jPanel.add(getJScrollPane(tt),null);
System.out.print(sql);
jTable1.refresh(sql);
}
});
}
return jButton2;
}
/**
* This method initializes jButton3
*
* @return javax.swing.JButton
*/
private JButton getJButton3() {
if (jButton3 == null) {
jButton3 = new JButton();
jButton3.setBounds(new Rectangle(464, 14, 80, 32));
jButton3.setFont(new Font("\u6977\u4f53_GB2312", Font.BOLD, 12));
jButton3.setText(" 订 票");
jButton3.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
//int i;
//String s[];
if(ce==true)
{
TrainManager tm=new TrainManager();
/*for(i=0;i<jTable.getColumnCount();i++)
{
s=jTable.getValueAt(jTable.getSelectedRow(),i);
}*/
//System.out.print(s[0].toString());
String sql=null;
sql="insert into yishoupiao values(" + "'" + jTable1.getValueAt(jTable1.getSelectedRow(),0)
+"','" + jTable1.getValueAt(jTable1.getSelectedRow(),1)
+"','" + jTable1.getValueAt(jTable1.getSelectedRow(),2)
+"','" + jTable1.getValueAt(jTable1.getSelectedRow(),3)
+"','" + jTable1.getValueAt(jTable1.getSelectedRow(),4)
+"','" + jTable1.getValueAt(jTable1.getSelectedRow(),5)
+"','" + jTable1.getValueAt(jTable1.getSelectedRow(),6)
+"','" + jTable1.getValueAt(jTable1.getSelectedRow(),7)
+"','" + jTable1.getValueAt(jTable1.getSelectedRow(),8)
+"','" + jTable1.getValueAt(jTable1.getSelectedRow(),9)
+"','" + jTable1.getValueAt(jTable1.getSelectedRow(),10)
+"','" + jTable1.getValueAt(jTable1.getSelectedRow(),11)+"')";
//boolean bl;
tm.insertBj(sql);
sql="delete from chapiao where 票号="+jTable.getValueAt(jTable1.getSelectedRow(),0);
//sql="delete from chapiao where 票号=2";
tm.deleteBj(sql);
jTable.refresh(tm);
jTable1.refresh(tm);
jTable2.refresh("select * from yishoupiao");
}
else
{
JOptionPane.showMessageDialog(null,"请插卡");
}
}
});
}
return jButton3;
}
/**
* This method initializes jTextField
*
* @return javax.swing.JTextField
*/
/* private JTextField getJTextField() {
jTextField = new JTextField(30);
jTextField.setBounds(new Rectangle(65, 14, 250, 32));
//jTextField.setEditable(true);
//jTextField.setEnabled(false);
return jTextField;
}*/
/**
* This method initializes jButton6
*
* @return javax.swing.JButton
*/
private JButton getJButton6() {
if (jButton6 == null) {
jButton6 = new JButton();
jButton6.setBounds(new Rectangle(200, 14, 200, 32));
jButton6.setFont(new Font("\u6977\u4f53_GB2312", Font.BOLD, 12));
jButton6.setActionCommand("确定");
jButton6.setText("退票请点击后输入票号");
jButton6.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
//System.out.print(jTextField.isEditable());
TrainManager tm=new TrainManager();
String sql="delete from yishoupiao where 票号=";
String str="select * from yishoupiao where 票号=";
String string=null;
//boolean ding;
string=JOptionPane.showInputDialog(null,"输入票号");
if(string!=null)
{
sql=sql+string;
System.out.print(sql);
str=str+string;
if(sql.equals("delete from yishoupiao where 票号="))
{
JOptionPane.showMessageDialog(null,"票号不能为空");
}
else
{
true_false tf =new true_false();
tm.deletetui(sql,str);
if(tf.get_true_false()==true)
{
JOptionPane.showMessageDialog(null,"退 票 成 功");
jTable2.refresh("select * from yishoupiao");
}
else if(tf.get_true_false()==false)
{
JOptionPane.showMessageDialog(null,"退票失败，票号不匹配");
}
else
{
//JOptionPane.showMessageDialog(null,"退票失败，数据库错误");
}
}
}
}
});
}
return jButton6;
}
/**
* This method initializes jButton7
*
* @return javax.swing.JButton
*/
/*private JButton getJButton7() {
if (jButton7 == null) {
jButton7 = new JButton();
jButton7.setBounds(new Rectangle(447, 15, 80, 32));
jButton7.setFont(new Font("\u6977\u4f53_GB2312", Font.BOLD, 12));
jButton7.setActionCommand("取 消");
jButton7.setText("重 置");
jButton7.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
}
});
}
return jButton7;
}*/
/**
* This method initializes jScrollPane
*
* @return javax.swing.JScrollPane
*/
private JScrollPane getJScrollPane() {
if (jScrollPane == null) {
jScrollPane = new JScrollPane();
jScrollPane.setBounds(new Rectangle(17, 58, 558, 391));
jScrollPane.setViewportView(getJTable());
}
return jScrollPane;
}
private JScrollPane getJScrollPane(TrainTable tt) {
//jScrollPane = new JScrollPane();
jScrollPane.setBounds(new Rectangle(17, 58, 558, 391));
//jScrollPane.setViewportView(getJTable());
return jScrollPane;
}
/**
* This method initializes jTable
*
* @return javax.swing.JTable
*/
private TrainTable getJTable() {
if (jTable == null) {
jTable = new TrainTable();
//TrainTable tt=new TrainTable();
}
return jTable;
}
private TrainTable getJTable(TrainTable tt) {
//jTable=new JTable();
jTable=tt;
//TrainTable tt=new TrainTable();
return jTable;
}
/**
* This method initializes jScrollPane1
*
* @return javax.swing.JScrollPane
*/
private JScrollPane getJScrollPane1() {
if (jScrollPane1 == null) {
jScrollPane1 = new JScrollPane();
jScrollPane1.setBounds(new Rectangle(13, 57, 568, 391));
jScrollPane1.setViewportView(getJTable2());
}
return jScrollPane1;
}
/**
* This method initializes jTable2
*
* @return javax.swing.JTable
*/
private TrainTable getJTable2() {
if (jTable2 == null) {
jTable2 = new TrainTable("select * from yishoupiao");
}
return jTable2;
}
/**
* This method initializes jScrollPane2
*
* @return javax.swing.JScrollPane
*/
private JScrollPane getJScrollPane2() {
if (jScrollPane2 == null) {
jScrollPane2 = new JScrollPane();
jScrollPane2.setBounds(new Rectangle(14, 60, 556, 377));
jScrollPane2.setViewportView(getJTable1());
}
return jScrollPane2;
}
/**
* This method initializes jTable1
*
* @return javax.swing.JTable
*/
private TrainTable getJTable1() {
if (jTable1 == null) {
jTable1 = new TrainTable();
}
return jTable1;
}
/**
* This method initializes jButton9
*
* @return javax.swing.JButton
*/
private JButton getJButton9() {
if (jButton9 == null) {
jButton9 = new JButton();
jButton9.setBounds(new Rectangle(665, 475, 142, 38));
jButton9.setForeground(Color.blue);
jButton9.setActionCommand("检 卡");
jButton9.setText("未 插 卡");
jButton9.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
if (ce==true)
{
jButton9.setText("未 插 卡");
ce=false;
}
else
{
jButton9.setText("计费卡使用中");
ce=true;
}
}
});
}
return jButton9;
}
/**
* This method initializes jButton8
*
* @return javax.swing.JButton
*/
private JButton getJButton8() {
if (jButton8 == null) {
jButton8 = new JButton();
jButton8.setBounds(new Rectangle(665, 529, 142, 38));
jButton8.setFont(new Font("\u6977\u4f53_GB2312", Font.BOLD, 12));
jButton8.setForeground(Color.blue);
jButton8.setText("退 出");
jButton8.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
System.exit(0);
}
});
}
return jButton8;
}
/**
* This method initializes jComboBox3
*
* @return javax.swing.JComboBox
*/
private JComboBox getJComboBox3() {
if (jComboBox3 == null) {
String jc_date[]={"2月24日","2月25日","2月26日","2月27日"};
jComboBox3 = new JComboBox(jc_date);
jComboBox3.setBounds(new Rectangle(323, 14, 98, 32));
jComboBox3.addItemListener(new java.awt.event.ItemListener() {
public void itemStateChanged(java.awt.event.ItemEvent e) {
System.out.println("itemStateChanged()"); // TODO Auto-generated Event stub itemStateChanged()
date=(String)e.getItem();
System.out.print((String)e.getItem());
}
});
}
return jComboBox3;
}
/**
* This method initializes jComboBox4
*
* @return javax.swing.JComboBox
*/
private JComboBox getJComboBox4() {
if (jComboBox4 == null) {
String jc_date[]={"2月24日","2月25日","2月26日","2月27日"};
jComboBox4 = new JComboBox(jc_date);
jComboBox4.setBounds(new Rectangle(266, 14, 98, 34));
jComboBox4.addItemListener(new java.awt.event.ItemListener() {
public void itemStateChanged(java.awt.event.ItemEvent e) {
System.out.println("itemStateChanged()"); // TODO Auto-generated Event stub itemStateChanged()
date=(String)e.getItem();
System.out.print((String)e.getItem());
}
});
}
return jComboBox4;
}
/*public static void main(String[] args) {
// TODO Auto-generated method stub
Jiemian jj=new Jiemian();
jj.show();
}*/
/**
* This method initializes this
*
* @return void
*/
private void initialize() {
this.setSize(850, 600);
this.setContentPane(getJContentPane());
Dimension screen =getToolkit().getScreenSize();
this.setLocation((screen.width-850)/2,(screen.height-600)/2);
}
} // @jve:decl-index=0:visual-constraint="-357,10"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -