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

最新推荐文章于 2021-04-15 04:18:42 发布

帅明

最新推荐文章于 2021-04-15 04:18:42 发布

阅读量633

点赞数

分类专栏： oracle数据库文章标签： oracle sqlserver mysql 数据库 jdbc

本文链接：https://blog.csdn.net/zz87250976/article/details/32218941

版权

oracle数据库专栏收录该内容

5 篇文章 0 订阅

订阅专栏

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();
			}
		}
	}

}