Statement s = connect.createStatement();
String CusID = "C002"; String sql = "SELECT * FROM customer WHERE CustomerID = '" + CusID + "' ";
ResultSet rec = s.executeQuery(sql);
while((rec!=null) && (rec.next())) { System.out.print(rec.getString("CustomerID")); }
package com.java.myapp; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.sql.Connection; import java.sql.DriverManager; public class MyClass { public static void main(String[] args) { Connection connect = null; Statement s = null; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); connect = DriverManager.getConnection("jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};" + "DBQ=C:\\java\\mydatabase.mdb;uid=;pwd=;"); s = connect.createStatement(); String CusID = "C002"; String sql = "SELECT * FROM customer WHERE CustomerID = '" + CusID + "' "; ResultSet rec = s.executeQuery(sql); while((rec!=null) && (rec.next())) { System.out.print(rec.getString("CustomerID")); System.out.print(" - "); System.out.print(rec.getString("Name")); System.out.print(" - "); System.out.print(rec.getString("Email")); System.out.print(" - "); System.out.print(rec.getString("CountryCode")); System.out.print(" - "); System.out.print(rec.getFloat("Budget")); System.out.print(" - "); System.out.print(rec.getFloat("Used")); System.out.println(""); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } try { s.close(); connect.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน Source Code 2.0 ของทีมงานไทยครีเอท