使用Mark Rotteveel提供的输入,我能够做到。谢谢马克,肖恩也感谢您的输入。这是可能对您有用的任何人的工作代码。
String jdbcurl = "jdbc:sqlserver://TestServer:1433;DatabaseName=Student";connection = DriverManager.getConnection(jdbcurl,"username","password");SQLServerDataTable stuTypeDT = new SQLServerDataTable(); stuTypeDT.addColumnmetadata("StudentId", java.sql.Types.NUMERIC);stuTypeDT.addColumnmetadata("Name", java.sql.Types.VARCHAR);stuTypeDT.addColumnmetadata("Department", java.sql.Types.VARCHAR);stuTypeDT.addColumnmetadata("Address", java.sql.Types.VARCHAR);stuTypeDT.addRow("1","Tom", "A", "123 Street");stuTypeDT.addRow("2","Jery", "B", "456 Street");stuTypeDT.addRow("3","Mac", "C", "Vancour");String ececStoredProc = "EXEC InsertStudentInfo ?";SQLServerPreparedStatement pStmt = (SQLServerPreparedStatement)connection.prepareStatement(ececStoredProc);pStmt.setStructured(1, "dbo.StudentInfoType", stuTypeDT);pStmt.execute();


