Interested to Buy Any Domain ? << Click Here >> for more details...
can someone tell me how does preparedstatement works? its
an interface and where is the implementation?
- 3 Answers
- 8514 Views
- Satyam, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sk.bilal ahmed
A SQL statement is precompiled and stored in a
PreparedStatement object. This object can then be used to
efficiently execute this statement multiple times.
Note: The setter methods (setShort, setString, and so on)
for setting IN parameter values must specify types that are
compatible with the defined SQL type of the input
parameter. For instance, if the IN parameter has SQL type
INTEGER, then the method setInt should be used.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / krishna
suppose if the string contains same select statement with
different set of values then fo for PreparedStatement..
ex:String str="select ename,eage from emp where ename=?";
yes it is interface provided by java soft people in their
api specification
| Is This Answer Correct ? | 2 Yes | 0 No |
1. Yes PreparedStatement is and interface. It was in
java.sql package.
2. PreparedStatement interface creates an object that
represents a precompiled SQL statement. By using this we
can protect from SQL Injection.
| Is This Answer Correct ? | 1 Yes | 3 No |
Why is j2ee needed?
Is python more secure than java?
How do you make a class immutable in java?
Which edition of java is used for web application?
Explain j2ee architecture.
What is external subset?
Is c++ more secure than java?
What is containers in java?
public class ActionDTO extends GenericDTO implements Serializable,Auditable { // default serial version id, required for serializable classes. public static final String ACTION_SUSPEND = "SPN"; public static final String ACTION_DEREGISTER = "DRR"; public static final String ACTION_REINSTATE = "REI"; private static final long serialVersionUID = 1L; private Long actionId; private long accountId; private Date actionDate; private String actionType; private String remarks; private AccountDTO account; public ActionDTO() { } public ActionDTO(Long accountId, String action, String remarks, String updatedBy) { setAccountId(accountId); setActionType(action); setActionDate(new Date()); setRemarks(remarks); setUpdatedBy(updatedBy); } public Long getActionId() { return this.actionId; } public void setActionId(Long actionId) { this.actionId = actionId; } public long getAccountId() { return this.accountId; } public void setAccountId(long accountId) { this.accountId = accountId; } public Date getActionDate() { return this.actionDate; } public void setActionDate(Date actionDate) { this.actionDate = actionDate; } public String getActionType() { return this.actionType; } public void setActionType(String actionType) { this.actionType = actionType; } public String getRemarks() { return this.remarks; } public void setRemarks(String remarks) { this.remarks = remarks; } // bi-directional many-to-one association to AccountDTO public AccountDTO getAccount() { return this.account; } public void setAccount(AccountDTO account) { this.account = account; } @Override public String toString() { // TODO Auto-generated method stub return null; } } what is the purpose of @Override public String toString()...and what will do here ?
Is java a tool?
What is application client?
Is class a data type in java?
Core Java 
