火车售票系统完整代码.docx
- 文档编号:8040133
- 上传时间:2023-01-28
- 格式:DOCX
- 页数:56
- 大小:30.31KB
火车售票系统完整代码.docx
《火车售票系统完整代码.docx》由会员分享,可在线阅读,更多相关《火车售票系统完整代码.docx(56页珍藏版)》请在冰豆网上搜索。
火车售票系统完整代码
packagecom.yue;
importjava.awt.Color;
importjava.awt.GridBagConstraints;
importjava.awt.GridBagLayout;
importjava.awt.event.ActionEvent;
importjava.awt.event.ActionListener;
importjava.sql.CallableStatement;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
importjavax.swing.BorderFactory;
importjavax.swing.JButton;
importjavax.swing.JLabel;
importjavax.swing.JOptionPane;
importjavax.swing.JPanel;
importjavax.swing.JPasswordField;
importjavax.swing.JTextArea;
importjavax.swing.JTextField;
publicclassBuyPanelextendsJPanel{
StringBuffersb=newStringBuffer();
privatebooleanflag=false;
JTextAreajtArea=newJTextArea(10,78);
JLabelbuyLabel=newJLabel("订票");
JTextFieldfId=newJTextField(7);
JTextFieldftid=newJTextField(7);
JTextFieldfche=newJTextField(7);
JTextFieldfzhangshu=newJTextField(7);
JTextFieldfbodyId=newJTextField(7);
JPasswordFieldjpField=newJPasswordField(7);
publicJPanelgetBuypn(){
JPanelpan=newJPanel();
GridBagLayoutlayout=newGridBagLayout();
pan.setLayout(layout);
GridBagConstraintscon=getGridBagConstraints(0,0,1,1,100,100,
GridBagConstraints.NONE,GridBagConstraints.WEST);
pan.add(buyLabel,con);
con=getGridBagConstraints(0,2,1,1,100,100,
GridBagConstraints.NONE,GridBagConstraints.WEST);
pan.add(newpan3(),con);
con=getGridBagConstraints(0,3,1,1,100,100,
GridBagConstraints.NONE,GridBagConstraints.WEST);
pan.add(newpan4(),con);
con=getGridBagConstraints(0,4,1,1,100,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
pan.add(newpan5(),con);
this.setLocation(270,150);
this.add(pan);
returnpan;
}
/**
*定义下面购票操作区面板pan3
*
*@authorAdministrator
*
*/
classpan3extendsJPanel{
JLabellId=newJLabel("车票号码");
JLabelltid=newJLabel("车票号码");
JLabelche=newJLabel("车次");
JLabellbodyId=newJLabel("身份证号");
JLabelpassword=newJLabel("密码");
JLabellzhangshu=newJLabel("所需张数");
JLabella1=newJLabel("");
JLabella2=newJLabel("");
JButtonsureButton=newJButton("查询确认");
JButtonbuyButton=newJButton("确认购票");
publicpan3(){
buyButton.addActionListener(newActionListener(){
@Override
publicvoidactionPerformed(ActionEvente){
UpdateUser();
if(flag==true){
UpdateTrain();
System.out.println("hjkasfhjkaf");
}
}
});
sureButton.addActionListener(newActionListener(){
@Override
publicvoidactionPerformed(ActionEvente){
select();
}
});
GridBagLayoutlayout=newGridBagLayout();
this.setLayout(layout);
GridBagConstraintscon=getGridBagConstraints(0,0,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(lId,con);
con=getGridBagConstraints(1,0,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(fId,con);
con=getGridBagConstraints(8,0,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(la2,con);
con=getGridBagConstraints(9,0,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(sureButton,con);
con=getGridBagConstraints(0,1,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(ltid,con);
con=getGridBagConstraints(1,1,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(ftid,con);
con=getGridBagConstraints(2,1,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(che,con);
con=getGridBagConstraints(3,1,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(fche,con);
con=getGridBagConstraints(4,1,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(lbodyId,con);
con=getGridBagConstraints(5,1,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(fbodyId,con);
con=getGridBagConstraints(0,2,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(password,con);
con=getGridBagConstraints(1,2,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(jpField,con);
con=getGridBagConstraints(2,2,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(lzhangshu,con);
con=getGridBagConstraints(3,2,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(fzhangshu,con);
con=getGridBagConstraints(8,2,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(la1,con);
con=getGridBagConstraints(9,2,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(buyButton,con);
this.setBorder(BorderFactory.createTitledBorder("订票操作区"));
}
}
/**
*定义下面一个JList用于显示车票的所有信息面板pan4
*
*@authorAdministrator
*
*/
classpan4extendsJPanel{
JButtonbtId=newJButton("车票号码");
JButtonbt1=newJButton("起点站");
JButtonbt2=newJButton("终点站");
JButtonbt3=newJButton("车次");
JButtonbt4=newJButton("发车时间");
JButtonbt5=newJButton("到达时间");
JButtonbt6=newJButton("座位类型");
JButtonbt7=newJButton("发车日期");
JButtonbt8=newJButton("剩余票数");
JButtonbt9=newJButton("车票价格");
publicpan4(){
this.setLayout(newGridBagLayout());
GridBagConstraintscon=getGridBagConstraints(0,0,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(btId,con);
con=getGridBagConstraints(1,0,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(bt1,con);
con=getGridBagConstraints(2,0,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(bt2,con);
con=getGridBagConstraints(3,0,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(bt3,con);
con=getGridBagConstraints(4,0,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(bt4,con);
con=getGridBagConstraints(5,0,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(bt5,con);
con=getGridBagConstraints(6,0,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(bt6,con);
con=getGridBagConstraints(7,0,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(bt7,con);
con=getGridBagConstraints(8,0,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(bt8,con);
con=getGridBagConstraints(9,0,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(bt9,con);
con=getGridBagConstraints(0,1,11,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(jtArea,con);
jtArea.setBackground(Color.GREEN);
}
}
/**
*定义最下面的按钮面板pan5
*
*@authorAdministrator
*
*/
classpan5extendsJPanel{
JButtonbt1=newJButton("退出登录");
JLabellab1=newJLabel("");
publicpan5(){
GridBagLayoutlayout=newGridBagLayout();
this.setLayout(layout);
GridBagConstraintscon=getGridBagConstraints(0,0,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(bt1,con);
con=getGridBagConstraints(1,0,1,1,0,100,
GridBagConstraints.NONE,GridBagConstraints.EAST);
this.add(lab1,con);
bt1.addActionListener(newActionListener(){
@Override
publicvoidactionPerformed(ActionEvente){
System.exit(0);
}
});
}
}
/**
*放回一个网格包约束
*
*@paramx
*@paramy
*@paramwidth
*@paramheigh
*@paramweighx
*@paramweighy
*@paramfill
*@paramanchor
*@return
*/
privateGridBagConstraintsgetGridBagConstraints(intx,inty,intwidth,
intheigh,intweighx,intweighy,intfill,intanchor){
GridBagConstraintscon=newGridBagConstraints();
con.gridx=x;
con.gridy=y;
con.gridwidth=width;
con.gridheight=heigh;
con.weightx=weighx;
con.weighty=weighy;
con.fill=fill;
con.anchor=anchor;
returncon;
}
/**
*按车票号码搜索所有的车票信息
*
*@throwsSQLException
*/
privatevoidselect(){
Connectionconn=null;
Statementstmt=null;
ResultSetticket=null;
try{
conn=DriverManager.getConnection(
"jdbc:
oracle:
thin:
@127.0.0.1:
1521:
ORCL","store","store");
}catch(SQLExceptione1){
e1.printStackTrace();
}
try{
stmt=conn.createStatement();
Stringtext="select*fromtrain_table"+"wheretid="+"'"
+fId.getText()+"'";
ticket=stmt.executeQuery(text);
while(ticket.next()){
Stringstarter=ticket.getString("starter");
Stringreacher=ticket.getString("reacher");
StringticketNumber=ticket.getString("ticketNumber");
StringstartTime=ticket.getString("startTime");
StringendTime=ticket.getString("endTime");
StringseatIdNumber=ticket.getString("seatIdNumber");
StringbusDate=ticket.getString("busDate");
intticketNum=ticket.getInt("ticketNum");
doubleprice=ticket.getDouble("price");
sb.append(""+fId.getText()+"\t"+""+starter+"\t"+""+reacher
+"\t"+""+ticketNumber+"\t"+startTime+"\t"
+endTime+"\t"+seatIdNumber+"\t"+busDate+"\t"
+ticketNum+"\t"+price+""+"\n");
}
jtArea.setText(sb.toString());
if(sb.length()>0){
sb.delete(1,sb.length());
}else{
JOptionPane.showMessageDialog(newTestFrame(),"无此车!
");
}
}catch(SQLExceptione){
}finally{
if(ticket!
=null){
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 火车 售票 系统 完整 代码