JDBC连接数据库MySQL和Oracle

连接MySQL的代码

package www.libinxuan.jdbc.exmp;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestJDBC {
	
	public static void main(String[] args){
		String url = "jdbc:mysql://localhost:3306/test";
		String classname = "com.mysql.jdbc.Driver";
		String username = "root";
		String password = "root";
		Connection conn = null;
		
		String sql = "select * from user";
		String sql1 = "insert into user_tabel(username,password) values(?,?)";
		
		try {
			
			Class.forName(classname);
			conn = DriverManager.getConnection(url, username, password);
			/*PreparedStatement pst = conn.prepareStatement(sql1);
			pst.setString(1, "abc");
			pst.setString(2, "123456");
			pst.executeUpdate();*/
			
			Statement st = conn.createStatement();
			ResultSet rs = st.executeQuery(sql);
			
			System.out.print("sdsds");
			
			while(rs.next()){
				System.out.println("用户名为： " + rs.getString("username"));
				System.out.println("密码为： " + rs.getString("password"));
			}
			
			rs.close();
			st.close();
			conn.close();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
}

 连接Oracle的代码

package www.libinxuan.jdbc.exmp;

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

public class TestOracle {
	
	public static void main(String[] args){
		String url = "jdbc:oracle:thin:@localhost:1521:orcl";
		String classname = "oracle.jdbc.driver.OracleDriver";
		String username1 = "system";
		String password1 = "abc123456";
		Connection conn = null;
		
		String sql = "select * from user";
		String sql1 = "insert into user_tabel(username,password) values(?,?)";
		
		try {
			
			Class.forName(classname);
			
			conn = DriverManager.getConnection(url, username1, password1);
			/*PreparedStatement pst = conn.prepareStatement(sql1);
			pst.setString(1, "abc");
			pst.setString(2, "123456");
			pst.executeUpdate();*/
			
			Statement st = conn.createStatement();
			ResultSet rs = st.executeQuery(sql);
			
			
			
			while(rs.next()){
				System.out.println("用户名为： " + rs.getString("username"));
				System.out.println("密码为： " + rs.getString("password"));
			}
			
			rs.close();
			st.close();
			conn.close();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
}