card.java~9~

用java实现的一个网吧计费系统,大家可以参考下

package 网吧计费系统;
//package com.jbaptech.accp.netbar.server.entity;
import java.io.Serializable;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Card implements Serializable{
    public Card() {
    }
    private String id;
    public String getId(){
        return this.id;
    }
    public void setId(String id){
        this.id=id;
    }

    private static final String DRIVER_CLASS="sun.jdbc.odbc.JdbcOdbcDriver";
    private static final String DATASOURCE="jdbc:odbc:NetBarDateSource";
    static Connection getConnction(){
        Connection dbConnection = null;
        try {
            Class.forName(DRIVER_CLASS);
            dbConnection = DriverManager.getConnection(DATASOURCE);
        } catch (Exception e) {
            e.printStackTrace();
        }

        try {
            String url = "jdbc:odbc:NetBarDateSource";
            Connection con = DriverManager.getConnection(url);
            Statement s = con.createStatement();
            ResultSet rs = s.executeQuery("Select * from Card");
            while (rs.next()) {
                System.out.print(rs.getString(1) + "\t");
                System.out.print(rs.getString(2) + "\t");
                System.out.print(rs.getInt(3) + "\t");
                System.out.print(rs.getString(4) + "\t");
            }
        }catch (SQLException ce) {
            System.out.println(ce);
        }
         return dbConnection;
    }
}