資料庫程式設計方法總結

針對現在很多應用都與資料庫通訊相關.講訴常用的資料庫程式設計方法.如:通用的ODBC,JDBC.或者針對某一型別資料庫程式設計方法進行總結.整理時間:2009-12-01至2009-12-31

[@more@]

package com.sp;

import java.sql.*;

public class TestOra {

/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection ct=null;
Statement sm=null;
ResultSet rs=null;
try {
//jdbc-odbc
// Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// Connection ct=DriverManager.getConnection("jdbc:odbc:wgods","scott","tiger");
// Statement sm=ct.createStatement();
//
// ResultSet rs=sm.executeQuery("select * from emp");

//jdbc mysql
//Class.forName("com.mysql.jdbc.Driver");
//ct=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/wgods?user=root&password=");

//jdbc
Class.forName("oracle.jdbc.driver.OracleDriver");
ct=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:wgods","scott","tiger");
sm=ct.createStatement();
rs=sm.executeQuery("select * from emp");
while(rs.next())
{
System.out.println("使用者名稱:"+rs.getString(2));
}

} catch (Exception e) {
e.printStackTrace();
// TODO: handle exception
} finally
{
try {
rs.close();
sm.close();
ct.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}