Kode Java

 
package org.kodejava.example.sql;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
 
public class DropTableExample {
	public static void main(String[] args) throws Exception {
		Connection connection = null;
		try
		{
			// This is the JDBC driver class for Oracle database
			Class.forName("oracle.jdbc.driver.OracleDriver");
			
			// We use an Oracle express database for this example
			String url = "jdbc:oracle:thin:@localhost:1521:xe";
			
			// Define the username and password for connection to
			// our database.
			String username = "kodejava";
			String password = "welcome";
			
			// To delete a table from database we use the DROP TABLE
			// command and specify the table name to be dropped
			String sql = "DROP TABLE books";		
 
			// Connect to database
			connection = DriverManager.getConnection(url, username, password);
			// Create a statement
			Statement statement = connection.createStatement();
			// Execute the statement to delete the table
			statement.execute(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			if (connection != null && !connection.isClosed()) {
				connection.close();
			}
		}
	}
}
 
 

• How do I convert String to Date object?
• How do I convert array to collection?
• How do I get day, month, year value from the current date?
• How do I read a text file?
• How do I format a number?
• How do I get the current month name?
• How do I use StringTokenizer to split a string?
• How do I convert collection into array?
• How do I do a date add or substract?
• How do I write string data to file?
• How do I convert InputStream to String?
• How do I calculate days difference between two dates?
• How do I reverse a string?
• How do I read text file content line by line using commons-io?
• How do I implement a Singleton pattern?
• What need to be prepared for learning Java Programming?
• How do I read file contents to string using commons-io?
• How do I split a string?
• How do I get MAC address of a host?
• How do I create a zip file?

• How do I read user input from console using Scanner class?
• How do I query records from table?
• How do I get servlet request URL information?
• Hello World example in Java
• How do I create a connection to database?
• How do I send an email with attachment?
• How do I create a client-server socket communication?
• How do I create a beep sound?
• How do I use DataInputStream and DataOutputStream?
• What is Autoboxing?
• How do I convert Date to String?
• How do I create Hibernate's SessionFactory?
• How do I read file using Scanner class?
• How do I sort items of an ArrayList?
• How do I write text file?
• How do I use ResourceBundle for i18n?
• How do I use JFormattedTextField to format user input?
• How do I use RandomAccessFile class?
• How do I convert milliseconds value to date?
• How do I convert string into InputStream?

• How do I prevent bean's property being serialized to XML?
• How do I convert LinkedList to array?
• How do I convert an XML persistence to bean?
• How do I convert a bean to XML persistence?
• How do I create a multi lines tool tips?
• How do I disable / enable application tool tips?
• How do I set a tool tip for swing component?
• How do I create undecorated frame?
• How do I get system functions supported by database?
• How do I get date time functions supported by database?
• How do I get numeric functions supported by database?
• How do I get string functions supported by database?
• How do I get the max concurrent connection to a database?
• How do I get database maximum table name length?
• How do I know if database support updatable result sets?
• How do I know if database support scrollable result sets?
• How do I know if database support batch update?
• How do I create type specific collections?
• How do I get all available timezones?
• How do I get data types supported by database?

• How do I know if database support transaction?
• How do I get database product information?
• How do I get JDBC driver information?
• How do I get currency symbol?
• How do I create mouse event using Robot class?
• How do I get the color of a pixel?
• How do I create key press event using Robot class?
• How do I capture a screenshot?
• How do I convert BigInteger into another radix number?
• How do I do math operation for BigDecimal?
• How do I do math operation for BigInteger?
• How do I get the name of a class?
• How do I know if a class object is an interface or a class?
• How do I get interfaces implemented by a class?
• How do I get package name of a class?
• How do I get super class of an object?
• How do I split-up string using regular expression?
• How do I get list of stored procedure names?
• How do I read CLOBs data from database?
• How do I store CLOBs data into database?