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

2013-11-05T06:01:03Z

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.
*/

import dbops.DBConnect;
import dbops.DBTable;

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

public class DBDrop10 {

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

private static Connection con;

private static String urlDB = url + suffix + ".";

public static void main (String[] args) {
String username = args[0];
String password = args[1];

DBConnect dbc = new DBConnect();

try {
if(dbc.connect(args[0], args[1])) {
System.out.println("Connected to " + urlDB);

con = dbc.getConnect();

DBTable dbDrop = new DBTable(con);

String dropTable = "DROP TABLE AA;";

if(dbDrop.setStatement(dropTable))
System.out.println("Table AA is dropped from " + urlDB);
if(dbc.disconnect(con))
System.out.println("Disconnected from " + urlDB);
}
else System.out.println("Could not connect to " + urlDB);
}
catch(SQLException sqle) {
System.err.println("Error accessing " + urlDB);
System.err.println(sqle.getMessage());
}
}

}
</syntaxhighlight>

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

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