JDBC连接三大数据库方法

一 ：JDBC连接Oracle 
 
package com.softeem.jdbcDemo1;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;


public class OracleConnection {
   public static Connection getConn(){
  Connection conn = null;
  try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@localhost:1521:orcl";
String user="System";
String password="aaaaaa";
conn= DriverManager.getConnection(url,user,password); 

} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

return conn;
  
   }
   public static void main(String[] args) {
System.out.println(getConn());
}
}
二：JDBC连接SqlServer2005
package com.softeem.jdbcDemo;


import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Types;
import java.util.Date;


public class SqlServerConnection {
       public static Connection getConn(){
      String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
           String URL="jdbc:sqlserver://127.0.0.1:1433;databaseName=db_shoes;user=sa;password=123456";
           Connection conn=null;
      try {
java.lang.Class.forName(DRIVER);
conn=java.sql.DriverManager.getConnection(URL);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
      return conn;
       }
     }


       public static void main(String[] args) {
System.out.println(getConn());

}
}




//-----------------------------------------
Statement stmt = con.createStatement(); 
ResultSet rs = stmt.executeQuery("SELECT a, b, c FROM Table2"); 
PreparedStatement pstmt = con.prepareStatement("UPDATE table4 SET m = ? WHERE x = ?");
CallableStatement cstmt = con.prepareCall("{call getTestData(?, ?)}");
String sql ="{call proc_getmail(?,?)}";




Connection conn = new Conn().getConnect();
int num=0;
//String sql = "select count(*) from student "; 
String sql ="{call proc_getMails(?)}";
CallableStatement stmt=null;


stmt= conn.prepareCall(sql);
stmt.registerOutParameter(1, java.sql.Types.INTEGER);
stmt.execute();
num=stmt.getInt(1);


三：JDBC连接MySql
package com.sorfteem.informationsystem.until;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;


public class GetConnection {
        public static Connection getConnection(){
  String DRIVER="com.mysql.jdbc.Driver";
          String URL=""jdbc:mysql://localhost:3306/informationdate";
        Connection conn=null;
        try {
Class.forName(DRIVER);
conn=DriverManager.getConnection(URL, "root", "123456");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
       
return conn;
       
        }
        public static void main(String[] args) {
        GetConnection gc=new GetConnection();
         Connection conn = GetConnection.getConnection();
        if (conn!=null) {
System.out.println("连接成功");
} else {
System.out.println("连接失败");


}
       
}
}