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!");
}
}
}

最新文章

  1. Unity3d uGUI适配
  2. SQL server 常用语句
  3. Python中setuptools做什么用的?
  4. 你真的了解UIWindow吗?
  5. js混淆工具
  6. position:sticky用法
  7. linux下查看串口信息
  8. JY05-JavsScript-JS基础01
  9. JavaScript的this详解
  10. 兼容不同浏览器的 CSS Hack 写法
  11. javascript页面间传递参数
  12. 快速配置vs2012+opencv
  13. java.sql.SQLException:Invalid value for getInt()-'zhangsan'
  14. python 中 dlib库的安装
  15. MySQL-ERROR 2003
  16. linux下目录的作用
  17. Asp.net:上传文件超过了最大请求长度
  18. c++ vector详解
  19. windows7环境下使用pip安装MySQLdb
  20. c# 多线程调用窗体上的控件 示例

热门文章

  1. @Deprecated注解
  2. Yarn概述——FAST, RELIABLE, AND SECURE DEPENDENCY MANAGEMENT
  3. npm教程、脚手架
  4. NodeJs本地搭建服务器,模拟接口请求,获取json数据
  5. migrate设置
  6. iOS笔试题04
  7. iOS-iphone网络编程总结
  8. Efcore迁移
  9. 《Fluid Engine Development》 学习笔记4-预测校正不可压缩SPH-PCISPH
  10. 转 Linux平台卸载MySQL总结