preparedquery.java

来自「J2EE指南」· Java 代码 · 共 23 行

import java.sql.*;
public class PreparedQuery{
	public static void main(String args[]){
		ResultSet result;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con;
			con=DriverManager.getConnection("jdbc:odbc:mydatabase","","");
			PreparedStatement stat=con.prepareStatement("select * from publishers where pub_id=?");
			stat.setString(1,"1622");
			result=stat.executeQuery();
		while(result.next())
		{
			System.out.println(result.getString(2));
		}
		}
		catch(Exception e)
		{
			System.out.println("Error"+ e);
		}
	}
}