jdbc串連資料庫（mysql，sqlserver，oracle）

標籤：style   blog   io   ar   color   os   sp   for   java   

package com.test;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class DBConn {        public static Connection getConn(String db){        String driverName="";        String dbURL="";        String userName = "";          String userPwd = "";         if(db.equals("sqlServer")){            driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";            dbURL = "jdbc:sqlserver://192.168.0.1:1444; DatabaseName=test";            userName = "";            userPwd = "";        }else if(db.equals("oracle")){            driverName = "oracle.jdbc.driver.OracleDriver";            dbURL = "jdbc:oracle:thin:@192.168.0.1:1521:test";            userName = "";            userPwd = "";        }else if(db.equals("mysql")){            driverName = "com.mysql.jdbc.Driver";            dbURL = "jdbc:mysql://192.168.0.1:3306/test";            userName = "";            userPwd = "";         }        Connection dbConn=null;        try {            Class.forName(driverName);            dbConn = DriverManager.getConnection(dbURL, userName, userPwd);        } catch (Exception e) {            e.printStackTrace();        }        return dbConn;    }        public static void main(String[] args) {        Connection dbConn =DBConn.getConn("oracle");        System.out.println(dbConn);        String sql = "select id from table";        PreparedStatement ps;        try {            ps = dbConn.prepareStatement(sql);            ResultSet rs = ps.executeQuery();            while(rs.next())                System.out.println(rs.getInt("id"));        } catch (SQLException e) {            e.printStackTrace();        }    }}

 

jdbc串連資料庫（mysql，sqlserver，oracle）