package client;
import com.ibm.as400.access.AS400JDBCDriver;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import sun.jdbc.odbc.ee.ConnectionHandler;
public class MyConnectionHandler {
public Connection ConnectToAS400() {
String IPAS400 = "172.20.15.5";
String Id = "";
String Pw = "";
System.out.println("Connessione ad AS400");
try {
DriverManager.registerDriver(new AS400JDBCDriver());
} catch (SQLException e) {
e.printStackTrace();
}
String name = "jdbc:as400://" + IPAS400;
Connection AS400Connection = null;
try {
AS400Connection = DriverManager.getConnection(name, Id, Pw);
} catch (SQLException e) {
e.printStackTrace();
}
return AS400Connection;
}
public void closeAS400Connection(Connection connection) {
try {
connection.close();
System.out.println("Disconnessione da AS400");
} catch (SQLException e) {
e.printStackTrace();
}
}
public Connection ConnectToAccess() {
String dbFile = "\\\\fs3\\file\\Repcel\\Produttivita\\Presenze.mdb";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
String url =
"jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)}; DBQ= " +
dbFile;
Connection AccessConnection = null;
try {
AccessConnection = DriverManager.getConnection(url);
} catch (SQLException e) {
e.printStackTrace();
}
return AccessConnection;
}
public void closeAccessConnection(Connection AccessConnection) {
try {
AccessConnection.close();
System.out.println("Disconnessione da Access");
} catch (SQLException e) {
e.printStackTrace();
}
}
private void connectToSQLServer2000() throws ClassNotFoundException, SQLException {
String url = "jdbc:jtds:sqlserver://FS01;instance=GP1;DatabaseName=EasyTime";
String driver = "net.sourceforge.jtds.jdbc.Driver";
String userName = "sa";
String password = "sa";
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, userName, password);
System.out.println("Connected to the database!!! Getting table list...");
DatabaseMetaData dbm = conn.getMetaData();
ResultSet rs = dbm.getTables(null, null, "%", new String[] { "TABLE" });
while (rs.next()) System.out.println(rs.getString("TABLE_NAME"));
}
}