2.向数据库插入数据

public class Contact {

? private String firstName; 

??private String lastName;?? 

??private String email;? 

??private int id;

?

? public Contact() {}

? 

??public Contact(

??? String firstName,

??? String lastName,

??? String email) {

??? this.firstName = firstName;

??? this.lastName = lastName;

??? this.email = email;

??? }

? 

??public String getEmail() {

??? return email;

? }

? public void setEmail(String email) {

??? this.email = email;

? }

? public String getFirstName() {

??? return firstName;

? }

? public void setFirstName(String firstName) {

??? this.firstName = firstName;

? }

? public int getId() {

??? return id;

? }

? public void setId(int id) {

??? this.id = id;

? }

? public String getLastName() {

??? return lastName;

? }

? public void setLastName(String lastName) {

??? this.lastName = lastName;

? } 

}

SqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE sqlMapConfig

PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"

"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

?

<sqlMapConfig>

?? <settings useStatementNamespaces="true"/>

???? <transactionManager type="JDBC">

??????? <dataSource type="SIMPLE">

????????? <property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>

????????? <property name="JDBC.ConnectionURL"

?????????????? value="jdbc:mysql://192.168.10.112:3306/vin"/>

????????? <property name="JDBC.Username" value="root"/>

????????? <property name="JDBC.Password" value="root"/>

??????? </dataSource>

????? </transactionManager>

???? <sqlMap resource="Contact.xml"/> 

</sqlMapConfig>

我们使用<insert>标签来映射SQL语句,在该标签中我们定义了一个"id",它将在IbatisInsertion.java文件中用来执行数据库插入,查询操作.

<selectKey resultClass="int" keyProperty="id">

?? select last_insert_id() as id

</selectKey>

上面的代码指出了表中被插入数据的下一行.

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE sqlMap 

PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"

"http://ibatis.apache.org/dtd/sql-map-2.dtd">

?

<sqlMap namespace="Contact"> 

<!--- Inserting data in table -->

?

<insert id="insert" parameterClass="Contact">

?????????? insert into contact (firstName,lastName,email)

?????????? values (#firstName#, #lastName#, #email#)

?????????? <selectKey resultClass="int" keyProperty="id">

??????????????? select last_insert_id() as id

?????????? </selectKey>

</insert> 

<!--- Showing all data of table -->

<select id="getAll" resultClass="Contact">

?????? select * from contact

</select>

</sqlMap>

IbatisInsertion.java的代码如下 :

import com.ibatis.common.resources.Resources;

import com.ibatis.sqlmap.client.SqlMapClient;

import com.ibatis.sqlmap.client.SqlMapClientBuilder;

import java.io.*;

import java.sql.SQLException;

import java.util.*;

?

public class IbatisInsertion{

? public static void main(String[] args) throws IOException,SQLException{

???? Reader reader = Resources.getResourceAsReader("SqlMapConfig.xml");

????? SqlMapClient sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);

????? //Inserting one record in contacts

????? System.out.println(

???? "*-------------- Inserting information in Contact Table -----------*");

????? Contact contact=new Contact("Amit","Kumar","amit@roseindia.net");

????? sqlMap.insert("Contact.insert",contact);

????? System.out.println("|Record Inserted Successfully ");

????? System.out.println("All Contacts");

????? List<Contact> contacts = (List<Contact>)

??????? sqlMap.queryForList("Contact.getAll",null);

??????? Contact contactall = new Contact();

????? for (Contact c : contacts) {

????? System.out.print("? " + c.getId());

????? System.out.print("? " + c.getFirstName());

????? System.out.print("? " + c.getLastName());

????? System.out.print("? " + c.getEmail());

??????? contact = c; 

??????System.out.println("");

??? }

????? System.out.println("===============================================");

????? }??? 

}

如何执行本例 :