一区二区三区在线高清,国内精品久久久久久久影视简单,欧美最猛黑人xxxx黑人猛叫黄

一、jsp連接Oracle8/8i/9i數(shù)據(jù)庫（用thin模式）
testOracle.jsp如下：

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
    String result = ""; // 查詢結(jié)果字符串

    String sql = "select * from test"; // SQL 字符串

    // 連接字符串，格式： "jdbc:數(shù)據(jù)庫驅(qū)動(dòng)名稱:連接模式:@數(shù)據(jù)庫服務(wù)器ip:端口號(hào):數(shù)據(jù)庫SID"
    String url = "jdbc:oracle:thin:@localhost:1521:orcl";
    String username = "scott"; // 用戶名
    String password = "tiger"; //密碼

    // 創(chuàng)建oracle數(shù)據(jù)庫驅(qū)動(dòng)實(shí)例
    Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();

    // 獲得與數(shù)據(jù)庫的連接
    Connection conn = DriverManager.getConnection(url, username, password);
    // 創(chuàng)建執(zhí)行語句對(duì)象
    Statement  stmt = conn.createStatement();
    // 執(zhí)行sql語句，返回結(jié)果集
    ResultSet rs   = stmt.executeQuery(sql);

    while ( rs.next() )
    {
        result += "\n 第一個(gè)字段內(nèi)容：" + rs.getString(1) + "<BR>";
    }

    rs.close(); // 關(guān)閉結(jié)果集
    stmt.close(); // 關(guān)閉執(zhí)行語句對(duì)象
    conn.close(); // 關(guān)閉與數(shù)據(jù)庫的連接
%>

<HTML>
<BODY>
  <%=result%>
</BODY>
</HTML>

二、jsp連接Sql Server7.0/2000數(shù)據(jù)庫
testSqlServer.jsp如下

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
    String sql = "select * from test";

    // 連接字符串，格式： "jdbc:公司名稱:數(shù)據(jù)庫驅(qū)動(dòng)名稱://數(shù)據(jù)庫服務(wù)器ip:端口號(hào);DatabaseName=數(shù)據(jù)庫名稱"
    String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
    String username = "scott";
    String password = "tiger";

    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();

    Connection conn = DriverManager.getConnection(url, username, password);
    Statement  stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
    ResultSet rs   = stmt.executeQuery(sql);

%>

<HTML>
<BODY>

<%
    while ( rs.next() )
    {
        %>
        第一個(gè)字段內(nèi)容為：<%=rs.getStrisng(1)%><BR>
        <%
    }

    rs.close();
    stmt.close();
    conn.close();
%>

</BODY>
</HTML>

三、jsp連接DB2數(shù)據(jù)庫
testDB2.jsp如下：

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
    String sql = "select * from test";

    // 連接字符串，格式： "jdbc:數(shù)據(jù)庫驅(qū)動(dòng)名稱://數(shù)據(jù)庫服務(wù)器ip:端口號(hào)/數(shù)據(jù)庫名稱"
    String url = "jdbc:db2://localhost:5000/sample";
    String username = "scott";
    String password = "tiger";

    Class.forName("com.ibm.db2.jdbc.app.DB2Driver").newInstance();

    Connection conn = DriverManager.getConnection(url, username, password);
    Statement  stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
    ResultSet rs   = stmt.executeQuery(sql);

    rs.close();
    stmt.close();
    conn.close();
%>

四、jsp連接Informix數(shù)據(jù)庫
testInformix.jsp如下：

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
    String sql = "select * from test";

    // 連接字符串，格式： "jdbc:數(shù)據(jù)庫驅(qū)動(dòng)名稱://數(shù)據(jù)庫服務(wù)器ip:端口號(hào)/數(shù)據(jù)庫名稱:INFORMIXSERVER=服務(wù)器名;user=用戶名;password=密碼"
    String url = "jdbc:informix-sqli://123.45.67.89:1533/testDB:INFORMIXSERVER=myserver;user=testuser;password=testpassword";

    Class.forName("com.informix.jdbc.IfxDriver").newInstance();

    Connection conn = DriverManager.getConnection(url);
    Statement  stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
    ResultSet rs   = stmt.executeQuery(sql);

    rs.close();
    stmt.close();
    conn.close();
%>

五、jsp連接Sybase數(shù)據(jù)庫
testSybase.jsp如下：

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
    String sql = "select * from test";

    // 連接字符串，格式： "jdbc:公司名稱:數(shù)據(jù)庫驅(qū)動(dòng)名稱:數(shù)據(jù)庫服務(wù)器ip:端口號(hào)/數(shù)據(jù)庫名稱"
    String url = "jdbc:sybase:Tds:localhost:5007/tsdata";

Properties prop = System.getProperties();
prop.put("user", "userid"); // 用戶名
prop.put("password", "user_password"); // 密碼

    Class.forName("com.sybase.jdbc.SybDriver").newInstance();

    Connection conn = DriverManager.getConnection(url, prop);
    Statement  stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
    ResultSet rs   = stmt.executeQuery(sql);

    rs.close();
    stmt.close();
    conn.close();
%>

六、jsp連接MySQL數(shù)據(jù)庫
testMySQL.jsp如下：

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
    String sql = "select * from test";

    // 連接字符串，格式： "jdbc:數(shù)據(jù)庫驅(qū)動(dòng)名稱://數(shù)據(jù)庫服務(wù)器ip/數(shù)據(jù)庫名稱?user=用戶名&password=密碼&使用Unicode=布爾值&字符編碼=編碼"
    String url = "jdbc:mysql://localhost/softforum?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1";
    String username = "scott";
    String password = "tiger";

    Class.forName("org.gjt.mm.mysql.Driver").newInstance();

    Connection conn = DriverManager.getConnection(url, username, password);
    Statement  stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
    ResultSet rs   = stmt.executeQuery(sql);

    rs.close();
    stmt.close();
    conn.close();
%>

七、jsp連接PostgreSQL數(shù)據(jù)庫
testPostgreSQL.jsp如下：

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
    String sql = "select * from test";

    // 連接字符串，格式： "jdbc:數(shù)據(jù)庫驅(qū)動(dòng)名稱://數(shù)據(jù)庫服務(wù)器ip/數(shù)據(jù)庫名稱"
    String url = "jdbc:postgresql://localhost/soft";
    String username = "scott";
    String password = "tiger";

    Class.forName(""org.postgresql.Driver").newInstance();

    Connection conn = DriverManager.getConnection(url, username, password);
    Statement  stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
    ResultSet rs   = stmt.executeQuery(sql);

    rs.close();
    stmt.close();
    conn.close();
%>

posted on 2007-06-25 12:00 哲藤峰子閱讀(1136) 評(píng)論(3) 編輯收藏

評(píng)論

# re: jsp數(shù)據(jù)庫連接大全 2007-06-25 12:06 BeanSoft

ODBC driver
sun.jdbc.odbc.JdbcOdbcDriver
jdbc:odbc:name

用 COM.ibm.db2.jdbc.net.DB2Driver 連接到 DB2 數(shù)據(jù)庫
一個(gè) DB2 URL 的示例:
jdbc:db2://aServer.myCompany.com:50002/name

用 com.sybase.jdbc.SybDriver連接到 Sybase 數(shù)據(jù)庫
一個(gè) Sybase URL 的示例:
jdbc:sybase:Tds:aServer.myCompany.com:2025

用 connect.microsoft.MicrosoftDriver 連接到 Microsoft 數(shù)據(jù)庫
一個(gè) Microsoft URL 的示例:
jdbc:ff-microsoft//aServer.myCompany.com:1433

MySQL driver
org.gjt.mm.mysql.Driver
jdbc:mysql://hostname/dbname?useUnicode=true&characterEncoding=GBK

Microsoft SQL Server Driver
com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=WapSvc;User=sa;Password=pwd

Informix
com.informix.jdbc.IfxDriver
jdbc:informix-sqli://hostname:1526/dbname:INFORMIXSERVER=informixservername;user=username;password=password

Oracle
oracle.jdbc.driver.OracleDriver
jdbc:oracle:thin:@hostname:1521:ORCL

Postgresql
org.postgresql.Driver
jdbc:postgresql://localhost/soft 回復(fù) 更多評(píng)論

# re: jsp數(shù)據(jù)庫連接大全 2007-06-25 15:05 newbin

"大全"?怎么沒有hsql呢回復(fù) 更多評(píng)論

# re: jsp數(shù)據(jù)庫連接大全 2013-03-01 15:39 未來城市

不錯(cuò)，收藏回復(fù) 更多評(píng)論

新用戶注冊(cè) 刷新評(píng)論列表


只有注冊(cè)用戶登錄后才能發(fā)表評(píng)論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問管理

爪哇咖啡館

常用鏈接

留言簿(2)

隨筆檔案(11)

文章檔案(2)

新聞檔案(1)

我的文章

最新隨筆

搜索

積分與排名

最新評(píng)論

閱讀排行榜

評(píng)論排行榜

評(píng)論