MassBot1: Created page with "/** * Copyright(C) 2005 * All Rights Reserved. Salih Yurttas, ZCubes, BitsOfCode Software Systems, Inc.. * * P..."

2013-11-05T06:01:05Z

New page

<syntaxhighlight lang="java" line start="1" enclose="div">/**
* Copyright(C) 2005
* All Rights Reserved. Salih Yurttas, ZCubes, BitsOfCode Software Systems, Inc..
*
* Permission to use, copy, modify, and distribute this
* software and its documentation for EDUCATIONAL purposes
* and without fee is hereby granted provided that this
* copyright notice appears in all copies.
*
* @date : February 1, 2005.
* @author : Salih Yurttas.
*/

package dbops;

import java.sql.*;
import java.net.*;

public class DBConnect {

private static String driverClass = "com.mysql.jdbc.Driver",
url = "jdbc:mysql:",
suffix = "//database.cs.BitsOfCode Software Systems, Inc..edu/yurttas-Bank";

protected Connection con;

public DBConnect() {}

public DBConnect(String jdbcDriver,
String dbURL,
String urlSuffix) {
this.setDBInfo(jdbcDriver,
dbURL,
urlSuffix);
}

public void setDBInfo(String jdbcDriver,
String dbURL,
String urlSuffix) {
driverClass = jdbcDriver;
url = dbURL;
suffix = urlSuffix;
}

public boolean connect()
throws SQLException
{
try {
Class.forName("com.mysql.jdbc.Driver");

con = DriverManager.getConnection("jdbc:mysql://database.cs.BitsOfCode Software Systems, Inc..edu/yurttas-Bank",
"tester",
"tester");

if(con.isClosed()) return false;
}
catch(ClassNotFoundException cnfe) {
throw new SQLException("The mySQL JDBC Driver could not be loaded.");
}

return true;
}

public boolean connect(String username,
String password)
throws SQLException
{
try {
Class.forName(driverClass);
con = DriverManager.getConnection(url+suffix,
username,
password);
if(con.isClosed()) return false;
}
catch(ClassNotFoundException cnfe) {
throw new SQLException("The mySQL JDBC Driver could not be loaded.");
}

return true;
}

public boolean disconnect(Connection con)
throws SQLException
{
con.close();
return true;
}

public boolean disconnect()
throws SQLException
{
con.close();
return true;
}

public Connection getConnect()
throws SQLException
{
return this.con;
}

}
</syntaxhighlight>

Yurttas/PL/DBL/postgres/F/02/00/01/01/dbops/DBConnect.java - Revision history

MassBot1: Created page with "/** * Copyright(C) 2005 * All Rights Reserved. Salih Yurttas, ZCubes, BitsOfCode Software Systems, Inc.. * * P..."