java连接不同数据库的方法

不念不忘少年蓝@ 2022-07-13 15:09 154阅读 0赞

import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    /*
     * jdbc
     */
    public class Demo1 {
    	public static void main(String[] args) {
    		Demo1 d = new Demo1();
    		d.show();
    	}
    
    	public void show() {
    		String url = "jdbc:mysql://localhost:3306/t1";
    		String username = "root";
    		String password = "123456";
    		Connection conn = null;
    		Statement stmt = null;
    		ResultSet rs = null;
    		try {
    			/*
    			 * 驱动类 
    			 * a.Access       sum.jdbc.odbc.JbcOdbcDriver 
    			 * b.SQL          Servercom.microsoft.sqlserver.jdbc.SQLServerDriver 
    			 * c.MySQL        com.mysql.jdbc.Driver 
    			 * d.Oracle       oracle.jdbc.driver.OracleDriver
    			 */
    			// 1.加载MySQL的驱动
    			Class.forName("com.mysql.jdbc.Driver");
    
    			/*
    			 * 驱动连接的方式 
    			 * a.SQL Server   conn=DriverManager.getConnection("jdbc.sqlserver://
    			 * localhost:1433;DatabaseName=t1","root","123456");
    			 * 
    			 * b.Mysql        conn=DriverManager.getConnection("jdbc:mysql://
    			 * localhost/t1","root","123456");
    			 * 
    			 * c.Oracle       conn=DriverManager.getConnection("jdbc:oracle:thin:
    			 * @localhost:1521:t1","root","123456");
    			 * 
    			 */
    
    			// 2.驱动与数据库连接
    			conn = DriverManager.getConnection(url, username, password);
    			// 3.利用连接对象conn创建Statement接口对象stmt
    			stmt = conn.createStatement();
    			rs = stmt.executeQuery("select * from tb1");
    			while (rs.next()) {
    				String name = rs.getString("username");
    				int age = rs.getInt("age");
    				double salary = rs.getDouble("salary");
    				System.out.println(name + "  " + age + "   " + salary);
    			}
    		} catch (ClassNotFoundException e) {
    			e.printStackTrace();
    		} catch (SQLException e) {
    			e.printStackTrace();
    		} finally {
    			try { // 关闭之前创建的对象
    				if (rs != null)
    					rs.close();
    				if (stmt != null)
    					stmt.close();
    				if (conn != null)
    					conn.close();
    			} catch (Exception e) {
    				e.printStackTrace();
    			}
    		}
    	}
    }