java访问DB的代码片段

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

1. 【java--MySQL】
2.      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();
               }
           }
       }
3. 【java --- SQLServer】
4. 【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();
               }
           }
       }

相关mysql jar包：http://download1.youkuaiyun.com/down3/20070521/21151228821.jar

相关oracle jar包：http://download1.youkuaiyun.com/down3/20070521/21151531564.jar

相关sqlserver jar包：TdsSqlServerJdbc2.jar