Category Archives: oracle

「Oracle入門」SYSDATE関数の使い方

操作コマンド下記

OracleとJDBC Thinドライバの接続文字列を設定するサンプル

Javaコード
import java.sql.Connection;
public class OracleConnectTest {

/**
* @param args
* @throws ClassNotFoundException
* @throws SQLException
*/
public static void main(String[] args) throws ClassNotFoundException, SQLException {
// TODO Auto-generated method stub

Class.forName(“oracle.jdbc.driver.OracleDriver”);

Connection conn = null;

Statement stmt = null;

ResultSet rs =null;
String url = “jdbc:oracle:thin:@localhost:1521:opdatabase”;
conn = DriverManager.getConnection(url,”scott”,”tiger”);
stmt = conn.createStatement();

rs = stmt.executeQuery(“select * from STU_TBL”);

while(rs.next())
{
System.out.println(rs.getObject(1));
}

stmt.close();
conn.close();
}
}

6 / 6« 先頭...23456