首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 开发语言 > 编程 >

PreparedStatement跟Statement

2012-10-30 
PreparedStatement和StatementPreparedStatement用法:package com.java.call.dbimport java.sql.Connecti

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

热点排行