dbcon.java~5~

实现了在线订火车票的功能。 java开发

package trainex;
import java.sql.*;
public class DBCon {
    Connection con=null;
    Statement s=null;
    ResultSet rs=null;
    public DBCon() {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
    }
    public boolean getconnection()
    {
        boolean b=false;
        try {
            con = DriverManager.getConnection(
                    "jdbc:odbc:Driver={SQL SERVER};server=.;uid=sa;pwd=;database=Train");
            s = con.createStatement();
            b=true;
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return b;
    }
    public ResultSet getselect(String sql)
    {
        try {
            if (getconnection()) {
                rs = s.executeQuery(sql);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return rs;
    }
    public void setclose()
    {
        if(con!=null)
        {
            try {
                con.close();
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }
    }
}