java连接DB2检索一条记录的java代码
来源:互联网 发布:matlab 遍历二维矩阵 编辑:程序博客网 时间:2024/06/16 11:51
package com.dnb.globalaccess;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JdbcConnection {
/**
* @param args
* @throws ClassNotFoundException
* @throws SQLException
* @throws IllegalAccessException
* @throws InstantiationException
*/
public static void main(String[] args) throws ClassNotFoundException, SQLException, InstantiationException, IllegalAccessException {
String url = "jdbc:db2://172.16.77.31:50007/ND01";
String user = "it07";
String pwd = "111111";
String sql = "SELECT * FROM CORP_MST FETCH FIRST 1 ROWS ONLY";
// 1.建立与数据库的连接:
Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
Connection conn = DriverManager.getConnection(url, user, pwd);
// 2.准备SQL
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = (ResultSet) ps.executeQuery();
// 3.输出
while (((ResultSet) rs).next()) {
System.out.println(rs.getString(1));
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JdbcConnection {
/**
* @param args
* @throws ClassNotFoundException
* @throws SQLException
* @throws IllegalAccessException
* @throws InstantiationException
*/
public static void main(String[] args) throws ClassNotFoundException, SQLException, InstantiationException, IllegalAccessException {
String url = "jdbc:db2://172.16.77.31:50007/ND01";
String user = "it07";
String pwd = "111111";
String sql = "SELECT * FROM CORP_MST FETCH FIRST 1 ROWS ONLY";
// 1.建立与数据库的连接:
Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
Connection conn = DriverManager.getConnection(url, user, pwd);
// 2.准备SQL
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = (ResultSet) ps.executeQuery();
// 3.输出
while (((ResultSet) rs).next()) {
System.out.println(rs.getString(1));
}
}
}
- java连接DB2检索一条记录的java代码
- 检索一条记录
- Java连接DB2数据库
- JAVA 连接DB2
- Java连接DB2相关
- Java程序连接DB2
- java jdbc 连接db2
- java连接DB2
- JAVA连接DB2
- java连接DB2数据库
- java连接db2
- JAVA连接DB2
- Java连接DB2
- Java 连接 DB2的工具类
- JAVA连接DB2数据库的方法
- 数据库操作:java连接DB2实例代码演示
- java连接Oracle、Mysql、DB2、Sybase、Informix、PostgreSQL数据库代码
- 记录Java代码的执行时间
- Redmine学习
- 联想 V480c grub 启动硬盘安装 CentOS-6.3
- 字节对齐与sizeof
- Windows系统下,查看端口占用情况杀掉端口占用进程
- Android反编译
- java连接DB2检索一条记录的java代码
- http://config.mail.163.com/autofw/verify.do?c=FYxj9FW4mqhH1
- C#中String类方法汇总
- struts2 拦截器和spring AOP拦截器(security3)功能对比?
- 在android 2.3.x中修改actionbarsherlock的样式
- sbjson的解析
- Linux C编程--进程介绍7--综合应用实例
- oracle的常规应用
- Unity 网络通信