首页 \ 问答 \ 执行不同任务的存储过程？(Stored procedure to perform different tasks?)

执行不同任务的存储过程？(Stored procedure to perform different tasks?)

 我有一张客户表。  
 我创建了可用于将新数据插入表中的存储过程。 但是，如果我想使用相同的过程来更新或删除该表中的数据，该怎么办？ 我可以轻松地做到这一点，还是我必须为每个功能使用单独的功能/程序？  
create or replace procedure add_customer(custid in table.id%type,
name table.name%type) 
is
begin
insert into table(id, name)
values(id, name);
commit;
end;
/

I have a customer table. 
I have created stored procedure I can use to insert new data into the table. But what if I wanted to use the same procedure to update OR delete data from that table. Could I do this easily or do I have to use a separate function/procedure for each function? 
create or replace procedure add_customer(custid in table.id%type,
name table.name%type) 
is
begin
insert into table(id, name)
values(id, name);
commit;
end;
/

原文：https://stackoverflow.com/questions/29333379

更新时间：2024-03-26 08:03

最满意答案

 不，这是不可能的。  
 MFMessageComposeViewController的接口不提供任何属性或功能来影响其呈现消息的方式。 因为MFMessageComposeViewController不公开其任何视图组件，所以子类化是不可替代的。  
 （只要100％正确：你当然可以展示MFMessageComposeViewController ，然后一旦它可见，遍历它的整个视图层次结构，直到找到类UITextView的视图，其text或attributedText text attributedText等于您提供的body文本，然后将该文本视图的我们完全不鼓励你这样做。封装是有原因的，如果MFMessageComposeViewController没有提供一个接口来选择它的文本视图中的文本，那么MFMessageComposeViewController可以工作（→未经测试）意味着你不应该那样做。） 

No. This is not possible. 
The interface for MFMessageComposeViewController does not provide any properties or functions to influence the way it presents the message. Subclassing is no alternative either as the MFMessageComposeViewController doesn't expose any of its view components. 
(Just to be 100% correct: You could of course present the MFMessageComposeViewController, then once it's visible traverse its whole view hierarchy until you find a view of class UITextView whose text or attributedText property equals the body text you provided and then set that text view's selectedRange to the full range of the text. While this will probably work (→ untested) I totally discourage you to do that. Encapsulation is there for a reason and if the MFMessageComposeViewController doesn't provide an interface to select text inside its text view it means that you're not supposed to do that.)

执行不同任务的存储过程？(Stored procedure to perform different tasks?)

最满意答案

不，这是不可能的。

No. This is not possible.

相关问答

编辑后保留突出显示的文本颜色(Retain highlighted color of text after editing)[2022-04-20]

MFMessageComposeViewController显示消息体突出显示进行编辑(MFMessageComposeViewController show with message body highlighted for editing)[2023-07-17]

MFMessageComposeViewController后没有显示键盘(Keyboard not showing after MFMessageComposeViewController)[2021-08-16]

MFMessageComposeViewController中的接口语言(Interface language in MFMessageComposeViewController)[2023-01-20]

UITableView（Swift）中的MFMessageComposeViewController(MFMessageComposeViewController in a UITableView (Swift))[2022-07-29]

MFMessageComposeViewController不发送消息(MFMessageComposeViewController doesn't send out the message)[2021-11-16]

MFMessageComposeViewController第一个alloc需要几秒钟(MFMessageComposeViewController first alloc takes seconds)[2023-07-25]

MFMessageComposeVIewController忽略它的委托，而不是它本身(MFMessageComposeVIewController is dismissing its delegate instead of itself)[2022-11-05]

在Swift中，发送短信失败但MFMessageComposeViewController委托显示已发送(In Swift, Failed to send SMS but MFMessageComposeViewController Delegate Show sent)[2023-12-09]

发送委托的MFMessageComposeViewController短信(MFMessageComposeViewController sms sent delegate)[2020-07-04]

相关文章

最新问答