欢迎访问悦橙教程(wld5.com),关注java教程。悦橙教程  java问答|  每日更新
页面导航 : > > 文章正文

java,

来源: javaer 分享于  点击 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);
		}
	}
 

相关文章

    暂无相关文章
相关栏目:

用户点评