可以使用pda.getParameterCount()来获得比较灵活的开发方法:
public class MetaDataTest {
public static void main(String[] args) throws SQLException {
Object[] params=new Object[]{"zhangsan",26,300,"1779234"};
Connection conn = ConnectionFactory.getInstance().getLocalConnection();
int money=0;
ResultSet rt=null;
PreparedStatement st=null;
//使用 DatabaseMetaData可以获得数据库的源信息
java.sql.DatabaseMetaData dma=conn.getMetaData();
System.out.println(dma.getDatabaseProductName());
System.out.println(dma.getDatabaseProductVersion());
String sql="select * from test_user where name =? and age=?, money=?";//示例而已
st=conn.prepareStatement(sql);
ParameterMetaData pda=st.getParameterMetaData();
int count= pda.getParameterCount();//得到的是占位符的个数
for(int i=0;i<count ;i++){
st.setObject(i+1, params[i]);
}
}
}