javaè¿æ¥Oracle11Gï¼
1ï¼æ¾å°é©±å¨å
ï¼å¨oracleå®è£
ç®å½ä¸æçæ¯D:\Oracle\product\11.1.0\db_1\jdbc\libï¼æ¤ç®å½ä¸æojdbc5.jar,ojdbc6.jar,å¦æjdk5å°±ç¨5ï¼6å°±ç¨6ï¼
2ï¼é
置驱å¨å
çåéï¼ææ驱å¨å
æ·åºæ¥ï¼æ¾å¨d:\java\utiléé¢ï¼ï¼é
ç½®åä¸é¢MYSQLç类似ã
3ï¼æµè¯ä»£ç ï¼
import java.sql.Connection ;
import java.sql.DriverManager ;
import java.sql.SQLException ;
import java.sql.PreparedStatement ;
public class JDBCOracle{
// å®ä¹æ°æ®åºé©±å¨ç¨åº
public static final String DBDRIVER = "oracle.jdbc.driver.OracleDriver" ;
// å®ä¹æ°æ®åºçè¿æ¥å°å
public static final String DBURL = "jdbc:oracle:thin:@localhost:端å£å·:æ°æ®åºæ è¯ç¬¦" ;
//端å£å·åæ è¯ç¬¦å¯ä»¥éè¿å¨docä¸è¿è¡lsnrctl statusæ¥ç default:1521
// æ°æ®åºçè¿æ¥ç¨æ·å
public static final String DBUSER = "scott" ;
// æ°æ®åºçè¿æ¥å¯ç
public static final String DBPASS = "tiger" ;
public static void main(String args[]) throws Exception{ // ææå¼å¸¸æåº
Connection conn = null ; // æ°æ®åºè¿æ¥
Class.forName(DBDRIVER) ; // å 载驱å¨ç¨åº
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS) ;
PreparedStatement pstmt = null ;
String sql = "INSERT INTO person(id,name,age,birthday) VALUES (myseq.nextVal,?,?,?)" ;
pstmt = conn.prepareStatement(sql) ;
pstmt.setString(1,"tomcat") ;
pstmt.setInt(2,30) ;
pstmt.setDate(3,new java.sql.Date(new java.util.Date().getTime())) ;
pstmt.executeUpdate() ; // æ§è¡æ´æ°æä½
pstmt.close() ;
conn.close() ; // æ°æ®åºå
³é
}
};
温馨提示:答案为网友推荐,仅供参考