procedemo7.java

在 java中调用 sqlserver存储过程

//G:在JAVA中创建存储过程  并且在JAVA中直接调用
import java.sql.*;
public class ProceDemo7
{
	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;DataBase=Demo","sa","ok");
			Statement pstmt = con.createStatement();
			pstmt.executeUpdate("create procedure OOP as select * from student");
			CallableStatement cstmt = con.prepareCall("{call OOP}");
			ResultSet rs = cstmt.executeQuery();
			while(rs.next())
			{
				String name = cstmt.getString("stuName");
				String sex = cstmt.getString("stuSex");
				int age = cstmt.getInt("stuAge");
				String address = cstmt.getString("stuAddress");
				System.out.println ("-------------");
				System.out.println (name);
				System.out.println (sex);
				System.out.println (age);
				System.out.println (address);
				System.out.println ("-------------");
			}
	    }
	    catch (SQLException ex) {
	    	ex.printStackTrace();
	    }
	}
}