JavaJDBC的简单写法包括Oracle、MySQL、SqlServer

public class JDBC {public static void main(String[] args) {//Oracle 数据库连接Connection oracle_conn = null;Statement oracle_stmt = null;ResultSet oracle_rs = null;//SQLServer数据库连接Connection mssql_conn = null;Statement mssql_stmt = null;ResultSet mssql_rs = null;//MySQL数据库连接Connection mysql_conn = null;Statement mysql_stmt = null;ResultSet mysql_rs = null;try {//Oracle驱动Class.forName("oracle.jdbc.driver.OracleDriver");oracle_conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.215:1521:orcl", "username","password");oracle_stmt = oracle_conn.createStatement();//SqlServer驱动Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");mssql_conn = DriverManager.getConnection("jdbc:sqlserver://192.168.0.213:1433;DatabaseName=VIS","username", "password");mssql_stmt = mssql_conn.createStatement();mssql_rs = mssql_stmt.executeQuery("select * from VideoBaseInfo");//MySQL驱动Class.forName("com.mysql.jdbc.Driver");mysql_conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","username", "password");mysql_stmt = mssql_conn.createStatement();mysql_rs = mssql_stmt.executeQuery("select * from VideoBaseInfo");while (mssql_rs.next()) {System.out.println("正在插入VideoId：" + mssql_rs.getInt("VideoId")+ "的记录...");oracle_stmt.executeUpdate("insert into VIDEO_BASEINFO values("+ mssql_rs.getInt("VideoId") + ",'"+ mssql_rs.getString("VideoName") + "','"+ mssql_rs.getString("VideoVersion") + "',"+ mssql_rs.getInt("VideoMp4Items") + ","+ mssql_rs.getInt("VideoRmvbItems") + ",'"+ mssql_rs.getString("VideoAliasName") + "','"+ mssql_rs.getString("VideoAge") + "'" + ")");}} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();} finally {try {if (oracle_rs != null) {oracle_rs.close();oracle_rs = null;}if (oracle_stmt != null) {oracle_stmt.close();oracle_stmt = null;}if (oracle_conn != null) {oracle_conn.close();oracle_conn = null;}if (mssql_rs != null) {mssql_rs.close();mssql_rs = null;}if (mssql_stmt != null) {mssql_stmt.close();mssql_stmt = null;}if (mssql_conn != null) {mssql_conn.close();mssql_conn = null;}} catch (SQLException e) {e.printStackTrace();}}}}