一、编写存无参数储过程
USE [MEP]
GO
/****** Object: StoredProcedure [dbo].[check_user_info] Script Date: 2019/3/16 11:13:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[check_user_info]
as
begin
select *from medi_classes;
select *from medicine_type;
select *from user_info;
end
二、测试调用
USE mep;
SELECT *FROM user_info;
begin
declare @o varchar;
-- exec loginCheck_Procedure 'admin',' 1', o;
exec check_user_info;
end
三、调用
package sqlConnect;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLType;
import org.junit.Test;
public class JavaProcedure {
@SuppressWarnings("unused")
@Test
public void exeProcedure() {
boolean bl = false;
ResultSet rs = null;
Connection con = null;// new Connection();
CallableStatement cstm=null;
con=JdbcMsqlConnection.getMSSQLConnection();
///
try{
if(con!=null){
System.out.println("正常连接数据库!");
//String strSql = "{CALL loginCheck_Procedure('admin',&