使用临时表拼接两张表数据,并查询结果集,存储过程代码如下:
ALTER PROCEDURE dead_proc AS
BEGIN
SELECT * INTO #deadTemp FROM deadNum;
INSERT into #deadTemp SELECT * FROM deadNum2;
SELECT * FROM #deadTemp ;
END;
java调用该存储过程,代码如下(略去数据库连接部分):
conn = ConnUtils.getConnection();
statement = conn.prepareCall("{call dead_proc}");
ResultSet resultSet=statement.executeQuery();
int ID,num;
Date time;
System.out.println("数据库内容:");
while (resultSet!=null&&resultSet.next()){
ID=resultSet.getInt("ID");
num=resultSet.getInt("num");
time=resultSet.getDate("time");
System.out.println(ID+" "+num+" "+time);
}