文件名称：火车售票 第2
文件大小：3KB
文件格式：JAVA
更新时间：2015-07-15 10:57:12
java 火车 售票
import java.awt.Color; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.swing.*; public class CheCiXiangQin extends JFrame { Connection con = null; Statement stmt = null; ResultSet rs = null; String[] str=new String[20]; JLabel[] jpx=new JLabel[20]; JPanel jp=new JPanel(); JButton jb1=new JButton("确定"); JButton jb2=new JButton("订票"); public CheCiXiangQin(){ super("车次查询"); setSize(900,700); this.setVisible(true); jp.setLayout(null); jp.setBounds(10, 10, 880, 680); jp.setBackground(Color.WHITE); add(jp); for(int k=0;k<12;k++){ jpx[k]=new JLabel(); } try { Class.forName("oracle.jdbc.driver.OracleDriver"); } catch (ClassNotFoundException e) {} String url = "jdbc:oracle:thin:@192.168.5.16:1521:lieche"; String user = "system"; String password = "111111"; try {con = DriverManager.getConnection(url, user, password); stmt = con.createStatement(); } catch (SQLException e) { e.printStackTrace(); } } //查询方法 public ResultSet query(String sql){ try { rs = stmt.executeQuery(sql); } catch (SQLException e) {} return rs; } public void action(String sql) { int count=0; rs = query(sql); try { while(rs.next()){ //遍历取出结果集中的内容 str[count]=rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4)+" "+rs.getString(5)+" "+rs.getString(6)+" "+rs.getString(7)+ " "+rs.getString(8)+" "+rs.getString(9)+" "+rs.getString(10)+" "+rs.getString(11)+" "+rs.getString(12)+" "+rs.getString(13)+" "+rs.getString(14)+" "+rs.getString(15)+" "+rs.getString(16); count++; } } catch (SQLException se) { se.printStackTrace(); } for(int i=0;i<12;i++) { if(i==0) { jpx[0].setText("车次 "+"类型 "+"始发站 "+"始发时间 "+"终点站 "+"站点 "+"到达时间 "+"发车时间 "+"路程 "+" 总票"+" 第0天剩余"+" 第1天剩余"+" 第2天剩余"+" 第3天剩余"+" 第4天剩余"+" 第5天剩余"); jp.add(jpx[0]); jpx[0].setBounds(10, 20, 900,20); } else{ jpx[i].setText(str[i-1]); jp.add(jpx[i]); jpx[i].setBounds(10, 40*(i+1)-30, 900, 20); } } jp.add(jb1); jb1.setBounds(350, 500, 100, 50); jb1.addMouseListener(new MouseAdapter(){ public void mouseReleased(MouseEvent e) { setVisible(false); } }); jp.add(jb2); jb2.setBounds(500, 500, 100, 50); } public void close(){ try { rs.close(); } catch (SQLException e) {} try { stmt.close(); } catch (SQLException e) {} try { con.close(); } catch (SQLException e) {} } }