java,
分享于 点击 6285 次 点评:142
java,
public static void main(String[] args) {
Connection connection = DBConnection.getConn();
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
ParameterMetaData parameterMetaData = null;
int parameterCount ;
try {
String sql = "delete from person where name = ? and age= ?";
preparedStatement= connection.prepareStatement(sql);
parameterMetaData =preparedStatement.getParameterMetaData();
parameterCount = parameterMetaData.getParameterCount();
System.out.println("上面的SQL语句中共有"+parameterCount+"个参数");
for(int i=1;i<=parameterCount;i++){
System.out.println("第"+i+"个参数类型为 "+parameterMetaData.getParameterTypeName(i));
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
DBConnection.close(connection, preparedStatement, resultSet);
}
}
相关文章
- 暂无相关文章
用户点评