Mybatis_oracle entry case

1. Create a database mybase in oracle and a new users table. The table has two fields: id: auto-increment and name. The steps are omitted.

2. Create a java project and import two jar packages: classes12.jar and mybatis-3.0.4.jar.

3. Create a package under src: com. cb

4. There are five files under the com. cb package. You can copy and paste the following content directly:

1. Users. java

Package com. cb;
Public class Users {
Private int id;
Private String name;
Public int getId (){
Return id;
}
Public void setId (int id ){
This. id = id;
}
Public String getName (){
Return name;
}
Public void setName (String name ){
This. name = name;
}
Public Users (){

}
}

2. configuration. xml

<? Xml version = "1.0" encoding = "UTF-8"?>
<! DOCTYPE configuration PUBLIC "-// mybatis.org//DTD Config 3.0 // EN"
Http://mybatis.org/dtd/mybatis-3-config.dtd>
<Configuration>
<TypeAliases>
<TypeAlias type = "com. cb. Users"/>
</TypeAliases>
<Environments default = "development">
<Environment id = "development">
<TransactionManager type = "JDBC"/>
<DataSource type = "POOLED">
<Property name = "driver" value = "oracle. jdbc. OracleDriver"/>
<Property name = "url" value = "jdbc: oracle: thin :@ localhost: 1521: myBase"/>
<Property name = "username" value = "manager"/>
<Property name = "password" value = "manager"/>
</DataSource>
</Environment>
</Environments>
<Mappers>
<Mapper resource = "com/cb/Users. xml"/>
</Mappers>
</Configuration>

3. Users. xml

<? Xml version = "1.0" encoding = "UTF-8"?>
<! DOCTYPE mapper PUBLIC "-// mybatis.org//DTD Mapper 3.0 // EN"
Http://mybatis.org/dtd/mybatis-3-mapper.dtd>
<Mapper namespace = "com. cb. Users">
<! -- Add a record -->
<Insert id = "insertvalues" parameterType = "com. cb. Users">
Insert into users (id, name) values (auto_id.nextval, # {name })
</Insert>
<! -- Delete a record -->
<Delete id = "deleteOneUsers" parameterType = "com. cb. Users">
Delete from users where id =#{ id}
</Delete>
<! -- Update a record -->
<Update id = "updateOneUsers" parameterType = "com. cb. Users">
Update users set name = # {name} where id = # {id}
</Update>
<! -- Query a record -->
<Select id = "selectOneUsers" resultType = "com. cb. Users" parameterType = "int">
Select * from users where id =#{ id}
</Select>
<! -- Query all records -->
<Select id = "selectAllUsers" resultType = "com. cb. Users" parameterType = "int">
Select * from users
</Select>
</Mapper>

4. Util_sqlmapper.java

Package com. cb;

Import java. io. IOException;
Import java. io. Reader;

Import org. apache. ibatis. io. Resources;
Import org. apache. ibatis. session. SqlSession;
Import org. apache. ibatis. session. SqlSessionFactory;
Import org. apache. ibatis. session. SqlSessionFactoryBuilder;

Public class Util_sqlmapper {

Public static SqlSessionFactory sqlmapper = null;
Public static SqlSession sqlSession = null;
Static {
String rs = "com/cb/configuration. xml"; // indicates the configuration file name in step 2.
Reader reader = null;
Try {
Reader = Resources. getResourceAsReader (rs );
If (sqlmapper = null ){
Sqlmapper = new SqlSessionFactoryBuilder (). build (reader );
}
} Catch (IOException e ){
E. printStackTrace ();
}
}
Public static SqlSession getSqlSession (){
SqlSession = sqlmapper. openSession ();
Return sqlSession;
}
}

5. Test. java

Package com. cb;
Import java. io. IOException;
Import java. util. ArrayList;
Import org. apache. ibatis. session. SqlSession;

Public class Test {
@ SuppressWarnings ("unchecked ")
Public static void main (String [] args) throws IOException {
SqlSession session = Util_sqlmapper.getSqlSession ();
Try {
// Add a new record
/* Users users = new Users ();
Users. setName ("chnebei ");
Session. insert ("com. cb. Users. insertvalues", users );
Session. commit ();*/

// Delete a record which can be used by oracle
/* Session. delete ("com. cb. Users. deleteOneUsers", 0 );
Session. commit ();*/

// Update a piece of data which can be used by oracle
/* Users users = new Users ();
Users. setName ("lisi ");
Users. setId (10 );
Session. update ("com. cb. Users. updateOneUsers", users );
Session. commit ();*/

// Query a piece of data by condition. oracle can use
/* Users users = (Users) session. selectOne ("com. cb. Users. selectOneUsers", 10 );
System. out. println (users. getId () + "\ t" + users. getName ());*/

// You can use oracle to query all the table data.
ArrayList <Users> list = (ArrayList <Users>) session. selectList ("com. cb. Users. selectAllUsers ");
For (int I = 0; I <list. size (); I ++ ){
System. out. println (list. get (I). getId () + "\ t" + list. get (I). getName ());
}
} Catch (Exception e ){
// TODO Auto-generated catch block
E. printStackTrace ();
} Finally {
Session. close ();
}
}
}