- 浏览: 603930 次
- 来自: 信阳
文章分类
最新评论
-
贝塔ZQ:
导出数据到excel文档中,可以使用pageoffice插件实 ...
Java POI 数据导出到Excel 2010 -
熊佳佳:
key是需要向支付宝购买额度的
支付宝即时到帐接口调试入口页面 -
zhuzuofei:
你好,你代码中提供的pid,key好像是无效的...
支付宝即时到帐接口调试入口页面 -
xingxing:
光有图没有解决方案......
centOS setup 命令 设置网络参数 -
atgoingguoat:
...
Android:简单的图片浏览器
简单查询 打印结果
import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; public class TextMysql { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stubr Connection connection = null; PreparedStatement ps = null; ResultSet rs = null; try { Class.forName("com.mysql.jdbc.Driver"); // connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/bookshop","root", // "admin"); connection = DriverManager.getConnection( "jdbc:mysql://localhost/bookshop", "root", "admin"); ps = connection.prepareStatement("select * from t_user"); rs = ps.executeQuery(); while (rs.next()) { System.out.println(rs.getString(1) + "\t" + rs.getString(2)); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } }
import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class JDBCDemo { public static void main(String[] args) throws SQLException{ // TODO Auto-generated method stub Connection conn = null; Statement statement = null; ResultSet resultSet = null; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); conn = DriverManager.getConnection( "jdbc:sqlserver://localhost:1433;database=demodb", "admin", "admin"); statement = conn.createStatement(); resultSet = statement .executeQuery("select name,password from t_user"); while (resultSet.next()) { String name = resultSet.getString("name"); String password = resultSet.getString("password"); System.out.println(name + " " + password); } } catch (Exception e) { e.printStackTrace(); } finally { if (resultSet != null) { resultSet.close(); } if (statement != null) { statement.close(); } if (conn != null) { conn.close(); } } } }
import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class ConnectionSQLServer { public static void main(String[] args) { ResultSet resultSet = null; Statement stmt = null; Connection conn = null; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); String url = "jdbc:sqlserver://localhost:1433;database=demodb"; String name = "admin"; String pass = "admin"; String sqlStr = "select name,password from t_user"; conn = DriverManager.getConnection(url, name, pass); stmt = conn.createStatement(); resultSet = stmt.executeQuery(sqlStr); while (resultSet.next()) { String str1 = resultSet.getString(1); String str2 = resultSet.getString(2); System.out.println(str1 + " " + str2); } } catch (ClassNotFoundException ce) { ce.printStackTrace(); } catch (SQLException se) { se.printStackTrace(); } finally { try { if (resultSet != null) { resultSet.close(); } if (stmt != null) { stmt.close(); } if (conn != null) { conn.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } }
import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class ConnectionOracle { public static void main(String[] args) { try { Class.forName("oracle.jdbc.OracleDriver"); String url = "jdbc:oracle:thin:@127.0.0.1:1521:king11g"; String name = "programmer"; String pass = "password"; String sqlStr = "select username,email from o_user"; Connection conn = DriverManager.getConnection(url, name, pass); Statement stmt = conn.createStatement(); ResultSet resultSet = stmt.executeQuery(sqlStr); while (resultSet.next()) { String str1 = resultSet.getString(1); String str2 = resultSet.getString(2); System.out.println(str1 + " " + str2); } if (resultSet != null) { resultSet.close(); } if (stmt != null) { stmt.close(); } if (conn != null) { conn.close(); } } catch (SQLException se) { se.printStackTrace(); } catch (ClassNotFoundException ce) { ce.printStackTrace(); } } }
- sqljdbc2008.jar (569.6 KB)
- 下载次数: 6
- mysql-connector-java-5.1.25.zip (3.8 MB)
- 下载次数: 4
- ojdbc6_11.2.0.1.0.jar (2.6 MB)
- 下载次数: 3
- ojdbc14_10.2.0.1.jar (1.5 MB)
- 下载次数: 2
- sqljdbc_4.0.2206.100_chs.rar (3.9 MB)
- 下载次数: 5
发表评论
-
数据源
2017-04-08 15:08 279package com.demo.dao.utils; ... -
MySQL系统时间
2016-06-24 16:20 456select current_date,now(),sysd ... -
Cent OS 7 Linux下5.6.31 MySQL Community Server (GPL)添加用户
2016-06-06 09:30 475[root@localhost xiongjiajia]# ... -
DbVisualizer 9.2.15
2016-06-04 17:25 1540DbVisualizer 9.2.15 Linux 注册失 ... -
MongoDB 安装
2016-06-04 08:59 306bash-4.2$ su密码:[root@dbserver l ... -
CentOS 7 Linux 安装MySQL
2016-06-03 16:15 922http://repo.mysql.com/ [r ... -
mongodb-win32-x86_64-2008plus-ssl-3.2.0-signed Hello World
2016-05-23 07:54 633Windows PowerShell版权所有 (C ... -
Oracle Enterprise Manager Cloud Control 12c
2015-07-20 16:10 612http://www.oracle.com/technetwo ... -
oracle 存储过程建表
2014-07-31 18:38 585create or replace procedure pro ... -
Oracle plsql 参考文档
2014-07-09 21:01 664Oracle plsql 参考文档 -
Oracle创建表 create
2014-07-08 20:53 584drop table stu;drop table cla ... -
Oracle select 语句 案例大全
2014-07-08 20:39 579select * from emp;select * fr ... -
Oracle salplus 导出导入数据
2014-03-12 16:00 584... -
Oracle select 语句
2014-03-12 14:59 582select * from emp;select * fr ... -
快速启动关闭MySQL服务的批处理代码
2013-12-23 15:54 288@echo off for /f "skip=3 ... -
PowerDesigner反向工程
2013-12-05 17:20 636... -
PowerDesigner连MySQL
2013-12-05 12:01 608http://dev.mysql.com/downloads ... -
SQL server 2008 安装
2013-10-25 15:15 579只选用以下功能就可以完成测试和学习的功能了 ... -
mysql 改列名
2013-09-25 17:40 708alter table 表名 change 旧列名 新列名 列 ... -
解决MySQL中文乱码
2013-09-23 17:31 370查看编码 注意:使用该命令重启MySQL后失效 需 ...
相关推荐
JDBC Driver(内附MS SQL Server、Oracle、MySQL的驱动)帮助你连接数据库
Oracle、MySQL、SQL Server 2000调用JDBC驱动的方法
Mysql+Oracle+SqlServer+Access+derby jdbc驱动包
ms sql+mysql+oracle 的 jdbc 驱动,内含链接字符串。
为了方便学习jdbc,我收集了jdbc连接三大数据库的connector包,其中包括mysql5.1.3,mysql5.1.6,Oracle完整包,Microsoft JDBC Driver for SQL Server6.0完整包,对于连接mysql,Oracle,sqlserver三大数据库的jar...
里面整理了常用数据库的驱动包 sqlServer mysql Oracle.并有三个baseDao,使用jdbc的方式连接数据库。并封装了常用的增删查改的方法。 代码示例 private static final String driver="com.mysql.jdbc.Driver"; //...
驱动类的名字:oracle.jdbc.driver.OracleDriver JDBC URL:jdbc:oracle:thin:@dbip:port:databasename 说明:驱动程序包名有可能会变 JDBC URL中各个部分含义如下: dbip –为数据库服务器的IP地址,如果是本地可写...
sql_json.sources.sql_source.driverclass= oracle.jdbc.driver.OracleDriver sql_json.sources.sql_source.filename = sqlSource.status sql_json.sources.sql_source.customquery = SELECT INTID,ID_NO FROM TEST....
请选出微软公司提供的连接SQL Server 2000的JDBC驱动程序()。 A. oracle.jdbc.driver.OracleDriver B. sun.jdbc.odbc.JdbcOdbcDriver C. com.microsoft.jdbc.sqlserver.SQLServerDriver D. ...
JDBC连接MySQL数据库 import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class JDBCTest { public static void main(String[] args) { String driverName=...
JDBC Driver 包括sql oracle MySQL
使用jdbc.sqlserver.SQLServerDriver连接数据库主要语句格式如下: Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); java.sql.Connection conn = java.sql.DriverManager.getConnection(...
kettle 连接mysql oracle 驱动包kettle报错Driver class’sun.jdbc.odbc.JdbcOdbcDriver’ could not be found,make sure the sun.jdbc.odbc.JdbcOdbcDriver 具体参考...
Oracle的URL 规则 驱动:oracle.jdbc.driver.OracleDriver URL:jdbc:oracle:thin:@machine_name:port:dbname 注1:machine_name:数据库所在的机器的名称; 注2:port:端口号,默认是1521 示例 Class.forName...
oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@hostname:1521:<SID> Postgresql org.postgresql.Driver jdbc:postgresql://localhost/soft Apache Derby/Java DB org.apache.derby.jdbc.ClientDriver jdbc...
4种数据库驱动,jdbc dirvrer,mysql,oracle,sql server 2005,sqlserver 2000 打包
mysql数据库/sqlserver数据库/oracle数据库/sqlserver数据库(JTDS)驱动总结 例如mysql数据库: driverClass=com.mysql.jdbc.Driver url=jdbc:mysql://localhost:3306/BookDB?useUnicode=true&characterEncoding=...
包内有MySQL,Oracle,PostgreSQL,SQL_Server2000, SQL_Server2008的JDBC驱动
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); //Sql Server7.0/2000 数据库 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); //DB2 数据库 Class.froName(...