qiaolevip
- 浏览: 4856515 次
- 性别:
- 来自: 上海
-
文章分类
- 全部博客 (743)
- JAVA (44)
- JAVA 乔乐共享 (145)
- js (132)
- database (26)
- jQuery (46)
- velocity (16)
- Ubuntu (14)
- Grails (2)
- Groovy (6)
- xml (2)
- Spring (11)
- mysql (24)
- sqlserver (6)
- oracle (9)
- cmd (8)
- CSS (17)
- Linux (2)
- sqlite (4)
- php (11)
- json (2)
- laravel (2)
- html (3)
- 闲聊 (3)
- git (13)
- nodejs (25)
- angularjs (17)
- npm (8)
- bootstrap (4)
- mongodb (5)
- React (32)
- Crack (7)
- b (0)
- ES6 (2)
- webpack (3)
- Babel (1)
- Koa (1)
最新评论
-
taoshengyijiuzt：
感谢大佬！！！
JetBrains最新激活服务器（长期更新ing） -
masuweng：
激活码可以用
JetBrains最新激活服务器（长期更新ing） -
dusdong：
都失效了
JetBrains最新激活服务器（长期更新ing） -
追风筝的孩纸Zz：
dddddddddddddddd
js获取网页屏幕可见区域高度 -
自己811005：
88350bcf69dcfbda7f8a76a589d9054 ...
Js设置前端允许跨域请求后端API:Access-Control-Allow-Credentials
ConnectHSQLDB.java
ConnectMySQL.java
Connect MS SQL Server
Connect Oracle
Connect DB2
Connect Postgre
Connect ADS
Connect Derby
Connect Firebird
Connect H2
Connect SQLite
Connect SmallSQL
http://www.javaworkspace.com/donations.do
/**
* ConnectHSQLDB.java
*/
package com.javaworkspace.connecthsqldb;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* @author www.javaworkspace.com
*
*/
public class ConnectHSQLDB {
public static void main(String[] args) {
Connection connection = null;
ResultSet resultSet = null;
Statement statement = null;
try {
Class.forName("org.hsqldb.jdbcDriver");
connection = DriverManager.getConnection(
"jdbc:hsqldb:file:C:\\HyperSQLDB\\EMPLOYEEDB", "SA", "");
statement = connection.createStatement();
resultSet = statement
.executeQuery("SELECT EMPNAME FROM EMPLOYEEDETAILS");
while (resultSet.next()) {
System.out.println("EMPLOYEE NAME:"
+ resultSet.getString("EMPNAME"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
resultSet.close();
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
ConnectMySQL.java
/**
* ConnectMySQL.java
*/
package com.javaworkspace.connectmysql;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* @author www.javaworkspace.com
*
*/
public class ConnectMySQL {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/EMPLOYEE", "root", "root");
Statement statement = connection.createStatement();
ResultSet resultSet = statement
.executeQuery("SELECT EMPNAME FROM EMPLOYEEDETAILS");
while (resultSet.next()) {
System.out.println("EMPLOYEE NAME:"
+ resultSet.getString("EMPNAME"));
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
Connect MS SQL Server
/**
* ConnectMSSQL.java
*/
package com.javaworkspace.connectmssql;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* @author www.javaworkspace.com
*
*/
public class ConnectMSSQL {
public static void main(String[] args) {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection connection = DriverManager
.getConnection(
"jdbc:sqlserver://localhost:1433;databaseName=EMPLOYEE;selectMethod=cursor",
"username", "password");
System.out.println("DATABASE NAME IS:"
+ connection.getMetaData().getDatabaseProductName());
Statement statement = connection.createStatement();
ResultSet resultSet = statement
.executeQuery("SELECT EMPNAME FROM EMPLOYEEDETAILS");
while (resultSet.next()) {
System.out.println("EMPLOYEE NAME:"
+ resultSet.getString("EMPNAME"));
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
// Connect using JDTS driver
/**
* ConnectMSSQL.java
*/
package com.javaworkspace.connectmssql;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* @author www.javaworkspace.com
*
*/
public class ConnectMSSQL {
public static void main(String[] args) {
try {
Class.forName("net.sourceforge.jtds.jdbc.Driver");
Connection connection = DriverManager
.getConnection(
"jdbc:jtds:sqlserver://localhost:1433;databaseName=EMPLOYEE;sendStringParametersAsUnicode=false",
"username", "password");
System.out.println("DATABASE NAME IS:"
+ connection.getMetaData().getDatabaseProductName());
Statement statement = connection.createStatement();
ResultSet resultSet = statement
.executeQuery("SELECT EMPNAME FROM EMPLOYEEDETAILS");
while (resultSet.next()) {
System.out.println("EMPLOYEE NAME:"
+ resultSet.getString("EMPNAME"));
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
Connect Oracle
/**
* ConnectOracle.java
*/
package com.javaworkspace.connectoracle;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* @author www.javaworkspace.com
*
*/
public class ConnectOracle {
public static void main(String[] args) {
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
System.out.println("Connecting to the database...");
Connection connection = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");
Statement statement = connection.createStatement();
ResultSet resultset = statement.executeQuery("select 'Connected' from dual");
resultset.next();
String s = resultset.getString(1);
System.out.println(s);
statement.close();
connection.close();
} catch (Exception e) {
System.out.println("The exception raised is:" + e);
}
}
}
Connect DB2
/**
* ConnectDB2.java
*/
package com.javaworkspace.connectdb2;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* @author www.javaworkspace.com
*
*/
public class ConnectDB2 {
public static void main(String[] args) {
Connection connection = null;
ResultSet resultSet = null;
Statement statement = null;
try {
Class.forName("com.ibm.db2.jcc.DB2Driver");
connection = DriverManager.getConnection(
"jdbc:db2://localhost:5021/EMPLOYEE", "username",
"password");
statement = connection.createStatement();
resultSet = statement
.executeQuery("SELECT EMPNAME FROM EMPLOYEEDETAILS");
while (resultSet.next()) {
System.out.println("EMPLOYEE NAME:"
+ resultSet.getString("EMPNAME"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
resultSet.close();
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
Connect Postgre
/**
* ConnectPostgre.java
*/
package com.javaworkspace.connectpostgre;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* @author www.javaworkspace.com
*
*/
public class ConnectPostgre {
public static void main(String[] args) {
Connection connection = null;
ResultSet resultSet = null;
Statement statement = null;
try {
Class.forName("org.postgresql.Driver");
connection = DriverManager.getConnection(
"jdbc:postgresql://localhost:5432/EMPLOYEE", "postgres",
"password");
statement = connection.createStatement();
resultSet = statement
.executeQuery("SELECT EMPNAME FROM EMPLOYEEDETAILS");
while (resultSet.next()) {
System.out.println("EMPLOYEE NAME:"
+ resultSet.getString("EMPNAME"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
resultSet.close();
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
Connect ADS
/**
* ConnectADS.java
*/
package com.javaworkspace.connectads;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* @author www.javaworkspace.com
*
*/
public class ConnectADS {
public static void main(String[] args) {
Connection connection = null;
ResultSet resultSet = null;
Statement statement = null;
try {
Class.forName("com.extendedsystems.jdbc.advantage.ADSDriver");
connection = DriverManager.getConnection(
"jdbc:extendedsystems:advantage://localhost:6262;catalog=C:\\yourDatbase\\data;TableType=cdx;LockType=proprietary", "AdsSys", "no");
statement = connection.createStatement();
resultSet = statement
.executeQuery("SELECT EMPNAME FROM EMPLOYEEDETAILS");
while (resultSet.next()) {
System.out.println("EMPLOYEE NAME:"
+ resultSet.getString("EMPNAME"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
resultSet.close();
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
Connect Derby
/**
* ConnectDerby.java
*/
package com.javaworkspace.connectderby;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* @author www.javaworkspace.com
*
*/
public class ConnectDerby {
public static void main(String[] args) {
Connection connection = null;
ResultSet resultSet = null;
Statement statement = null;
try {
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
connection = DriverManager
.getConnection("jdbc:derby:C:/DerbyDatabase/EMPLOYEE");
statement = connection.createStatement();
resultSet = statement
.executeQuery("SELECT EMPNAME FROM EMPLOYEEDETAILS");
while (resultSet.next()) {
System.out.println("EMPLOYEE NAME:"
+ resultSet.getString("EMPNAME"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
resultSet.close();
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
Connect Firebird
/*
* ConnectFirebirdDB.java
*/
package com.javaworkspace.connectfirebirddb;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* @author www.javaworkspace.com
*
*/
public class ConnectFirebirdDB {
public static void main(String[] args) {
Connection connection = null;
ResultSet resultSet = null;
Statement statement = null;
try {
Class.forName("org.firebirdsql.jdbc.FBDriver");
connection = DriverManager
.getConnection(
"jdbc:firebirdsql://localhost:3050/C:/FirebirdDB/EMPLOYEEDB.fdb",
"sysdba", "masterkey");
statement = connection.createStatement();
resultSet = statement
.executeQuery("SELECT EMPNAME FROM EMPLOYEEDETAILS");
while (resultSet.next()) {
System.out.println("EMPLOYEE NAME:"
+ resultSet.getString("EMPNAME"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
resultSet.close();
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
Connect H2
/*
* ConnectH2DB.java
*/
package com.javaworkspace.connecth2db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* @author www.javaworkspace.com
*
*/
public class ConnectH2DB {
public static void main(String[] args) {
Connection connection = null;
ResultSet resultSet = null;
Statement statement = null;
try {
Class.forName("org.h2.Driver");
connection = DriverManager.getConnection(
"jdbc:h2:C:\\H2DB\\database\\EMPLOYEEDB", "sa", "");
statement = connection.createStatement();
resultSet = statement
.executeQuery("SELECT EMPNAME FROM EMPLOYEEDETAILS");
while (resultSet.next()) {
System.out.println("EMPLOYEE NAME:"
+ resultSet.getString("EMPNAME"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
resultSet.close();
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
Connect SQLite
/**
* ConnectSQLite.java
*/
package com.javaworkspace.connectsqlite;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* @author www.javaworkspace.com
*
*/
public class ConnectSQLite {
public static void main(String[] args) {
Connection connection = null;
ResultSet resultSet = null;
Statement statement = null;
try {
Class.forName("org.sqlite.JDBC");
connection = DriverManager
.getConnection("jdbc:sqlite:C:\\SQLite\\EMPLOYEE.db");
statement = connection.createStatement();
resultSet = statement
.executeQuery("SELECT EMPNAME FROM EMPLOYEEDETAILS");
while (resultSet.next()) {
System.out.println("EMPLOYEE NAME:"
+ resultSet.getString("EMPNAME"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
resultSet.close();
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
Connect SmallSQL
/**
* ConnectSmallSQL.java
*/
package com.javaworkspace.connectsmallsql;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* @author www.javaworkspace.com
*
*/
public class ConnectSmallSQL {
public static void main(String[] args) {
Connection connection = null;
ResultSet resultSet = null;
Statement statement = null;
try {
Class.forName("smallsql.database.SSDriver");
connection = DriverManager
.getConnection("jdbc:smallsql:C:\\SmallSQL\\database\\EMPLOYEEDB");
statement = connection.createStatement();
resultSet = statement
.executeQuery("SELECT EMPNAME FROM EMPLOYEEDETAILS");
while (resultSet.next()) {
System.out.println("EMPLOYEE NAME:"
+ resultSet.getString("EMPNAME"));
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
resultSet.close();
statement.close();
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
http://www.javaworkspace.com/donations.do
分享到：
发表评论
-
MySQL插入emoji手机表情报错解决方案
2018-01-25 23:43 2863报错原因： ps：为什么没有内容呢，由于iteye插入e ... -
nodejs同步操作mysql
2014-10-29 15:23 5439// db-util.js var mysql = re ... -
Pl/sql 连接 Oracle ‘SQL*Net not properly installed OracleHomeKey:SOFTWARE\ORACLE’
2014-09-17 18:17 11284安装好Oracle和pl/sql后，用pl/sql连接Or ... -
[Warning] TIMESTAMP with implicit DEFAULT value is depreca
2014-05-02 09:50 24868C:\Users\Happy>mysqld --co ... -
wampserver IP访问被禁止解除
2014-04-29 16:43 1857// 点击Apache下面的httpd.conf 修改 ... -
php读取mysql中文乱码解决
2014-04-29 14:54 4487<!DOCTYPE> <html> ... -
mysql查询或更新单双数字的内容
2013-11-19 17:27 991select * from tbl_name where ... -
mysql复制表结构或者表数据，可备份数据
2013-11-19 17:26 1795If the destination table alrea ... -
sql查询最后一条自增长的记录
2013-11-13 17:21 1184mysql> select * from messag ... -
mysql安装服务绿色版
2013-10-04 16:03 9961）首先安装mysql http://qiaolevip ... -
安装绿色版mysql-5.6.14
2013-10-04 16:00 35111）下载www.mysql.com mysql安装程序，my ... -
mysql注册服务或移除服务
2013-07-26 15:01 1264--注册系统服务 mysqld --install mys ... -
DB2，Mysql，Sqlserver，oracle分页算法，分页语句
2013-03-07 20:43 1615Mysql limit = ((feeds.getPage ... -
DB2 分页，row_number分页
2013-03-07 16:59 1919select * from (select ROW_N ... -
mysql查询每月不重复的数据
2012-10-15 11:14 4754mysql> select * from produ ... -
mysql统计多表交叉组合总数
2012-10-11 11:33 5304>mysql -h localhost -u root ... -
DB2获取当前时间
2012-09-20 14:05 12188SELECT current date FROM sysi ... -
DB2 查看表结构，DB2查看所用表
2012-09-20 09:58 5063查看所用表（注：条件内容需要大写） select * fr ... -
hsql创建自动增长列并授权数据库
2012-08-26 10:09 1580ID INTEGER GENERATED BY DEFAU ... -
Mysql各种报表查询含实例，日报，周报，月报，时间差自动计算
2012-04-12 11:28 7505public List<IReport> re ...
相关推荐
DBeaver是一款基于Java开发的通用数据库管理工具和SQL客户端，支持MySQL、PostgreSQL、Oracle、DB2、MSSQL、Sybase、Mimer、HSQLDB、Derby以及其他兼容JDBC的数据库。DBeaver提供了图形界面用来查看数据库结构、执行...
jar使用说明： 驱动 对应数据库 --------------------------------------...mysql-connector-java-5.1.6-bin.jar Mysql数据库 ---------------------------------------------------------- sybase.jar Sybase数据库
MySQL、Oracle、PostgreSQL、IBM DB2、Microsoft SQL Server、clickhouse、Sybase、ODBC、Java DB (Derby)、Firebird (Interbase)、HSQLDB、SQLite、Mimer、H2、IBM Informix、SAP MAX DB、Cache、Ingres、Linter、...
MySQL、Oracle、PostgreSQL、IBM DB2、Microsoft SQL Server、clickhouse、Sybase、ODBC、Java DB (Derby)、Firebird (Interbase)、HSQLDB、SQLite、Mimer、H2、IBM Informix、SAP MAX DB、Cache、Ingres、Linter、...
MySQL、Oracle、PostgreSQL、IBM DB2、Microsoft SQL Server、clickhouse、Sybase、ODBC、Java DB (Derby)、Firebird (Interbase)、HSQLDB、SQLite、Mimer、H2、IBM Informix、SAP MAX DB、Cache、Ingres、Linter、...
MySQL、Oracle、PostgreSQL、IBM DB2、Microsoft SQL Server、clickhouse、Sybase、ODBC、Java DB (Derby)、Firebird (Interbase)、HSQLDB、SQLite、Mimer、H2、IBM Informix、SAP MAX DB、Cache、Ingres、Linter、...
数据库链接工具dbeaver-ce-7.0.0-x86_64-setup，兼容大部分数据库，使用简单，支持 MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, Derby, 以及其他兼容 JDBC 的数据库。 帮助你免除安装各种...
dbeaver是免费和开源（GPL）为开发人员和数据库管理员通用数据库工具, MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, Derby等多种数据库,它支持任何具有一个JDBC驱动程序数据库。它可以处理任何的...
如果你要连接数据库，需要有该数据库的JDBC驱动 DBMetadata-generator 利用数据库元数据，根据模板生成一些内容。 该项目目前只提供了一个BeetlTemplate，只有两个静态方法，这只是一个简单的例子 DBMetadata-swing ...
MySQL、Oracle、PostgreSQL、 IBM DB2、Microsoft SQL Server、 Sybase、ODBC、Java DB (Derby)、 Firebird (Interbase)、HSQLDB、 SQLite、Mimer、H2、IBM Informix、SAP MAX DB、 Cache、Ingres、Linter、Teradata...
本工具可用于数据库表和字段的查询，以及数据库元数据的进一步使用。 目前支持以下数据库(都能正确获取注释信息): Oracle Mysql MariaDB SQLite Hsqldb PostgreSQL DB2 SqlServer(2005+) - 必须使用jtds驱动
MySQL、Oracle、PostgreSQL、IBM DB2、Microsoft SQL Server、Sybase、ODBC、Java DB (Derby)、Firebird (Interbase)、HSQLDB、SQLite、Mimer、H2、IBM Informix、SAP MAX DB、Cache、Ingres、Linter、Teradata和...
includes JDBC drivers for Cache, DB2, Derby, Firebird, H2, HSQLDB, Informix, JTDS (MS SQL and Sybase), SAP MaxDB, Mimer, Oracle, PostgreSQL, SQLite, MySQL, Ingres, Linter, Teradata, Vertica, Apache ...
支持MySQL、Postgres、Microsoft SQL Server、H2、Derby、HSQLDB、Sqllite且可以相对容易的扩展到其他数据库。 临时支持（Provisional support）DB2、Oracle、ODBC和Netezza。如果不支持你的数据库，联系作者。 ...
JDBC 驱动包合集 JAR包： Access cache db2 derby firebird hsqldb informix ingres jtds maxdb mssql mysql oracle postgresql sqlite
1、完全支持MySQL、Oracle、PostgreSQL、MSSQL、Access、IBM DB2、SQLite、Firebird、Sybase、SAP MaxDB、HSQLDB和Informix等多种数据库管理系统。 2、完全支持布尔型盲注、时间型盲注、基于错误信息的注入、联合...
DBeaver 是一个通用的数据库管理工具和 SQL 客户端，支持 MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, Derby, 以及其他兼容 JDBC 的数据库。DBeaver 提供一个图形界面用来查看数据库结构、执行...
目前支持下列数据库:IBM DB2 10.5Microsoft SQL Server 12.0 (2014)Oracle 11g R2PostgreSQL 9.3HSQLDB 2.3MySQL 5.6 / MariaDB 10.0SQLite 3.8OACC 兼容 JDK 1.7 (Java™ 7) 及以上版本。 标签：安全相关...
软件支持 MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, Derby, 以及其他兼容 JDBC 的数据库。值得一提的是软件会提供一个图形界面用来查看数据库结构、执行SQL查询和脚本，浏览和导出数据，处理...