public class parameterMedaData {
public static void main(String[] args) {
String sql = "select * from user where id >?";
Object obj[] = new Object[]{3};
read(sql,obj);
}
static void read(String sql,Object obj[]){
Connection conn=null;
PreparedStatement ps =null;
ResultSet rs = null;
JDBCUtils utils =JDBCUtils.getInstance();
try {
conn=utils.getConnection();
DatabaseMetaData dmd = conn.getMetaData();
System.out.println(dmd.getDatabaseProductName());
ps = conn.prepareStatement(sql);
ParameterMetaData pmd = ps.getParameterMetaData();
int count = pmd.getParameterCount();
for(int i=1;i<=count;i++){
ps.setObject(i, obj[i-1]);
}
rs = ps.executeQuery();
while(rs.next()){
System.out.print(rs.getObject("username"));
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}