使用JDBC调用存储过程

最新推荐文章于 2022-07-09 16:30:58 发布

sindy2snow

最新推荐文章于 2022-07-09 16:30:58 发布

阅读量403

点赞数

CC 4.0 BY-SA版权

分类专栏： Java Core 文章标签： JDBC Java 存储过程

本文链接：https://blog.youkuaiyun.com/sindy2snow/article/details/8910562

Java Core 专栏收录该内容

2 篇文章

订阅专栏

	public static List<ColumnInfo> queryColumnInfosByProcedure(String tableName) {
		Connection conn = DBUtil.getConnection();
		List<ColumnInfo> columnInfos = new ArrayList<>();
		ResultSet rs = null;
		CallableStatement procedure = null;
		try {
			 procedure = conn
					.prepareCall("{?=call p_create_columns(?)}");
			procedure.registerOutParameter(1, Types.OTHER);
			procedure.setString(2, tableName);
			 rs = procedure.executeQuery();
			while (rs.next()) {
				ColumnInfo columnInfo = new ColumnInfo();
				columnInfo.setColumnName(rs.getString("columnname"));
				columnInfo.setDataType(rs.getString("datatype"));
				columnInfo.setLength(rs.getInt("length"));
				columnInfo.setPk(rs.getBoolean("pk"));
				columnInfo.setAllowNull(rs.getBoolean("allowNull"));
				columnInfo.setComment(rs.getString("comment"));
				columnInfos.add(columnInfo);
			}
			for (ColumnInfo tableInfo : columnInfos) {
				System.out.println(tableInfo);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				rs.close();
				procedure.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return columnInfos;
	}