大叔经验分享(94)jdbc连接mysql、sqlserver、oracle
2023-09-14 09:00:07 时间
Mysql
driver下载:https://mvnrepository.com/artifact/mysql/mysql-connector-java
import java.sql.*; public class SqlServerTest { public static void main(String []args) { String driverName="com.mysql.jdbc.Driver"; String dbURL="jdbc:mysql://$ip:3306/$db"; String userName="$user"; String userPwd="$password"; try { Class.forName(driverName); Connection dbConn=DriverManager.getConnection(dbURL,userName,userPwd); Statement st = dbConn.createStatement(); ResultSet rs = st.executeQuery("select * from user"); while (rs.next()) { System.out.println(rs.getString(1)); } System.out.println("success!"); } catch(Exception e) { e.printStackTrace(); System.out.print("fail!"); } } }
SqlServer
driver下载:https://mvnrepository.com/artifact/com.microsoft.sqlserver/sqljdbc4/4.0
import java.sql.*; public class SqlServerTest { public static void main(String []args) { String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver"; String dbURL="jdbc:sqlserver://$ip:1433;DatabaseName=$db"; String userName="$user"; String userPwd="$password"; try { Class.forName(driverName); Connection dbConn=DriverManager.getConnection(dbURL,userName,userPwd); Statement st = dbConn.createStatement(); ResultSet rs = st.executeQuery("select * from sysobjects where xtype='U'"); while (rs.next()) { System.out.println(rs.getString(1)); } System.out.println("success!"); } catch(Exception e) { e.printStackTrace(); System.out.print("fail!"); } } }
Oracle
driver下载:https://www.oracle.com/database/technologies/jdbc-drivers-12c-downloads.html
import java.sql.*; public class SqlServerTest { public static void main(String []args) { String driverName="oracle.jdbc.driver.OracleDriver"; String dbURL="jdbc:oracle:thin:@//$ip:1521/$db"; String userName="$user"; String userPwd="$password"; try { Class.forName(driverName); Connection dbConn=DriverManager.getConnection(dbURL,userName,userPwd); Statement st = dbConn.createStatement(); ResultSet rs = st.executeQuery("select * from all_tab_comments"); while (rs.next()) { System.out.println(rs.getString(1)); } System.out.println("success!"); } catch(Exception e) { e.printStackTrace(); System.out.print("fail!"); } } }
相关文章
- mysql语句和sql语句的区别_oracle和sqlserver的语法区别
- to mysql桥梁建设:从Oracle到MySQL的迁移之路(链接器oracle)
- 转换MySQL数据库到Oracle系统(mysql转oracle)
- Oracle收购Mysql:开启新时代(oracle收购mysql)
- MySQL连接SQL Server:实现完美同步(mysql连接sqlserver)
- MySQL:实用技巧与用户指南(mysql的用户手册)
- 查看MySQL被Oracle锁定的表(oracle查看被锁表)
- mysql实力比拼:Oracle 和 MySQL 的比较(oracle对比)
- 比较Oracle数据库与MySQL的特点(oracle数据库和mysql)
- MySQL首次登陆密码设置(mysql第一次密码设置)
- 如何提高MySQL并发写入性能?(mysql并发写入性能)
- MySQL查看Table的简单步骤(mysql查看table)
- MySQL正则表达式实现提取(mysql 正则 提取)
- 比较Oracle和MySQL:异同之处(oracle和mysql区别)
- 数据库中的MySQL 理解Mysql数据库的重要性(MySql中mysql)
- MySQL中的INT数据类型默认值(mysql中int默认值)
- MySQL和Oracle技术的比较与分析(mysql,oracle)
- 64位MySQL驱动程序轻松下载(64位mysql驱动下载)
- MySQL转换Oracle实现数据库跨平台迁移(hsql转换oracle)
- MySQL数据库的执行顺序分析(mysql z执行顺序)
- 在哪里下载MySQL找到正确的下载渠道(mysql下载到哪里)