SqlServer、Oracle、MySQL的连接,除了地址和驱动包不同,其他都一样的。
1 public String urlString="jdbc:sqlserver://localhost:1433;databaseName=crebas;"; 2 //"jdbc:mysql://localhost:3306/crebas?autoReconnect=true&useUnicode=true&characterEncoding=utf8" 3 //"jdbc:oracle:thin:@localhost:1521:ORCL" 4 public String nameString="sa"; 5 public String password="123"; 6 public void test() 7 { 8 String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; 9 //"com.mysql.jdbc.Driver" 10 //"oracle.jdbc.driver.OracleDriver" 11 try 12 { 13 Class.forName(driver); 14 Connection conn = DriverManager.getConnection(urlString, nameString, password); 15 PreparedStatement pstmt = conn.prepareStatement("Select * from T_Admin"); 16 ResultSet rs = pstmt.executeQuery(); 17 rs.next(); 18 System.out.println(rs.getString(1)); 19 System.out.println(rs.getString(2)); 20 System.out.println(rs.getString(3)); 21 } catch (Exception e) 22 { 23 e.printStackTrace(); 24 } 25 }
最基础的连接方式,好久之前整理的了,备忘一下。