99久久亚洲综合精品网站,久久精品亚洲精品国产色婷 ,99久久777色

jsp數(shù)據(jù)庫連接大全和數(shù)據(jù)庫操作封裝到Javabean 轉(zhuǎn)帖備查

jsp數(shù)據(jù)庫連接大全和數(shù)據(jù)庫操作封裝到Javabean

來源： http://blog.csdn.net/cm4ever/

一、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ū)動名稱:連接模式:@數(shù)據(jù)庫服務(wù)器ip:端口號:數(shù)據(jù)庫SID"
    String url = "jdbc:oracle:thin:@localhost:1521:orcl";
    String username = "scott"; // 用戶名
    String password = "tiger"; //密碼

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

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

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

    rs.close(); // 關(guān)閉結(jié)果集
    stmt.close(); // 關(guān)閉執(zhí)行語句對象
    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ū)動名稱://數(shù)據(jù)庫服務(wù)器ip:端口號;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() )
    {
        %>
        第一個字段內(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ū)動名稱://數(shù)據(jù)庫服務(wù)器ip:端口號/數(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ū)動名稱://數(shù)據(jù)庫服務(wù)器ip:端口號/數(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ū)動名稱:數(shù)據(jù)庫服務(wù)器ip:端口號/數(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ū)動名稱://數(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ū)動名稱://數(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();
%>

下面是簡單的數(shù)據(jù)庫操作Javabean的代碼:

DbWrapper.java

import java.sql.*;import java.util.*;publicclass DbWrapper
                        {// 定義連接池對象為靜態(tài)變量，將一直存在，直到工作目錄關(guān)閉。privatestatic DataSource ds =null;
// 1.用連接池的方式獲得連接// 如果不是做多數(shù)據(jù)庫程序，推薦使用此方法// 相關(guān)內(nèi)容：在tomcat管理界面配置連接池publicstatic Connection openConnection()throws Exception
                        {// 只需要初始化1次if( ds ==null){
                        Context initContext =newInitialContext();
                        Context envContext =(Context) initContext.lookup("java:/comp/env");
                        DataSource ds =(DataSource) envContext.lookup("jdbc/MyDataSource");}return ds.getConnection();}// 2.用jdbc驅(qū)動獲得連接// 相關(guān)內(nèi)容：JSP數(shù)據(jù)庫連接大全publicstatic Connection openConnection(
                        String driver,
                        String url,
                        String username,
                        String password)throws Exception
                        {
                        Class.forName(driver).newInstance();return DriverManager.getConnection(url, username, password);}publicstaticvoidcloseConnection(Connection conn)throws Exception
                        {if( conn !=null){
                        conn.close();}}
publicstaticintexecuteUpdate(String sql)throws Exception
                        {int count =0;
                        Connection conn =null;
                        Statement  stmt =null;try{
                        conn =openConnection();
                        stmt = conn.createStatement();
                        count = stmt.executeUpdate(sql);}catch( Exception e ){throw e;}finally{closeConnection(conn);}return count;}publicstatic List executeQuery(String sql)throws Exception
                        {
                        List list =newArrayList();
                        Connection conn =null;
                        Statement  stmt =null;
                        ResultSet  rs   =null;try{
                        conn =openConnection();
                        stmt = conn.createStatement();
                        rs   = stmt.executeQuery(sql);
                        ResultSetMetaData rsmd = rs.getMetaData();while( rs.next()){
                        Map map =newHashMap();for(int i =1; i <= rsmd.getColumnCount(); i++){
                        map.put(rsmd.getColumnName(i), rs.getObject(i));}
                        list.add(map);}
}catch( Exception e ){
                        e.printStackTrace();}finally{if( rs !=null) rs.close();closeConnection(conn);}return list;
}}

// 1.對于insert, update, delete語句
int count = DbWrapper.executeUpdate(sql);
// 2.對于selete語句
                        java.util.List list = DbWrapper.executeQuery(sql);
// 方法一:按名字取值，注意大小寫是嚴(yán)格區(qū)分的for(int i =0; i < list.size(); i++){
                        java.util.Map map =(java.util.Map)list.get(i);
                        out.println(mag.get("column_name").toString());}
// 方法二：遍歷取值for(int i =0; i < list.size(); i++){
                        java.util.Map map =(java.util.Map)list.get(i);
for(java.util.Iterator it = map.keySet().iterator(); it.hasNext();){
                        String column_name = it.next().toString());

// 取值時注意null判斷
                        out.println(column_name +" = "+ map.get(column_name) ==null?"": map.get(column_name).toString());}}

posted on 2008-10-14 14:40 aslucky 閱讀(575) 評論(0) 編輯收藏引用所屬分類: web

只有注冊用戶登錄后才能發(fā)表評論。
【推薦】100%開源！大型工業(yè)跨平臺軟件C++源碼提供，建模，組態(tài)！

相關(guān)文章: jsp數(shù)據(jù)庫連接大全和數(shù)據(jù)庫操作封裝到Javabean 轉(zhuǎn)帖備查 javascript 有時很好用 jsp 中文傳參亂碼的解決 eclipse 使用myeclipse配置jsp開發(fā)環(huán)境

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

aslucky

jsp數(shù)據(jù)庫連接大全和數(shù)據(jù)庫操作封裝到Javabean 轉(zhuǎn)帖備查

jsp數(shù)據(jù)庫連接大全和數(shù)據(jù)庫操作封裝到Javabean

導(dǎo)航

統(tǒng)計

常用鏈接

留言簿(1)

隨筆分類(6)

隨筆檔案(6)

文章分類(2)

文章檔案(2)

Open source library

Software often use

搜索

積分與排名

最新評論

閱讀排行榜

評論排行榜

aslucky

jsp數(shù)據(jù)庫連接大全和數(shù)據(jù)庫操作封裝到Javabean 轉(zhuǎn)帖 備查

jsp數(shù)據(jù)庫連接大全和數(shù)據(jù)庫操作封裝到Javabean

導(dǎo)航

統(tǒng)計

常用鏈接

留言簿(1)

隨筆分類(6)

隨筆檔案(6)

文章分類(2)

文章檔案(2)

Open source library

Software often use

搜索

積分與排名

最新評論

閱讀排行榜

評論排行榜

jsp數(shù)據(jù)庫連接大全和數(shù)據(jù)庫操作封裝到Javabean 轉(zhuǎn)帖備查