java访问DB的代码片段

现在的位置: 首页 > 综合 > 正文

RSS

java访问DB的代码片段

2013年10月06日 ⁄ 综合 ⁄ 共 2286字 ⁄ 字号小中大 ⁄ 评论关闭

虽然这些随便在网上suo一下，就有，但是我还是把它收集起来，别人不看，自己总可以看看吧！？

【java--MySQL】
    void goMYSQL() ...{
        java.sql.Connection conn = null;
        String drv1, url1, user1, psw1;
        drv1 = "com.mysql.jdbc.Driver";
        url1 = "jdbc:mysql://localhost:3306/FWN?useUnicode=true&characterEncoding=utf8";
        user1 = "root";
        psw1 = "root";
        try ...{
            Class.forName(drv1);
            conn = DriverManager.getConnection(url1, user1, psw1);
            System.out.println("conn="+conn);
        } catch (Exception ex) ...{
            ex.printStackTrace();
        } finally ...{
            try ...{
                if (conn != null) ...{
                    conn.close();
                }
            } catch (Exception ex) ...{
                ex.printStackTrace();
            }
        }
    }
【java --- SQLServer】
【java oracle】

    <bean id="tp_sms_dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName">
            <value>oracle.jdbc.driver.OracleDriver</value>
        </property>

        <property name="url">
            <value>jdbc:oracle:thin:@localhost:1521:LINUX10</value>
        </property>
        <property name="username">
            <value>thridparty</value>
        </property>
            <property name="password">
            <value>thridparty</value>
        </property>
    </bean>

    void goSqlServer()...{
        java.sql.Connection conn = null;
        String drv1, url1, user1, psw1;
        String drv2, url2, user2, psw2;
        drv1 = "com.inet.tds.TdsDriver";
        url1 = "jdbc:inetdae7:localhost:1433?database=jsp";
        user1 = "jsp1";
        psw1 = "1234567890";
        try ...{
            Class.forName(drv1);
            conn = DriverManager.getConnection(url1, user1, psw1);
            System.out.println("conn="+conn);
        } catch (Exception ex) ...{
            ex.printStackTrace();
        } finally ...{
            try ...{
                if (conn != null) ...{
                    conn.close();
                }
            } catch (Exception ex) ...{
                ex.printStackTrace();
            }
        }
    }