Run Java query Oracle

Source Code

จะแสดง Table ใน Oracle ออกมา
--------------------------------------------------

import java.sql.* ;
//import oracle.jdbc.OracleDriver;
public class showtable{
public static void main(String[] args) throws Exception
{
System.out.println("OK");

String sql = "select * from tab" ;
getdb( sql ) ;

}
public static void getdb(String sql ) throws Exception
{
Class.forName("oracle.jdbc.OracleDriver").newInstance();

String url = "jdbc:oracle:thin:@192.168.1.2:1521:schemaname";
String user = "user" ;
String pass  = "password" ;
Connection con = DriverManager.getConnection(url , user, pass) ;
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sql ) ;
while(rs.next() ){
System.out.println(rs.getString(1));
}
rs.close();
stmt.close();
con.close();
}

}

-----------------------------------------------------------------------------
run.bat


set classpath=.;c:\Program Files\Java\jdk1.6.0_13\jre\lib\ext\classes12_g.jar;
javac  showtable.java
java  showtable


-----------------------------------------------------------------------------

GlassFish Link From Twiiter

GlassFish Link ( Oracle/Sun )

• http://blogs.sun.com/vkraemer/entry/glassfish_3_1_and_netbeans
• http://blogs.sun.com/misty/entry/glassfish_3_1_and_deployment
• http://blogs.sun.com/nazrul/entry/glassfish_3_1
• http://blogs.sun.com/bobby/entry/moving_on_up_upgrading_to
• http://blogs.sun.com/anilam/entry/glassfish_3_1_new_features1
• New Release http://blogs.oracle.com/devtools/2011/02/hot_new_glassfish_31_bits_rele.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed:+orana+(OraNA)

GlassFish Server 3.1 now available  http://glassfish.java.net/

Oracle SQL
http://timurakhmadeev.wordpress.com/2011/02/28/distinct-placement/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed:+orana+(OraNA)

-----------------------------------------------------------------------------

ออราเคิลเผยฟีเจอร์ของ Java EE 7 และ Java EE 8, อาจเลิกจัด JavaOne
http://www.blognone.com/news/22136?utm_source=twitterfeed&utm_medium=twitter

-----------------------------------------------------------------------------

Oracle Security Worst Security Practices
วิธีการปฏิบัติเกี่ยวกับความปลอดภัยฐานข้อมูล

http://www.oracle.com/us/dm/66179-securitypractices-310973.html




Oracle Database Blog , by Hemant
http://hemantoracledba.blogspot.com/2011/03/most-popular-posts-feb-11.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed:+orana+(OraNA)
http://hemantoracledba.blogspot.com/2009/04/bringing-online-datafile-that-is-in.html
http://hemantoracledba.blogspot.com/2009/06/autoextend-on-next-size.html
http://hemantoracledba.blogspot.com/2009/03/materialized-view-on-prebuilt-table.html
http://hemantoracledba.blogspot.com/2008/11/open-resetlogs-without-really-doing.html

Oracle SQL Plus Command 
http://awads.net/wp/2011/03/01/little-known-sqlplus-show-command-options/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed:+orana+(OraNA)


PL/SQL Topic
http://triangle-circle-square.blogspot.com/2011/03/i-quizzed-oracle-community.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed:+orana+(OraNA)

Oracle Trigger
http://blog.sydoracle.com/2011/03/for-each-row-trigger-fires-at-least.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed:+orana+(OraNA)

Oracle BI
http://skrajend.blogspot.com/2011/03/horizontal-scaling-obiee-11g.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed:+blogspot/skrajend+(Senthil+Rajendran's+Blog)


JDev
http://darwin-it.blogspot.com/2011/03/jdeveloper-11g-and-otn-soabpm-appliance.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed:+orana+(OraNA)

Oracle Solaris Express 11 Installation (Part 11 )

 Oracle Solaris Express 11 Installation (Part 1)

http://blogs.oracle.com/recipesolaris/2011/01/recipe_oracle_solaris_express_11_installation_part_1.html

มีต่อ Part 2  , Part 3  ถึง Part 5 ในเมนู 

Solaris เป็น Unix จริงๆ ไม่ใช่  Linux นะ 

เนื่องจาก Oracle ซื้อ Sun แล้วเลยกลายเป็นของ Oracle ไป