oracleÁ¬½ÓÊý¾Ý¿â²âÊÔ´úÂë
oracleÁ¬½ÓÊý¾Ý¿â²âÊÔ´úÂë
/**
*
* ˵Ã÷£º
* £¨1£©±¾ÀýʹÓÃJDBC_ODBCÇŽøÐÐÊý¾Ý¿âÁ¬½Ó£¬¹Ê´ËÐèÒªODBCÊý¾ÝÔ´
* £¨2£©±¾ÀýÖÐSQLΪ¸üÐÂÓï¾ä£¬¹Ê´ËʹÓÃÔØÌåµÄexecuteUpdate·½·¨£¬²¢ÇÒ·µ»ØÊÜÓ°Ïì¼Ç¼Êý
* (3) ÅäÖÃÁ¬½ÓORACLEµÄodbcÊý¾ÝÔ´ora
*/
//µ¼ÈëËùÐèÀà°ü
import java.sql.*;
public class JdbcTestOra2 {
public static void main(String args[]) {
try {
//×°ÔØÇý¶¯³ÌÐò
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//½¨Á¢Êý¾Ý¿âÁ¬½Ó
Connection con =
DriverManager.getConnection("jdbc:odbc:ora","scott","tiger");
//´´½¨SQLÓï¾äÔØÌå
Statement st = con.createStatement();
//Ö´ÐÐSQLÓï¾ä£¬½ÓÊÕÖ´Ðнá¹û
int rs = st.executeUpdate("update emp set
comm=1000");
//´¦Àí½á¹û
System.out.println("Ð޸ļǼÊý£º"+rs);
//ÊÍ·ÅÊý¾Ý¿â×ÊÔ´£¬×¢Òâ˳Ðò
st.close();
con.close();
}
catch (Exception e) {
e.printStackTrace(System
Ïà¹ØÎĵµ£º
1¡¢²éѯÁ½¸öÈÕÆÚÖ®¼äµÄÊý¾Ý¡£
¼ÙÉèÓбíTable1£¬Æä´´½¨±íµÄsqlÓï¾äΪ£º
create table Table1(
StationID NUMBER(10) Primary key,
Year NUMBER(4) not null,
Month NUMBER(2) n ......
Êý¾Ý±íµÄÁ¬½ÓÓÐ:
1¡¢ÄÚÁ¬½Ó(×ÔÈ»Á¬½Ó): Ö»ÓÐÁ½¸ö±íÏàÆ¥ÅäµÄÐвÅÄÜÔÚ½á¹û¼¯ÖгöÏÖ
2¡¢ÍâÁ¬½Ó: °üÀ¨
£¨1£©×óÍâÁ¬½Ó(×ó±ßµÄ±í²»¼ÓÏÞÖÆ)
£¨2£©ÓÒÍâÁ¬½Ó(ÓÒ±ßµÄ±í²»¼ÓÏÞÖÆ)
£¨3£©È«ÍâÁ¬½Ó(×óÓÒÁ½±í¶¼²»¼ÓÏÞÖÆ)
3¡¢×ÔÁ¬½Ó(Á¬½Ó·¢ÉúÔÚÒ»Õ ......
½ñÌì²Î¼ÓÁËOracle & SUNºÏ²¢ºóµÚÒ»´ÎÓëºÏ×÷»ï°é¼°¿Í»§µÄÍ¨Æø»á¡£Õû¸ö»áÒ鏸ÎҵĸоõÊÇ£ºOracleÐÛÐIJª²ª£¬SUNÒâÆø·ç·¢£¬¶øÎÒ×Ô¼º£¬ÐÄ»³ã·ã·¡£ OracleÓÐÁËSUN£¬ÄÇô´ÓÓ²¼þµ½Èí¼þOracleµÄ²úÆ·Ïß¾ÍÊ®·ÖÆë±¸ÁË¡£Oracle°ëÄêÇ°ÍÆ³ö11gR2 for linux£¬½Ó×Åfor solar ......
Wait Problem Potential Fix Sequential Read Indicates many index reads—tune the code (especially joins) Scattered Read Indicates many full table scans—tune the code; cache small tables ......