Oracle Database Connection for Java

PART 1

Oracle Download

Install Oracle database and do steps below in image

After select  Go To Database Home Page  a login page appear and then enter your username(what u give at installation time) and password (what u give at installation time)  following page appear

After select sql command  following page appear

Enter and Run your query here .

Table is created .

PART 2

In windows xp Start  --> Control Panel  --> Performance and Maintanenace --> Administratvie Tool --> Data Source(odbc)

• ODBC Data Source Administrator dialog box appear
• click Add Button
• Create New Data Source dialog box appear

select Oracle in XE and Click Finish Button following dialog box appear

Fill information like above image and select ok button.After that your connectOracle created.

PART 3

Create Project and import ODBC jar into library  from your installation path

C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib\ojdbc14.jar

Java Coding

INSERT CODING:

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.Statement;

public class InsertRecord {

public static void main(String[] args) {

String driver="sun.jdbc.odbc.JdbcOdbcDriver";

String cs="jdbc:odbc:connectoracle";

String user = "system";

String pwd = "admin";

 String sqlstmt="INSERT INTO GANESH2 VALUES(7,'ambross')";

 //String sqlstmt1="create table login(ID Number NOT NULL ,Name Varchar2(50),Password Varchar2(50),CONSTRAINT login_PK PRIMARY KEY (ID) ENABLE);";

Connection con = null;

Statement st = null;

try

{

Class.forName(driver);

}

catch(Exception e)

{

System.out.println(e);

}

System.out.println("Driver loaded");

try

{

con=DriverManager.getConnection(cs,user,pwd);

System.out.println("Connected to the Oracle Database");

st = con.createStatement();//creates a Statement object for sending SQL statements to the database.

//st.executeQuery(sqlstmt);

int updatecount=st.executeUpdate(sqlstmt);//return either the row count for INSERT, UPDATE or DELETE statements, or 0 for SQL statements that return nothing

//System.out.println(updatecount+" row inserted");

}

catch(Exception e)

{

System.out.println(e);

}

try

{

st.close();

con.close();

}

catch(Exception e)

{

System.out.println(e);

}

}//main()

}//class()

VIEW CODING:

import java.sql.*;

public class oracle {

public static void main(String[] args) {

String driver="sun.jdbc.odbc.JdbcOdbcDriver"; //

String cs="jdbc:odbc:connectOracle"; //connectOracle is the data source name

String user = "system"; //username of oracle database

String pwd = "admin"; //password of oracle database

Connection con = null; //connection variable assigned to null

try

{

Class.forName(driver);// for loading the jdbc driver

}

catch(Exception e)

{

System.out.println(e);

}

System.out.println("JDBC Driver loaded");

try

{

  con=DriverManager.getConnection(cs,user,pwd);// for establishing connection with database

Statement s=con.createStatement();

  ResultSet r=s.executeQuery("select * from ganesh2");

while(r.next())

{

  System.out.println("ID:"+r.getInt("id")+" Password:"+r.getString("name"));

}

}

catch(Exception e)

{

System.out.println(e);

}

System.out.println("Connected to the Oracle Database");

try

{

con.close();

}

catch(Exception e)

{

System.out.println(e);

}

}//end of main()

}//end of class()

Read more »

Java Swing Look and Feel

Download Link for Look and Feel Jar:
Download

• Double Click and open  nimrodlf-1.2.jar and...

• Save NimRODThemeFile in your project source folder and set like below in your main class

            UIManager.setLookAndFeel("com.nilo.plaf.nimrod.NimRODLookAndFeel");

• Add nimrodlf-1.2.jar in your project library folder. 

Read more »

Simple WebApplication Using Spring

In Netbeans Go File --> New Project

select java webapplication like show below:

Click Next--->click Next-->and select framework in framework window like show below:

Click -->Next

Now its ready for coding part....

Create java class bean.java

--------------------------------------Coding Start-------------------------------------

public class bean {
public void myexample()
{
System.out.println("Hello my spring by ganesh");
}
}

 --------------------------------------Coding End------------------------------------- 

Create Main class main.java

--------------------------------------Coding Start-------------------------------------

public class main {
public static void main(String[] args) {
XmlBeanFactory xml=new XmlBeanFactory(new ClassPathResource("myxml.xml"));
bean b=(bean)xml.getBean("mybean");
b.myexample();
}

}

 --------------------------------------Coding End------------------------------------- 

Create Spring xml Configuration file  myxml.xml like show below:

myxml.xml

 --------------------------------------Coding Start-------------------------------------

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
">
<bean id="mybean" class="bean"/>
</beans>

 --------------------------------------Coding End------------------------------------- 

Run your main class

Ouput :

Hello my spring by ganesh.

Read more »