JDBC连接三大数据库方法

╰+哭是因爲堅強的太久メ 2022-06-16 13:52 187阅读 0赞

一 ：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("连接失败");  
  
  
\}  
          
\}  
\}