长途汽车管理系统

【实例简介】

简单的增删改查，登录，用java实现对数据库的操作
【实例截图】
【核心代码】

package 长途汽车信息管理系统;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.io.*;
public class dengluQchepiao extends JFrame implements ActionListener{
 Statement st=null;
 JTextArea ja=new JTextArea("票号    车号    售票     已售    剩余    票价    出发地    目的地    出发时间        所用时间\n");
 JTextField jt1=new JTextField();
 JTextField jt2=new JTextField();
    JRadioButton jc1=new JRadioButton("查询全部");
 JRadioButton jc2=new JRadioButton("部分查询");
 ButtonGroup bg=new ButtonGroup();
 JButton jb1=new JButton("查询");
 JButton jb3=new JButton("退出");
 JLabel jl1=new JLabel("出发地");
 JLabel jl2=new JLabel("目的地");
 static Opration op=new Opration();
 public void Qcp(Statement sta){
     this.st=sta;//Statement语句传输
  setSize(640,300);
  setLayout(null);
  setVisible(true);//设置界面可见
  jc1.setBounds(20,20,80,20);
  jc2.setBounds(20,60,80,20);
  jl1.setBounds(20,80,80,20); 
  jt1.setBounds(20,110,80,30);
  jl2.setBounds(20,140,80,20);
  jt2.setBounds(20,170,80,30);
  jb1.setBounds(30,220,60,30);
  jb3.setBounds(230,220,60,30);
  ja.setBounds(120,20,480,200);
  bg.add(jc1);
  bg.add(jc2);
  add(jc1);
  add(jc2);
  add(jl1);
  add(jt1);
  add(jl2);
  add(jt2);
  add(jb1);
  add(jb3);
  add(ja);
  jc1.addActionListener(this);
  jc2.addActionListener(this);
  jb1.addActionListener(this);
  jb3.addActionListener(this);
 }
 public void actionPerformed(ActionEvent e){
  Object s=e.getSource();
  ResultSet rs=null;
  String a1;
  if(s.equals(jb1))
  {
   if(jc1.isSelected())
   {
    try{
    rs=st.executeQuery("select ticket.ticketno,ticket.busno,ticket.shoupiao,ticket.yishou,ticket.shengyu,ticket.price,luxian.chufadi,luxian.mudidi,luxian.shijian,luxian.time from ticket ,luxian where ticket.busno=luxian.busno");
    ja.setText("");
       ja.setText("票号    车号    售票     已售    剩余    票价    出发地    目的地    出发时间        所用时间\n");
     while(rs.next()){
      String a=rs.getString("ticketno"); 
      String b=rs.getString("busno");
      String c=rs.getString("shoupiao");
      String d=rs.getString("yishou");
      String f=rs.getString("shengyu");
      String g=rs.getString("price");
      String h=rs.getString("chufadi");
      String i=rs.getString("mudidi");
      String j=rs.getString("shijian");
      String k=rs.getString("time");
      ja.append(a "    " b "        " c "        " d "           " f "        " g "    " h "        " i "      " j "    " k "\n");
     }
    }
    catch(Exception e1){
     System.out.println(e);
    }
   }
   if(jc2.isSelected())
   {
    try{  
     ja.setText("");
     ja.setText("票号    车号    售票     已售    剩余    票价    出发地    目的地    出发时间        所用时间\n");
     rs=st.executeQuery("select ticket.ticketno,ticket.busno,ticket.shoupiao,ticket.yishou,ticket.shengyu,ticket.price,luxian.chufadi,luxian.mudidi,luxian.shijian,luxian.time from ticket ,luxian where ticket.busno=luxian.busno and luxian.chufadi='" jt1.getText() "' and luxian.mudidi='" jt2.getText() "'");
     while(rs.next()){
      String a=rs.getString("ticketno"); 
      String b=rs.getString("busno");
      String c=rs.getString("shoupiao");
      String d=rs.getString("yishou");
      String f=rs.getString("shengyu");
      String g=rs.getString("price");
      String h=rs.getString("chufadi");
      String i=rs.getString("mudidi");
      String j=rs.getString("shijian");
      String k=rs.getString("time");
      ja.append(a "    " b "        " c "        " d "           " f "        " g "    " h "        " i "      " j "    " k "\n");
     }
    }
    catch(Exception e1){
     System.out.println(e);
    }
   }
     }
  if(s.equals(jb3))
  {
   System.exit(0);
  }
 }
}