读书人

PreparedStatement跟Statement

发布时间: 2012-10-30 16:13:36 作者: rapoo

PreparedStatement和Statement
PreparedStatement用法:

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();}}}

读书人网 >编程

热点推荐