PreparedStatement和Statement

最新推荐文章于 2024-08-12 14:46:04 发布

原创最新推荐文章于 2024-08-12 14:46:04 发布 · 90 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Java #DB2 #SQL #JDBC #IBM

JAVA 专栏收录该内容

332 篇文章

订阅专栏

本文提供了使用 Java 进行 SQL 数据库查询的两种方法：通过 Statement 和 PreparedStatement 类。示例展示了如何连接到 DB2 数据库并从名为 vote 的表中检索数据。

PreparedStatement用法：


package com.java.call.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class PrepareStatement {

	public static void main(String args[]){
		Connection conn=null;
		PreparedStatement ps=null;
		ResultSet rs=null;
		try{
			Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
			conn=DriverManager.getConnection("jdbc:db2://localhost:50000/express","acer","abin");
			String url="select * from vote";
			ps=conn.prepareStatement(url);
			rs=ps.executeQuery();
			while(rs.next()){
				System.out.println(rs.getString("id"));
				System.out.println(rs.getString("name"));
				System.out.println(rs.getString("num"));
			}

		}catch(Exception e){
			e.printStackTrace();
		}
	}

}

Statement用法：



package com.java.call.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class CallDb {
	public static void main(String args[]) {
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		try {
			Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
			conn = DriverManager.getConnection(
					"jdbc:db2://localhost:50000/express", "acer", "abin");
			stmt = conn.createStatement();
			rs = stmt.executeQuery("select * from vote");
			while (rs.next()) {
				System.out.println(rs.getString(1));
				System.out.println(rs.getString(2));
				System.out.println(rs.getString(3));
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

}