ccdataconnect.java

公交车管理系统,简单易用,适于初学者学习

import java.sql.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
public class CCDataConnect implements ActionListener
{
    int i=0,cl;
   	String lx=null;
    JFrame frm=new JFrame("长春公共汽车信息查询表");
    JPanel pl1=new JPanel();
    JPanel pl2=new JPanel();
    JLabel lab_cl=new JLabel("车辆查询:");
    JTextField jtf_cl=new JTextField();
    JLabel lab_lx=new JLabel("路线查询:");
    JTextField jtf_lx=new JTextField();
    JButton btn_cz=new JButton("重  置");
    JButton btn_cx=new JButton("查  询");
    //声明菜单
    javax.swing.JMenuBar mb=new JMenuBar();
    javax.swing.JMenu m=new JMenu("功能菜单");
    javax.swing.JMenu m_help=new JMenu("帮助");
    JMenuItem mi_tj=new JMenuItem("添加信息");
    JMenuItem mi_sc=new JMenuItem("删除信息");
    JMenuItem mi_xg=new JMenuItem("修改信息");
    JMenuItem mi_cx=new JMenuItem("查询信息");
    JSeparator s=new JSeparator();
    JMenuItem mi_exit=new JMenuItem("    离开");
    JMenuItem mi_help=new JMenuItem("相关信息");
    //声明表
    javax.swing.JTable jtb=new JTable();
    JScrollPane jsp=new JScrollPane(jtb);
    javax.swing.table.DefaultTableModel dtm=new javax.swing.table.DefaultTableModel();
    //与数据库连接的声明
    Connection con=null;
    Statement st=null;
    ResultSet rs=null;
    public CCDataConnect()
    {
        Container cp=frm.getContentPane();
        frm.setJMenuBar(mb);
        
        jtb.setToolTipText("如信息显示不完整，请移动表列位置并调整表列宽度。");
        pl2.setLayout(new java.awt.GridLayout(3,3));
        cp.add(pl2,"South");
        pl2.add(lab_cl);
        pl2.add(lab_lx);
        pl2.add(jtf_cl);
        pl2.add(jtf_lx);
        pl2.add(btn_cx);
        pl2.add(btn_cz);
        btn_cx.addActionListener(this);
        btn_cz.addActionListener(this);
        mb.add(m);
        mb.add(m_help);
        m.add(mi_tj);
        mi_tj.addActionListener(this);
        m.add(mi_sc);
        mi_sc.addActionListener(this);
        m.add(mi_xg);
        mi_xg.addActionListener(this);
        m.add(mi_cx);
        mi_cx.addActionListener(this);
        m.add(s);
        m.add(mi_exit);
        mi_exit.addActionListener(this);
        m_help.add(mi_help);
        mi_help.addActionListener(this);
        cp.add(pl1);
        pl1.add(jsp);
        dtm.setColumnCount(0);
        dtm.setRowCount(0);
        dtm.addColumn("车(路)号");
        dtm.addColumn("终起点");
        dtm.addColumn("发车时间");
        dtm.addColumn("途经路线");
        dtm.addColumn("备注信息");
        jtb.setModel(dtm);
         frm.setSize(500,570);
        frm.setVisible(true);
        //窗体居中屏幕
        Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
	    Dimension frameSize = frm.getSize();
	    if (frameSize.height > screenSize.height) {
	      frameSize.height = screenSize.height;
	    }
	    if (frameSize.width > screenSize.width) {
	      frameSize.width = screenSize.width;
	    }
	    frm.setLocation((screenSize.width - frameSize.width) / 2, (screenSize.height - frameSize.height) / 2);
	        
        
       
        frm.validate();
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con=DriverManager.getConnection("jdbc:odbc:ccBus_odbc","","");
        }catch(Exception e){
        	e.printStackTrace();	
        }  
         this.Connect();
    }
    public void Connect()
    {
        //数据库部分
        i=0;
        try
        {
        	st=con.createStatement(rs.TYPE_SCROLL_INSENSITIVE,rs.CONCUR_READ_ONLY);
            String s="select * from Bus_info";
            rs=st.executeQuery(s);
            rs.last();
            dtm.setRowCount(rs.getRow());
            rs.beforeFirst();
            while(rs.next())
            {
                dtm.setValueAt(String.valueOf(rs.getInt(1)),i,0);
                dtm.setValueAt(rs.getString(2),i,1);
                dtm.setValueAt(rs.getString(3),i,2);
                dtm.setValueAt(rs.getString(4),i,3);
                dtm.setValueAt(rs.getString(5),i,4);
                i++;
            }
        }
        catch(SQLException sqle)
        {
        	JOptionPane.showMessageDialog(null,"初始查询错误请与管理员联系！","提示窗口o",JOptionPane.OK_OPTION);
      		sqle.printStackTrace();
        }
    }
    //事件部分
    public void actionPerformed(ActionEvent ae)
    {
        if(ae.getSource()==btn_cx)
        {
           i=0;
           if(jtf_cl.getText().trim().length()!=0)
            {
                cl=Integer.parseInt(jtf_cl.getText().trim());
            }
           if(jtf_lx.getText().trim().length()!=0){
            	lx=jtf_lx.getText().trim();
           }
           String sql="select * from Bus_info where bus_number="+cl+" or bus_tjlx like '%"+lx+"%'";
            try
            {
                rs=st.executeQuery(sql);
                rs.last();
                dtm.setRowCount(rs.getRow());
            	rs.beforeFirst();
	            while(rs.next())
	            {
	                dtm.setValueAt(String.valueOf(rs.getInt(1)),i,0);
	                dtm.setValueAt(rs.getString(2),i,1);
	                dtm.setValueAt(rs.getString(3),i,2);
	                dtm.setValueAt(rs.getString(4),i,3);
	                dtm.setValueAt(rs.getString(5),i,4);
	                i++;
	            }
                if(!rs.next()){
                	JOptionPane.showMessageDialog(null,"对不起.没有您想查询的信息！","提示窗口o",JOptionPane.OK_OPTION);
                }
            }
            catch(SQLException sq)
            {
            	JOptionPane.showMessageDialog(null,"对不起.没有您想查询的信息！","提示窗口o",JOptionPane.OK_OPTION);
                sq.printStackTrace();
            }
        }
        else if (ae.getSource()==btn_cz)
        {
            jtf_cl.setText("");
            jtf_lx.setText("");
            cl=0;
            lx=null;
            this.Connect();
        }
        else if (ae.getSource()==mi_tj)
        {
            new AddMain();
        }
        else if (ae.getSource()==mi_sc)
        {
            new DeleteMain();
        }
        else if (ae.getSource()==mi_xg)
        {
            JOptionPane.showMessageDialog(null,"正在完善中！","提示窗口o",JOptionPane.OK_OPTION);
        }
        else if (ae.getSource()==mi_cx)
        {
            this.Connect();
        }
        else if (ae.getSource()==mi_exit)
        {
        	try{
        		con.close();
        		st.close();
        		rs.close();
        	}catch(Exception ex){
        		ex.printStackTrace();	
        	}
            System.exit(0);
        }else if(ae.getSource()==mi_help){
        	new AboutClass();	
        }
    }
  
    public static void main(String[] args)
    {
        new CCDataConnect();
    }
}