procedemo6.java

来自「在 java中调用 sqlserver存储过程」· Java 代码 · 共 34 行

/**
 *--E:查询数据的存储过程(模糊查询)
create procedure FindCusts
@cust varchar(10)
as
select stuName from student where  stuName like '%'+@cust+'%' 

exec FindCusts'龙'
 **/
import java.sql.*;
public class ProceDemo6
{
	public static void main(String [] args)
	{
		try {
			DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
			Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DataBaseName=Demo","sa","ok");
			CallableStatement cstmt = con.prepareCall("{call FindCusts(?)}");
			cstmt.setString(1,"龙");
			ResultSet rs = cstmt.executeQuery();
			while(rs.next())
			{
				String name = rs.getString("stuName");
				System.out.println ("姓名为="+name);
			}
			rs.close();
			cstmt.close();
			con.close();
	    }
	    catch (SQLException ex) {
	    	ex.printStackTrace();
	    }
	}
}