?? callprocedure.txt
字號:
<%//調用存儲過程更新記錄
String procedure_name="update_user_data";//執行的存儲過程名稱
String call_procedure_string="{call "+procedure_name+"(?,?,?,?,?,?,?)}";//調用存儲過程的語句
try
{ Connection con;
Statement sql;
ResultSet rs;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testDatabse","sa","6599996");
CallableStatement callable_statement = con.prepareCall(call_procedure_string);//創建對象
//設置調用存儲過程的參數
callable_statement.setString(1,username);
callable_statement.setString(2,usertruename);
callable_statement.setInt(3,ageint);
callable_statement.setString(4,sex);
callable_statement.setString(5,address);
callable_statement.setString(6,telephone);
callable_statement.setLong(7,user_id);
callable_statement.executeUpdate();
con.close();
}
catch(SQLException e1)
{
/ut.print("SQL異常!");
}
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -