景點(diǎn)售票系統(tǒng)源代碼

1、import java.awt.Dimension;import java.awt.GridLayout;import java.awt.Toolkit;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import javax.s

2、wing.JButton;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JPasswordField;import javax.swing.JTextField;public class LogOnpublic static void main(String args)throws SQLExceptionfinal JFrame jfrmlogin=new JFrame("

3、系統(tǒng)登錄 ");jfrmlogin.setSize(400,280);Dimension screenSize=Toolkit.getDefaultToolkit().getScreenSize();jfrmlogin.setLocation(int) (screenSize.width-400)/2,(int)(screenSize.height-300)/2);/ 置框出現(xiàn)的位置JPanel p1=new JPanel();p1.add(new JLabel(" 用戶名： ");final JTextField jtxtuser=new JTextField(

4、14);JPanel p2=new JPanel();p2.add(new JLabel(" 密 碼： ");final JPasswordField jspwd=new JPasswordField(14);JPanel p3=new JPanel();final JButton jbtUser=new JButton(" 登 錄 ");final JButton jbtreg=new JButton(" 注 冊(cè) ");JButton jbtexit=new JButton(" 退 出 ");p1.add(jtx

5、tuser);p2.add(jspwd);p3.add(jbtUser);p3.add(jbtreg);p3.add(jbtexit);jbtUser.addActionListener(new ActionListener()public void actionPerformed(ActionEvent e)Connection conn=null;ResultSet rs=null;Statement stmt=null;if(e.getSource()=jbtUser)try Class.forName("oracle.jdbc.driver.OracleDriver"

6、;);conn = DriverManager.getConnection("jdbc:oracle:thin:localhost:1521:orcl", "system", "123");stmt=conn.createStatement();String USER_NAME=jtxtuser.getText();rs = stmt.executeQuery("select * from TICKET_USERSwhereUSER_NAME='"+jtxtuser.getText()+"'

7、;and USER_PWD='"+jspwd.getText()+"'");if(rs.next()if(USER_NAME.equals("admin")=false)MainUser mf=new MainUser();mf.setVisible(true);jfrmlogin.dispose();elseMainFrame mf=new MainFrame();mf.setVisible(true);jfrmlogin.dispose();elseJOptionPane.showMessageDialog(null,&qu

8、ot; 用戶名或密碼不一致， 請(qǐng)重新輸入！ "," 系統(tǒng)提示 ",JOptionPane.ERROR_MESSAGE);jtxtuser.setText("");jspwd.setText(""); catch (Exception ex) JOptionPane.showMessageDialog(null," 用戶名或密碼不一致，請(qǐng) 重新輸入！ "," 系統(tǒng)提示 ",JOptionPane.ERROR_MESSAGE);jtxtuser.setText("");

9、jspwd.setText(""););jbtreg.addActionListener(new ActionListener()public void actionPerformed(ActionEvent e)Connection conn=null;ResultSet rs=null;Statement stmt=null; if(e.getSource()=jbtreg)try Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection(

10、"jdbc:oracle:thin:localhost:1521:orcl", "system", "123"); stmt=conn.createStatement();rs = stmt.executeQuery("insert intoTICKET_USERS(USER_NAME,USER_PWD) values('"+jtxtuser.getText()+"','"+jspwd.getText()+"')"); if(rs.next()

11、JOptionPane.showMessageDialog(null," 你已成功注冊(cè)！可以 登錄了！ "," 系統(tǒng)提示 ",JOptionPane.INFORMATION_MESSAGE);jtxtuser.setText("");jspwd.setText("");elseJOptionPane.showMessageDialog(null," 用戶注冊(cè)失??！ "," 系 統(tǒng)提示 ",JOptionPane.ERROR_MESSAGE);jtxtuser.setText(

12、"");jspwd.setText(""); catch (Exception ex) JOptionPane.showMessageDialog(null," 用戶注冊(cè)失敗！ "," 系統(tǒng)提 示 ”,JOptio nPa ne.ERROR_MESSAGE);jtxtuser.setText("");jspwd.setText("");); jbtexit.addActio nListe ner(new Actio nListe ner() public void action Per

13、formed(Acti onEvent e) System.exit(O););jfrmlogi n. getC onten tPa ne().setLayout (new GridLayout(3,1); jfrmlogi n. getC onten tPa ne().add(p1);jfrmlogi n. getC onten tPa ne().add(p2);jfrmlogi n. getC onten tPa ne().add(p3);jfrmlogi n.setVisible(true);import java.sql.*;public class ConnectOraclethro

14、wspublic static void connection(String args)SQLExcepti on /Conn ecti on conn=n ull;/Statement stmt=null;/ResultSet rs=n ull;/JDBC直連Oracle數(shù)據(jù)庫加載驅(qū)動(dòng)try System. out .println(” 正在連接數(shù)據(jù)庫 ”);Class. forName ("oracle.jdbc.driver.OracleDriver");/*conn 二*/DriverManager. getConnection ("jdbc:oracle

15、:thin:localhost:1521:orcl" , "system" , "123");System. out .println(”已經(jīng)連接到數(shù)據(jù)庫.");/stmt二c onn .createStateme nt();stmt.executeQuery("insert intostude nt(STUID,STUNAME,SEX,AGE)values(0001,' 李華','男',20)");/rs=stmt.executeQuery("select * from

16、STUDENT");/System.out.pri ntl n(” stuID "+" StuName " + " Sex"+ " Age");/while(rs. next()int STUID=rs.getI nt("STUID");/Stri ng STUNAME=rs.getStri ng("STUNAME");/Stri ng SEX=rs.getStri ng("SEX");int AGE=rs.get In t("AGE"

17、);/System.out.pri ntln(" "+STUID+" "+STUNAME+" "+SEX+""+AGE);/System.out.pri ntl n(” STUID "+STUID+" STUNAME"+STUNAME+"SEX"+SEX+"AGE"+AGE);/ catch (Exception ex) (”出現(xiàn)的異常為 ” + ex);import java.awt.Recta ngle;import java.awt.eve

18、 nt.Act ion Eve nt; import java.awt.eve nt.Act ion Liste ner;import java.sql.C onn ecti on;import java.sql.DriverMa nager;import java.sql.ResultSet;import java.sql.Stateme nt;import javax.swi ng.JButt on;import javax.sw in g.JLabel;import javax.swi ng.JOptio nPane;import javax.swi ng.JPa nel;import

19、javax.swi ng.JTextField;public class AddTicket exte nds JPa nel impleme nts Action Liste ner Connection con;Statement st;JLabel jLabel仁new JLabef票 單 價(jià):”)；JLabel jLabel2=new JLabel(票日期:");JTextField jTextField1=new JTextField()；JTextField jTextField2=new JTextField();JButton jButton1=new JButton

20、(" 確定增加 ");public AddTicket()tryjbInit(); catch(Exception exception) exception.printStackTrace();private void jbInit() throws Exception Class.forName("oracle.jdbc.driver.OracleDriver");con = DriverManager.getConnection("jdbc:oracle:thin:localhost:1521:orcl", "syste

21、m", );this.setLayout(null);jLabel1.setBounds(new Rectangle(40,40,64,24);jLabel2.setBounds(new Rectangle(40,100,53,22);jTextField1.setBounds(new Rectangle(102,40,200,30);jTextField2.setBounds(new Rectangle(102,100,200,30);jButton1.setBounds(new Rectangle(120,220,150,32); jButton1.addActionListen

22、er(this);this.add(jLabel1);this.add(jTextField1);this.add(jLabel2);this.add(jTextField2); this.add(jButton1);ResultSet rs=null; st=con.createStatement();rs = st.executeQuery("select * from TICKET_TRANSCRIPT"); if(rs.next()jTextField1.setText(rs.getString("TICKET_PRICE");public vo

23、id actionPerformed(ActionEvent e)tryst=con.createStatement();st.executeUpdate("delete from TICKET");st.executeUpdate("delete from TICKET_ORDER_FORM");st.executeUpdate("insert into TICKET select * from TICKET_TRANSCRIPT");st.executeUpdate("update TICKET set TICKET_D

24、ATE='"+jTextField2.getText()+"'");st.executeUpdate("update TICKET set TICKET_PRICE='"+jTextField1.getText()+"'"); JOptionPane.showMessageDialog(this," 票增加成功！ ");jTextField1.setText("");jTextField2.setText("");catch(Exce

25、ption ex)JOptionPane.showMessageDialog(this," 票增加失敗！ ");ex.printStackTrace();import javax.swing.*;import javax.swing.table.JTableHeader;import java.awt.Rectangle;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.*;public class AdminInquireTicket extends

26、 JFrame Connection con;Statement st;private JScrollPane scpDemo;private JTableHeader jth;private JTable tabDemo; private JButton btnShow;private JButton btnShow1;public AdminInquireTicket()super(" 華清池售票系統(tǒng) "); this.setSize(430,400); this.setLayout(null); this.setLocation(500,180);this.scpDe

27、mo = new JScrollPane(); this.scpDemo.setBounds(10,50,390,270); this.btnShow = new JButton(" 顯示票信息 "); this.btnShow.setBounds(10,10,390,30); this.btnShow1 = new JButton(" 返 回 "); this.btnShow1.setBounds(260,330,120,30);JLabel jLabeI仁new JLabel("余票總數(shù)：")；JTextField jTextFi

28、eld1=new JTextField(); jLabel1.setBounds(new Rectangle(20,330,100,30)； jTextField1.setBounds(new Rectangle(90,330,70,30)；add(this.scpDemo)； add(this.btnShow)； add(this.btnShow1)；this.add(jLabel1)；this.add(jTextField1)；this.setVisible(true)；tryClass.forName("oracle.jdbc.driver.OracleDriver"

29、)；con = DriverManager.getConnection("jdbc：oracle：thin：localhost：1521：orcl", "system", "123")；ResultSet rs=null；int n = 0；st=con.createStatement()；rs = st.executeQuery("select * from TICKET")；while(rs.next()n+； jTextField1.setText(""+n+"")；c

30、atch(Exception exception)exception.printStackTrace()；this.btnShow1.addActionListener(new ActionListener()public void actionPerformed(ActionEvent e)MainFrame mu=new MainFrame();mu.setVisible(true);dispose(););this.btnShow.addActionListener(new ActionListener()public void actionPerformed(ActionEvent a

31、e)btnShow_ActionPerformed(ae););public void btnShow_ActionPerformed(ActionEvent ae)tryClass.forName("oracle.jdbc.driver.OracleDriver");Connection conDriverManager.getConnection("jdbc:oracle:thin:localhost:1521:orcl", "system", "123"); String sql = "select

32、 * from TICKET"PreparedStatement pstm = con.prepareStatement(sql);ResultSet rs = pstm.executeQuery();int count = 0;while(rs.next()count+;rs = pstm.executeQuery();Object info = new Objectcount4;count = 0;while(rs.next()infocount0 = rs.getString("TICKET_NUM");infocount1 = rs.getString(&

33、quot;TICKET_DATE");infocount2 = rs.getString("TICKET_PRICE"); count+;String title = " 票號(hào)","日期"," 票價(jià)" this.tabDemo = new JTable(info,title); this.jth = this.tabDemo.getTableHeader(); this.scpDemo.getViewport().add(tabDemo);敗 !"," 錯(cuò)敗 !","

34、; 錯(cuò)catch(ClassNotFoundException cnfe)JOptionPane.showMessageDialog(null," 查詢失 ",JOptionPane.ERROR_MESSAGE);catch(SQLException sqle)JOptionPane.showMessageDialog(null," 查詢失 ",JOptionPane.ERROR_MESSAGE);import java.awt.Rectangle;import java.awt.event.ActionEvent;import java.awt.eve

35、nt.ActionListener;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;import javax.swing.JButton;import javax.swing.JLabel;import javax.swing.JOptionPane;import javax.swing.JPanel;import javax.swing.JTextField;public class BuyTicket extends JP

36、anel implements ActionListener Connection con;Statement st;JLabel jLabel仁new JLabel(用戶名:”)；JLabel jLabel2=new JLabel(票編號(hào):");JLabel jLabel3=new JLabel(票單價(jià):");JLabel jLabel4=new JLabef票 日 期:")；JTextField jTextField1=new JTextField();JTextField jTextField2=new JTextField()；JTextField jTe

37、xtField3=new JTextField()；JTextField jTextField4=new JTextField()；JButton jButton1=new JButton(" 確定購置 ")；public BuyTicket()tryjbInit()；catch(Exception exception)exception.printStackTrace()；private void jbInit() throws ExceptionClass.forName("oracle.jdbc.driver.OracleDriver")；con

38、= DriverManager.getConnection("jdbc:oracle:thin:localhost:1521:orcl", "system", )；this.setLayout(null)；jLabel1.setBounds(new Rectangle(40,40,64,24)；jLabel2.setBounds(new Rectangle(40,100,53,22)；jLabel3.setBounds(new Rectangle(40,160,61,27)；jLabel4.setBounds(new Rectangle(40,220,6

39、1,27)；jTextField1.setBounds(new Rectangle(102,40,200,30)；jTextField2.setBounds(new Rectangle(102,100,200,30)；jTextField3.setBounds(new Rectangle(102,160,200,33)；jTextField4.setBounds(new Rectangle(102,220,200,33)；jButton1.setBounds(new Rectangle(120,300,150,32)； jButton1.addActionListener(this)；this

40、.add(jLabel1)；this.add(jTextField1)；this.add(jLabel2)；this.add(jTextField2)；this.add(jLabel3)；this.add(jTextField3)；this.add(jLabel4)；this.add(jTextField4)；this.add(jButton1);ResultSet rs=null;st=con.createStatement();num, a.* from TICKETrs = st.executeQuery("select * from (select rownuma)where

41、 num = (select count(1) from TICKET)");if(rs.next()jTextField2.setText(rs.getString("TICKET_NUM");jTextField3.setText(rs.getString("TICKET_PRICE");jTextField4.setText(rs.getString("TICKET_DATE");public void actionPerformed(ActionEvent e)if(e.getSource()=jButton1)tr

42、yst.executeUpdate("insert into TICKET_ORDER_FORM values('"+jTextField1.getText()+"','"+jTextField2.getText()+"','"+jTextField4.getText()+"','"+jTextFiel d3.getText()+"')");st.executeUpdate("delete from TICKET wher

43、e TICKET_NUM='"+jTextField2.getText()+"'");JOptionPane.showMessageDialog(this," 購票成功！ ");jTextField1.setText("");jTextField2.setText("");jTextField3.setText("");jTextField4.setText(""); catch(Exception ex)JOptionPane.showMessag

44、eDialog(this," 購票失敗！ "); ex.printStackTrace();import java.awt.Rectangle;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;import javax.swing.JLabel;import javax

45、.swing.JPanel;import javax.swing.JTextField;public class InquireTicket extends JPanel implements ActionListenerConnection con;Statement st;JLabel jLabel仁new JLabel(余票數(shù):”)；JTextField jTextField1=new JTextField();JLabel jLabel2=new JLabel(票價(jià):");JTextField jTextField2=new JTextField()；JLabel jLabe

46、l3=new JLabel("日期:");JTextField jTextField3=new JTextField();public InquireTicket()tryjbInit();catch(Exception exception) exception.printStackTrace();private void jbInit() throws Exception Class.forName("oracle.jdbc.driver.OracleDriver");con = DriverManager.getConnection("jd

47、bc:oracle:thin:localhost:1521:orcl", "system", "123");this.setLayout(null);jLabel1.setBounds(new Rectangle(40,50,64,24); jTextField1.setBounds(new Rectangle(102,50,200,30);jLabel2.setBounds(new Rectangle(40,100,64,24);jTextField2.setBounds(new Rectangle(102,100,200,30);jLabe

48、l3.setBounds(new Rectangle(40,150,64,24);jTextField3.setBounds(new Rectangle(102,150,200,30); this.add(jLabel1);this.add(jTextField1);this.add(jLabel2);this.add(jTextField2);this.add(jLabel3);this.add(jTextField3);ResultSet rs=null;int count = 0;st=con.createStatement();rs = st.executeQuery("se

49、lect * from TICKET"); while(rs.next() jTextField2.setText(rs.getString("TICKET_PRICE"); jTextField3.setText(rs.getString("TICKET_DATE"); count+; jTextField1.setText(""+count+"");public void actionPerformed(ActionEvent e)import java.awt.Dimension;import ja

50、va.awt.Font;import java.awt.Rectangle;import java.awt.Toolkit;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JMenu;import javax.swing.JMenuBar;import javax.swing.JMenuItem; import javax.swing.JOptionPane;i

51、mport javax.swing.JPanel;public class MainFrame extends JFrame implements ActionListenerJPanel contentPane;JMenuBar jMenuBar1=new JMenuBar();JMenu jMenu0=new JMenu(" 系統(tǒng) ");JMenuItem jMenuItem0=new JMenuItem(" 退出 ");JMenu jMenu1=new JMenu(" 增加票 ");JMenuItem jMenuItem1=ne

52、w JMenuItem(" 增加票 ");JMenu jMenu2=new JMenu(" 修改票 ");JMenuItem jMenuItem2=new JMenuItem(" 修改票 ");JMenu jMenu3=new JMenu(" 查詢票 ");JMenuItem jMenuItem3=new JMenuItem(" 查詢票 ");JLabel jLabel1=new JLabel(" 華清池售票系統(tǒng)管理員 ");JLabel jLabel2=new JLabel

53、(" 延安大學(xué)軟件 12 課程設(shè)計(jì) ");public MainFrame()try setDefaultCloseOperation(EXIT_ON_CLOSE); jbInit();catch(Exception exception) exception.printStackTrace();private void jbInit() throws ExceptioncontentPane =(JPanel) getContentPane(); contentPane.setLayout(null);Dimension screenSize=Toolkit.getDefa

54、ultToolkit().getScreenSize();setLocation(int) (screenSize.width-400)/2,(int)(screenSize.height-360)/2); setSize(new Dimension(400,420);setTitle(" 華清池售票系統(tǒng) ");jMenuItem0.addActionListener(this);jMenuItem1.addActionListener(this);jMenuItem2.addActionListener(this);jMenuItem3.addActionListener

55、(this);setJMenuBar(jMenuBar1);jMenuBar1.add(jMenu0);jMenuBar1.add(jMenu1);jMenuBar1.add(jMenu2);jMenuBar1.add(jMenu3);jMenu0.add(jMenuItem0);jMenu1.add(jMenuItem1);jMenu2.add(jMenuItem2);jMenu3.add(jMenuItem3);contentPane.add(jLabel1);contentPane.add(jLabel2);jLabel1.setFont(new java.awt.Font("

56、 黑體 ",Font.BOLD,20); jLabel1.setBounds(new Rectangle(65,70,275,55);jLabel2.setFont(new java.awt.Font(" 黑體 ",Font.BOLD,16); jLabel2.setBounds(new Rectangle(90,150,200,35);public void actionPerformed(ActionEvent actionEvent) if(actionEvent.getSource()=jMenuItem0) JOptionPane.showMessage

57、Dialog(null," 您 已 成 功 退 出 系 統(tǒng) ！ "," 系 統(tǒng) 提 示 ",JOptionPane.CANCEL_OPTION);System.exit(0);if(actionEvent.getSource()=jMenuItem1)AddTicket AddT=new AddTicket(); this.remove(this.getContentPane(); this.setContentPane(AddT); this.setVisible(true); if(actionEvent.getSource()=jMenuItem2

58、)ModifyTicket AddT=new ModifyTicket(); this.remove(this.getContentPane(); this.setContentPane(AddT); this.setVisible(true); if(actionEvent.getSource()=jMenuItem3) this.setVisible（false）;AdminInquireTicket AddT=new AdminInquireTicket（）; this.remove（this.getContentPane（）; this.setContentPane（AddT）;thi

59、s.setVisible（true）;import java.awt.Dimension;import java.awt.Font;import java.awt.Rectangle;import java.awt.Toolkit;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import javax.swing.JFrame;import javax.swing.JLabel;import javax.swing.JMenu;import javax.swing.JMenuBar;import j

60、avax.swing.JMenuItem;import javax.swing.JOptionPane;import javax.swing.JPanel;public class MainUser extends JFrame implements ActionListener JPanel contentPane;JMenuBar jMenuBar1=new JMenuBar（）;JMenu jMenu0=new JMenu（" 系統(tǒng) "）;JMenuItem jMenuItem0=new JMenuItem（" 退出 "）; JMenu jMenu1=new JMenu（" 購票 "）;JMenuItem jMenuItem1=new JMenuItem（" 購票 "）; JMenu jMenu2=new JMenu（" 查詢余票 "）;JMenuItem jMenuItem2=new JMenuItem（" 查詢余票 "）; JMenu jMenu3=new JMenu（" 我的訂票 "）;JMenuItem jMenuItem3=new JMenuItem（&