In Java, the method of calling a stored procedure (vii) is created, and the stored procedure is called directly in Java

VII. Create stored procedures in Java and call them directly in 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();

}
}