2007-09-27
小小的火车票查询系统 java
代码很少，无聊随便写写，大家看看！
与数据库相关的在 sqlfa.java里 主窗口在trainfram.java里！1个多小时，好久没有写了，感觉有点陌生！哈哈
sqlfa.java
package workfive;
import java.sql.*;
class sqlfa{
//连驱动,数据源
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
Connection con=null;
Statement stmt=null;
String sql=null;
String bbsql;
void lian_driver(){
String yuan="jdbc:odbc:test";
try{
Class.forName(driver);
}catch(ClassNotFoundException e){}
try{
con=DriverManager.getConnection(yuan);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
}catch(SQLException ee){}
}
//查询
public ResultSet fan_guo()throws SQLException{
ResultSet guo=null;
guo=stmt.executeQuery(sql);
return guo;
}
//接收，修改查询语句
void xiugai_sql(String ru){
this.sql="select * from TrainTicket where TrainNo='"+ru+"'";
}
//计算
public float jisuan(int xx,float yy){
return xx*yy;
}
//更新语句
void gengxin(int sit_x,int bed_x,String no,boolean n)throws SQLException{
if(n){
this.bbsql = "update trainticket set seatnum="+sit_x+" where trainno='"+no+"'";
}else
{
this.bbsql = "update trainticket set bednum="+bed_x+" where trainno='"+no+"'";
}
stmt.executeQuery(bbsql);
}
}
下面是主窗口
package workfive;
import java.awt.BorderLayout;
import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JRadioButton;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.sql.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;
import javax.swing.ButtonGroup;
public class trainfram extends JFrame {
public trainfram() {
try {
jbInit();
} catch (Exception exception) {
exception.printStackTrace();
}
}
sqlfa mm=new sqlfa();
ResultSet guoguo=null;
float sum;
float yun=15;
static boolean panduan=true;
int sit_yu,bed_yu;
//*****
public float jisuan(int xx,float yy){
return xx*yy;
}
//计算
void ji_suan(boolean nn)throws Exception{
if(nn)
{
this.sit_yu=this.guoguo.getInt("seatNum")-Integer.parseInt(this.txt_num.getText());
this.sum=this.jisuan(Integer.parseInt(this.txt_num.getText()),this.guoguo.getFloat("seatprice"));
}
else{
this.bed_yu=this.guoguo.getInt("bedNum")-Integer.parseInt(this.txt_num.getText());
this.sum=this.jisuan(Integer.parseInt(this.txt_num.getText()),this.guoguo.getFloat("bedprice"));}
}
//传递
void chuan(){
mm.xiugai_sql(this.txt_no.getText());
}
//show
void showshow()throws SQLException{
this.chuan();
mm.lian_driver();
this.guoguo=mm.fan_guo();
if(this.guoguo.next())
//{ this.guoguo.next();}else {this.guoguo.close();}
{
// try{
// this.ji_suan(this.yingzuo.isSelected());
// }catch(Exception af){}
this.panduan=true;
this.ceshi();
this.guoguo.close();
}
else{this.txt_num.setText("");
this.panduan=false;
this.ceshi();
this.guoguo.close();
}
}
private void jbInit() throws Exception {
getContentPane().setLayout(null);
jb_top.setText("订购火车票");
jb_top.setBounds(new Rectangle(154, 18, 80, 32));
checi.setText("火车车次:");
checi.setBounds(new Rectangle(60, 86, 83, 29));
fangshi.setText("乘车方式:");
fangshi.setBounds(new Rectangle(58, 145, 70, 28));
yingzuo.setText("硬座");
yingzuo.setBounds(new Rectangle(139, 147, 71, 23));
yingzuo.addActionListener(new trainfram_yingzuo_actionAdapter(this));
yingwo.setText("硬卧");
yingwo.setBounds(new Rectangle(225, 145, 64, 26));
yingwo.addActionListener(new trainfram_yingwo_actionAdapter(this));
shuliang.setText("订购数量：");
shuliang.setBounds(new Rectangle(56, 212, 78, 33));
txt_num.setBounds(new Rectangle(143, 214, 120, 28));
txt_no.setBounds(new Rectangle(141, 86, 125, 29));
jb_ok.setBounds(new Rectangle(151, 285, 108, 40));
jb_ok.setText("确定");
jb_ok.addActionListener(new trainfram_jb_ok_actionAdapter(this));
this.setSize(450,450);
jop_wrong.setToolTipText("");
jop_wrong.setBounds(new Rectangle(66, 119, 262, 90));
jop_wrong.setLayout(null);
this.getContentPane().add(checi);
this.getContentPane().add(fangshi);
this.getContentPane().add(yingzuo);
this.getContentPane().add(yingwo);
this.getContentPane().add(shuliang);
this.getContentPane().add(txt_num);
this.getContentPane().add(txt_no);
this.getContentPane().add(jb_ok);
this.getContentPane().add(jop_wrong);
this.getContentPane().add(jb_top);
this.setVisible(true);
but_zu.add(yingzuo);
but_zu.add(yingwo);
}
//测试
void ceshi()throws SQLException{
if(this.panduan)
{
if(this.yingzuo.isSelected()&this.guoguo.getInt("seatNum")>=Integer.parseInt(this.txt_num.getText())|this.yingwo.isSelected()&this.guoguo.getInt("bedNum")>=Integer.parseInt(this.txt_num.getText()))
{ try{
this.ji_suan(this.yingzuo.isSelected());
}catch(Exception af){}
JOptionPane.showMessageDialog(jop_wrong,"请付款"+this.sum);
mm.gengxin(this.sit_yu,this.bed_yu,this.guoguo.getString("trainNo"),this.yingzuo.isSelected());
}
else{
JOptionPane.showMessageDialog(jop_wrong,"票数不够，请重新输入！");
}
}else
{
JOptionPane.showMessageDialog(jop_wrong,"您输入的车次不存在，请重新输入！");
}
}
public static void main(String[] args) {
trainfram trainfram = new trainfram();
}
JLabel jb_top = new JLabel();
JLabel checi = new JLabel();
JLabel fangshi = new JLabel();
JRadioButton yingzuo = new JRadioButton("",true);
JRadioButton yingwo = new JRadioButton();
JLabel shuliang = new JLabel();
JTextField txt_num = new JTextField();
JTextField txt_no = new JTextField();
JButton jb_ok = new JButton();
JOptionPane jop_wrong = new JOptionPane();
ButtonGroup but_zu = new ButtonGroup();
public void jb_ok_actionPerformed(ActionEvent e) {
try{
this.showshow();
}catch(SQLException aaa){}
}
public void yingzuo_actionPerformed(ActionEvent e) {
}
public void yingwo_actionPerformed(ActionEvent e) {
}
}
class trainfram_yingwo_actionAdapter implements ActionListener {
private trainfram adaptee;
trainfram_yingwo_actionAdapter(trainfram adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.yingwo_actionPerformed(e);
}
}
class trainfram_yingzuo_actionAdapter implements ActionListener {
private trainfram adaptee;
trainfram_yingzuo_actionAdapter(trainfram adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.yingzuo_actionPerformed(e);
}
}
class trainfram_jb_ok_actionAdapter implements ActionListener {
private trainfram adaptee;
trainfram_jb_ok_actionAdapter(trainfram adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jb_ok_actionPerformed(e);
}
}
大家看了，给点意见。谢谢了。。。。还有好多 没有时间发。。。
与数据库相关的在 sqlfa.java里 主窗口在trainfram.java里！1个多小时，好久没有写了，感觉有点陌生！哈哈
sqlfa.java
package workfive;
import java.sql.*;
class sqlfa{
//连驱动,数据源
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
Connection con=null;
Statement stmt=null;
String sql=null;
String bbsql;
void lian_driver(){
String yuan="jdbc:odbc:test";
try{
Class.forName(driver);
}catch(ClassNotFoundException e){}
try{
con=DriverManager.getConnection(yuan);
stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
}catch(SQLException ee){}
}
//查询
public ResultSet fan_guo()throws SQLException{
ResultSet guo=null;
guo=stmt.executeQuery(sql);
return guo;
}
//接收，修改查询语句
void xiugai_sql(String ru){
this.sql="select * from TrainTicket where TrainNo='"+ru+"'";
}
//计算
public float jisuan(int xx,float yy){
return xx*yy;
}
//更新语句
void gengxin(int sit_x,int bed_x,String no,boolean n)throws SQLException{
if(n){
this.bbsql = "update trainticket set seatnum="+sit_x+" where trainno='"+no+"'";
}else
{
this.bbsql = "update trainticket set bednum="+bed_x+" where trainno='"+no+"'";
}
stmt.executeQuery(bbsql);
}
}
下面是主窗口
package workfive;
import java.awt.BorderLayout;
import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import javax.swing.JRadioButton;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.sql.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JOptionPane;
import javax.swing.ButtonGroup;
public class trainfram extends JFrame {
public trainfram() {
try {
jbInit();
} catch (Exception exception) {
exception.printStackTrace();
}
}
sqlfa mm=new sqlfa();
ResultSet guoguo=null;
float sum;
float yun=15;
static boolean panduan=true;
int sit_yu,bed_yu;
//*****
public float jisuan(int xx,float yy){
return xx*yy;
}
//计算
void ji_suan(boolean nn)throws Exception{
if(nn)
{
this.sit_yu=this.guoguo.getInt("seatNum")-Integer.parseInt(this.txt_num.getText());
this.sum=this.jisuan(Integer.parseInt(this.txt_num.getText()),this.guoguo.getFloat("seatprice"));
}
else{
this.bed_yu=this.guoguo.getInt("bedNum")-Integer.parseInt(this.txt_num.getText());
this.sum=this.jisuan(Integer.parseInt(this.txt_num.getText()),this.guoguo.getFloat("bedprice"));}
}
//传递
void chuan(){
mm.xiugai_sql(this.txt_no.getText());
}
//show
void showshow()throws SQLException{
this.chuan();
mm.lian_driver();
this.guoguo=mm.fan_guo();
if(this.guoguo.next())
//{ this.guoguo.next();}else {this.guoguo.close();}
{
// try{
// this.ji_suan(this.yingzuo.isSelected());
// }catch(Exception af){}
this.panduan=true;
this.ceshi();
this.guoguo.close();
}
else{this.txt_num.setText("");
this.panduan=false;
this.ceshi();
this.guoguo.close();
}
}
private void jbInit() throws Exception {
getContentPane().setLayout(null);
jb_top.setText("订购火车票");
jb_top.setBounds(new Rectangle(154, 18, 80, 32));
checi.setText("火车车次:");
checi.setBounds(new Rectangle(60, 86, 83, 29));
fangshi.setText("乘车方式:");
fangshi.setBounds(new Rectangle(58, 145, 70, 28));
yingzuo.setText("硬座");
yingzuo.setBounds(new Rectangle(139, 147, 71, 23));
yingzuo.addActionListener(new trainfram_yingzuo_actionAdapter(this));
yingwo.setText("硬卧");
yingwo.setBounds(new Rectangle(225, 145, 64, 26));
yingwo.addActionListener(new trainfram_yingwo_actionAdapter(this));
shuliang.setText("订购数量：");
shuliang.setBounds(new Rectangle(56, 212, 78, 33));
txt_num.setBounds(new Rectangle(143, 214, 120, 28));
txt_no.setBounds(new Rectangle(141, 86, 125, 29));
jb_ok.setBounds(new Rectangle(151, 285, 108, 40));
jb_ok.setText("确定");
jb_ok.addActionListener(new trainfram_jb_ok_actionAdapter(this));
this.setSize(450,450);
jop_wrong.setToolTipText("");
jop_wrong.setBounds(new Rectangle(66, 119, 262, 90));
jop_wrong.setLayout(null);
this.getContentPane().add(checi);
this.getContentPane().add(fangshi);
this.getContentPane().add(yingzuo);
this.getContentPane().add(yingwo);
this.getContentPane().add(shuliang);
this.getContentPane().add(txt_num);
this.getContentPane().add(txt_no);
this.getContentPane().add(jb_ok);
this.getContentPane().add(jop_wrong);
this.getContentPane().add(jb_top);
this.setVisible(true);
but_zu.add(yingzuo);
but_zu.add(yingwo);
}
//测试
void ceshi()throws SQLException{
if(this.panduan)
{
if(this.yingzuo.isSelected()&this.guoguo.getInt("seatNum")>=Integer.parseInt(this.txt_num.getText())|this.yingwo.isSelected()&this.guoguo.getInt("bedNum")>=Integer.parseInt(this.txt_num.getText()))
{ try{
this.ji_suan(this.yingzuo.isSelected());
}catch(Exception af){}
JOptionPane.showMessageDialog(jop_wrong,"请付款"+this.sum);
mm.gengxin(this.sit_yu,this.bed_yu,this.guoguo.getString("trainNo"),this.yingzuo.isSelected());
}
else{
JOptionPane.showMessageDialog(jop_wrong,"票数不够，请重新输入！");
}
}else
{
JOptionPane.showMessageDialog(jop_wrong,"您输入的车次不存在，请重新输入！");
}
}
public static void main(String[] args) {
trainfram trainfram = new trainfram();
}
JLabel jb_top = new JLabel();
JLabel checi = new JLabel();
JLabel fangshi = new JLabel();
JRadioButton yingzuo = new JRadioButton("",true);
JRadioButton yingwo = new JRadioButton();
JLabel shuliang = new JLabel();
JTextField txt_num = new JTextField();
JTextField txt_no = new JTextField();
JButton jb_ok = new JButton();
JOptionPane jop_wrong = new JOptionPane();
ButtonGroup but_zu = new ButtonGroup();
public void jb_ok_actionPerformed(ActionEvent e) {
try{
this.showshow();
}catch(SQLException aaa){}
}
public void yingzuo_actionPerformed(ActionEvent e) {
}
public void yingwo_actionPerformed(ActionEvent e) {
}
}
class trainfram_yingwo_actionAdapter implements ActionListener {
private trainfram adaptee;
trainfram_yingwo_actionAdapter(trainfram adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.yingwo_actionPerformed(e);
}
}
class trainfram_yingzuo_actionAdapter implements ActionListener {
private trainfram adaptee;
trainfram_yingzuo_actionAdapter(trainfram adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.yingzuo_actionPerformed(e);
}
}
class trainfram_jb_ok_actionAdapter implements ActionListener {
private trainfram adaptee;
trainfram_jb_ok_actionAdapter(trainfram adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jb_ok_actionPerformed(e);
}
}
大家看了，给点意见。谢谢了。。。。还有好多 没有时间发。。。
发表评论
提醒: 该博客已发表在公共论坛，博客所有留言会成为论坛回贴，留言请注意遵守论坛发贴规则
lostlove
- 浏览: 1946 次
- 性别:
- 来自: 北京
- 详细资料
搜索本博客
最近加入圈子
最新评论
-
java 入门之我看
三个礼拜 皮毛而已 真正高深的估计听都没听说过
-- by insiku -
java 入门之我看
编一个计算器,挺简单的啊!只要想的好了,很容易写的!回老家了这些天,累坏了,都快 ...
-- by lostlove -
java 入门之我看
weijinxian 写道我学这个JAVA才三个礼拜，而且已经学完了！当然这是从 ...
-- by yuanqixun -
java 入门之我看
我学这个JAVA才三个礼拜，而且已经学完了！当然这是从课程上讲的，老师让编一个计 ...
-- by weijinxian -
java 入门之我看
谢谢，自己感觉写的很不好！我也是初接触，写的不好，有喜欢java的吗？一起交流下 ...
-- by lostlove
评论排行榜