dbcon.java~3~

来自「实现了在线订火车票的功能。 java开发」· JAVA~3~ 代码 · 共 34 行

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)
    {
        if(getconnection())
        {
            rs=s.executeQuery(sql); 
        }
    }
}