七、在JAVA中创建存储过程 并且在JAVA中直接调用
import java.sql.*;public class ProcedureTest {public static void main(String args[]) throws Exception{//加载驱动DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());//获得连接Connection conn=DriverManager.getConnection("jdbc:odbc:mydata","sa","");Statement stmt=conn.createStatement();//在JAVA中创建存储过程stmt.executeUpdate("create procedure OOP as select * from 学生成绩表");CallableStatement c=conn.divpareCall("{call OOP}");ResultSet rs=c.executeQuery();while(rs.next()){String chinese=rs.getString("Chinese");System.out.println (chinese);}conn.close();}}
若不给自己设限,则人生中就没有限制你发挥的藩篱。