jspÁ¬½Óoracle 10gÎÊÌâ
tomcat6µÄÊÇ
ÔÚconfϵÄcontent.xmlÀï¼ÓÈëÁË
<Resource
name="jdbc/bzydb"
type="javax.sql.DataSource"
password="abc123"
driverClassName="oracle.jdbc.driver.OracleDriver"
maxIdle="5"
maxWait="5000"
username="bzy"
url="jdbc:oracle:thin:@localhost:1521:db3cn"
maxActive="20"/>
ÏÖÔÚÏ뽨Á¢Ò»¸öÀࣺ
package dataoper;
import java.sql.Connection;
import java.sql.*;
import java.util.Enumeration;
import java.util.Vector;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class Conn {
public static Connection conn=null;
public static Connection f_conn()
{
Context initCtx=new InitialContext(); // ´íÎó´¦1
DataSource ds = (DataSource)initCtx.lookup("java:comp/env/jdbc/bzydb"); //´íÎó´¦2
Connection conn=ds.getConnection(); //´íÎó´¦3
return conn;
}
}
´íÎó´¦123 Óдí
¶øÕâÈýÐдúÂëдÔÚjspµÄÒ³ÃæÖÐʱ£¬¾ÍûÓдíÎó
¸Õ¿ªÊ¼×öjava¡£
ÒÔºó»¹¶à¹ØÕÕ£¡
ÏëÓÃÅäÖÃÎļþÒ²¿ÉÒÔ¶¯Ì¬µÄ¹
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÊÌâÃèÊö£º
ÀýÈçÎÒÒªÏÔʾµÄÄÚÈÝÈçÏÂËùʾ
Ò»¼¶Ä¿Â¼1
Ò»¼¶Ä¿Â¼1×ÓÀà1
×ÓÀà1
Ò»¼¶Ä¿Â¼1×ÓÀà2
......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÎÒÊǸöÐÂÊÖ£¬×öÒ»¸öJSPÍøÒ³£¬ÎÒÒª¶Á³öÊý¾Ý¿âÕý³££¬µ«ÊÇÎÒÒªÐ޸ĵÄʱºò£¬Ò²¾ÍÊǶÁÈëµÄʱºò³öÏÖÂÒÂ룬Çë¸ßÊÖ¸æËßÎÒÔõô½â¾ö£¬ÏÈллÁË¡£
request.setCharacterEncoding("UTF-8");
°Ñ±àÂëͳһ
/**
......