Ibatis Example!

Transfer from: http://www.ibatis.comwhat does a mapped statement look like? (Updated for 2.0!)

A feature of the sql map framework what allows columns aliases to becomings

Automatically mapped to javabeans proties. Imagine That The Address

Class Has The Properties: ID (INT), Description (String), Street (String),

CITY (STRING), And Postalcode (String). by use of column

Aliases in the sql statement (a standard sql feature) and naming the

Class in The Result-Class Attribute, The Values ​​in The Columns Will B

Automatically mapped to the javabean! this is just one way to get an

Object (javabean) from an SQL Query Using The SQL MAP Framework. ->

Resultclass = "Examples.domain.address"> SELECT

ADR_ID AS ID, ADR_DESCRIPTION As Description, ADR_STREET As Street, ADR_CITY As City, ADR_PROVINCE AS Province, ADR_POSTAL_CODE AS Postalcode from Address Where ADR_ID = # Value #

How Would I EXECUTE IT from Java?

/ * The Following Simple Line of Code Would Execute The Above Mapped

* statement using the integer 5 as the key to be passed to the # value #

* Parameter in The Above Statement.

* /

Integer pk = new integer (5);

Address Address = (Address) SQLMap.QueryForObject ("getaddress", PK);

Note: Check Out JPETSTORE 4, IT Uses Many of The Latest Features and is a Great Example of a Complete Application.and There is Also A Complence Developer Guide for Complete Documentation.

More Example Below

Address.SetStreet ("16 somestreet");

...

SQLMap.Insert ("Insertdress", Address;

Resultclass = "Examples.domain.Product">

SELECT

PrD_ID AS ID,

PrD_category as category,

PrD_DESCRIPTION As Description,

PrD_retail as retail,

PrD_quantity as quantity

From product

Where prd_category = # value #

// Executing The Above Statement for a list of products

// in the "Dog" category is as simple as this:

String category = "DOG";

List productlist = sqlmap.queryforList ("getProductBycategory", category;

/ / TOO MANY RESULTS? How About a fully navigatable,

// lazy-loaded, Paginated List of Products That's

// javabeans Compliant and Easily Usable from With

// a JSP Page? Is 10 per page okay?

PaginatedList ProductList = SQLMap.QueryforList ("getProductBycategory", category,

10);

ProductList.nextpage ();

ProductList.Previouspage ();

ProductList.isnexTPageavailable ();

// ETC.

// NEED A MAP of Just The Product IDS and Descriptions from

// The Same Query?

Map descriptionMap = SQLMap.QueryFormap ("getProductBycategory",

Category,

"ID",

"description");

For example, Maybe you need to flatten out a

COMPLEX PARENT / CHILD TREE Using ORACLE? ->

Resultclass = "examples.domain.employee">

SELECT

EMP_ID AS ID,

EMP_NUMBER AS EMPLOYEENUMBER,

EMP_FIRST_NAME As FirstName,

EMP_LAST_NAME As LastName,

EMP_DEPT_CODE AS Departmentcode

From Employee

START with EMP_ID = # Value #

Connect by prior EMP_MANAGER_ID = EMP_ID;

Integer ManagerId = New Integer (15);

List Employeelist = SQLMap.QueryforList ("GetEmployeesbymanagerRecursively",

ManagerID);

转载请注明原文地址:https://www.9cbs.com/read-84684.html

---

9cbs

New Post(0)