资源描述:
《使用存储过程的传出参数.docx》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、CREATETABLEstudent2(numbervarchar(6)primarykey,--学号namevarchar(8)notnullunique,--姓名passwordvarchar(6)notnull,--密码)GOINSERTstuVALUES('','黎明','')INSERTstuVALUES('','赵怡春','')INSERTstuVALUES('','张富平','')INSERTstuVALUES('','白丽','')INSERTstuVALUES('','牛玉德','')INSERTstuVALUES('','姚华',
2、'')INSERTstuVALUES('','李南','')GOCREATETABLEgrade(numbervarchar(6),--学号coursevarchar(20),--课程名称gradeint,--成绩CONSTRAINTPK_gradePRIMARYKEYCLUSTERED(number,course))GOINSERTINTOgradeVALUES('','C++',56);INSERTINTOgradeVALUES('','Java',90);INSERTINTOgradeVALUES('','Java',77);INSERTINT
3、OgradeVALUES('','英语',91);INSERTINTOgradeVALUES('','C++',76);INSERTINTOgradeVALUES('','C++',67);INSERTINTOgradeVALUES('','英语',78);INSERTINTOgradeVALUES('','C++',74);INSERTINTOgradeVALUES('','英语',86);INSERTINTOgradeVALUES('','Java',80);INSERTINTOgradeVALUES('','英语',90);GOCREATEPR
4、OCEDUREGetAverageGradeFromStuName@stuNamevarchar(8),@gradefloatoutputASSelect@grade=avg(grade)fromstudent2innerjoingradeonstudent2.number=grade.numberwherename=@stuNamepackagedatabasevisit;importjava.sql.CallableStatement;importjava.sql.Connection;importjava.sql.DriverManager;i
5、mportjava.sql.ResultSet;importjava.sql.ResultSetMetaData;importjava.sql.Types;importjavax.swing.JOptionPane;publicclassOutcomingParametersUsingTheStoredProcedure{/***@paramargs*/publicstaticvoidmain(String[]args){//TODOAuto-generatedmethodstubConnectioncon=null;CallableStatemen
6、tcstm=null;ResultSetrs=null;ResultSetMetaDatarsmd=null;Stringname=JOptionPane.showInputDialog("请输入学生姓名");try{//System.out.println(name);Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=te
7、st","sa","jocean");cstm=con.prepareCall("{callGetAverageGradeFromStuName(?,?)}");cstm.setString(1,name);cstm.registerOutParameter(2,Types.FLOAT);cstm.execute();System.out.println(name+"的平均成绩为:"+cstm.getString(2));}catch(Exceptione){System.out.println(e.getMessage());}finally{tr
8、y{rs.close();cstm.close();con.close();}catch(Exception