try {
String filename="D:\\TempData1.txt";
FileInputStream str=new FileInputStream(filename);
filename = "D:\\TempData2.txt";
FileInputStream str1 = new FileInputStream(filename);
PreparedStatement pstmt = con.prepareStatement("{call dbo.S_submit(?,?,?,?)}");
pstmt.setString(1, num.getText());
pstmt.setString(2, "1");
pstmt.setBinaryStream(3, str);
pstmt.setBinaryStream(4, str1);
//pstmt.execute();
//ResultSet rs = pstmt.executeQuery();
//rs.close();
pstmt.close();
}
catch (Exception e) {
e.printStackTrace();
}
con.prepareCall
应该是哪儿的小问题。
CREATE PROCEDURE S_submit (@A_Sno Varchar(10),@A_Pno Varchar(10),@A_XAnwser Varbinary(max),
@A_JAnwser Varbinary(max) )
AS
insert into Anwser(Sno,Pno,ADATA,XAnwser,JAnwser)
values(@A_Sno,@A_Pno,NEWID(),@A_XAnwser,@A_JAnwser)