JDBC Annotations : JDBC Annotation « Database « Java Tutorial

Home
Java Tutorial
1.Language
2.Data Type
3.Operators
4.Statement Control
5.Class Definition
6.Development
7.Reflection
8.Regular Expressions
9.Collections
10.Thread
11.File
12.Generics
13.I18N
14.Swing
15.Swing Event
16.2D Graphics
17.SWT
18.SWT 2D Graphics
19.Network
20.Database
21.Hibernate
22.JPA
23.JSP
24.JSTL
25.Servlet
26.Web Services SOA
27.EJB3
28.Spring
29.PDF
30.Email
31.J2ME
32.J2EE Application
33.XML
34.Design Pattern
35.Log
36.Security
37.Apache Common
38.Ant
39.JUnit
Java Tutorial » Database » JDBC Annotation 
20.25.1.JDBC AnnotationsPrevious/Next

The following table lists the Select annotation elements.

ElementTypeAccessibility
sql or valueStringThe SQL statement to be executed
tableNameStringThe name of the table that will be updated when the DataSet.sync method is called
readOnlybooleanIndicates the returned DataSet is read-only
connectedbooleanIndicates if the DataSet is connected to the data source
allColumnsMappedbooleanIndicates if there is a one-to-one mapping between the column names in the SQL statement and the fields in the returned DataSet
scrollablebooleanIndicates if the returned DataSet is scrollable. This element only takes effect only when in connected mode.


import java.sql.BaseQuery;
import java.sql.DataSet;
import java.sql.Select;
public interface UserQueries extends BaseQuery {


    // Select all users
    @Select (sql ="SELECT userId, firstName, lastName FROM Users",
             readOnly=false, connected=false, tableName="Users")
    DataSet<User> getAllUsers ();


    // Select user by name */
    @Select (sql ="SELECT userId, firstName, lastName FROM Users"
             "WHERE userName=?", readOnly=false, connected=false,
             tableName ="Users")
    DataSet<User> getUserByName(String userName);


}
20.25.JDBC Annotation
20.25.1.JDBC Annotations
20.25.2.Update annotation
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.