touch .bash_profile $vim .bash_profile
public interface ISuperA {
}
public interface ISuperB {
}
public class ImplementClass implements ISuperA, ISuperB {
}
public static void main(String[] args) {
Class superclass = ImplementClass.class.getSuperclass();
Class[] interfaces = ImplementClass.class.getInterfaces();
System.out.println("superclass:"+superclass.getName());
System.out.println("interfaces:");
for(Class interface1 : interfaces)
System.out.print("\t"+interface1.getName());
}
superclass:java.lang.Object interfaces: ISuperA ISuperB
package com.springinaction.knights;
public classBraveKnightimplementsKnight{
privateQuestquest;
public BraveKnight(Questquest){
this.quest=quest;
}
public voidembarkOnQuest()throwsQuestException{
quest.embark();
}
}
package com.springinaction.knights;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
public classKnightMain{
public staticvoidmain(String[]args){
ApplicationContextcontext = new ClassPathXmlApplicationContext("knights.xml");
Knightknight=(Knight)context.getBean("knight");
knight.embarkOnQuest();
}
}
UPDATE UserData SET money = #{_money} WHERE userid = #{_userid}
public interface UserDataMapper{
public int updatUserMoney(UserData);
}
public class UserData {
private String _userid;
private int _money;
...
}
SqlSessionFactoryBuilder sqlSessionFactory = new SqlSessionFactoryBuilder()
.build(inputStream);
SqlSession sqlSession = sqlSessionFactory.openSession();
BaseDataMapper mapper = sqlSession.getMapper(BaseDataMapper.class);
int updateCount = mapper.updatUserMoney(UserData);
sqlSession.commit(true); //important!
< select id="getByUserId" parametertype="String" resulttype="UserData"> SELECT * FROM UserData WHERE USERID = #{xx} </ select>
public interface UserDataMapper{
public UserData getByUserId(String userId);
}
public class UserData {
private String _userid;
private int _money;
...
}
< select id="getByUserId" parameterType="String" resultType="UserData" >
SELECT userid as _userid,
money as _money
FROM UserData
WHERE USERID = #{xx}
< /select>
還是得乖乖用 sql field as java field name的方式一一指定而不能只是使用 SELECT * 否則就會發生一直都回傳Null的問題。jdbc.driver=org.hsqldb.jdbcDriver jdbc.url=jdbc:hsqldb:mem:my-project-test;shutdown=true jdbc.username=sa jdbc.password=
< configuration></ configuration>
public interface UserMapper{
public void insertUser(User user);
public User getUserById(String userId);
public List getAllUsers();
public void updateUser(User user);
public void deleteUser(String userId);
}
< mapper namespace="cmpnts.UserMapper">
< select id='getUserById' parameterType='String' resultType='User'>
SELECT
userid as Userid,
email as Email ,
Password,
name as Name
FROM USER
WHERE USERID = #{userId}
</ select>
< select id="getAllUsers" resultMap="userMap">
SELECT
userid ,
email ,
Password,
name
FROM USER
</ select>
INSERT INTO USER(userid,email, password, name)
VALUES(#{_userid},#{_email}, #{_password}, #{_name})
UPDATE USER
SET
PASSWORD = #{_password},
NAME = #{_name},
EMAIL = #{_email}
WHERE USERID = #{_userid}
DELETE FROM USER WHERE USERID = #{userid}
</ mapper>
public class User {
private String _userid;
private String _name;
private String _password;
private String _email;
public String getUserId() {
return _userid;
}
public void setUserId(String userid) {
this._userid = userid;
}
public String getName() {
return _name;
}
public void setName(String username) {
this._name = username;
}
public String getPassword() {
return _password;
}
public void setPassword(String pwd) {
this._password = pwd;
}
public String getEmaill(){
return _email;
}
public void setEmaill(String mail){
_email = mail;
}
@Override
public String toString(){
StringBuffer buf = new StringBuffer();
buf.append("UserId:").append(this.getUserId());
buf.append("\r\n\tname:").append(this.getName());
buf.append("\r\n\tpassword:").append(this.getPassword());
buf.append("\r\n\temail:").append(this.getEmaill());
return buf.toString();
}
}
public class Main {
/**
* @param args
*/
public static void main(String[] args) {
String resource = "mybatis-config.xml";
InputStream inputStream;
try {
inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder()
.build(inputStream);
createTableUser();
getAllUsers(sqlSessionFactory);
//insert user
User nuser = new User();
nuser.setUserId("nuid");
nuser.setPassword("nuserpwd");
nuser.setName("rosie");
nuser.setEmaill("rosie@mail.com.tw");
insertUser(sqlSessionFactory,nuser);
System.out.println("---After---");
getAllUsers(sqlSessionFactory);
User uuser = getUserById(sqlSessionFactory,"Q12");
uuser.setEmaill("Q12update@mail.com.tw");
uuser.setPassword("Q12updatePwd");
uuser.setName("Q12updateName");
updateUser(sqlSessionFactory,uuser);
System.out.println("---UpdateAfter---");
getAllUsers(sqlSessionFactory);
deleteUser(sqlSessionFactory,"Q12");
System.out.println("---DeleteAfter---");
getAllUsers(sqlSessionFactory);
} catch (Exception e) {
e.printStackTrace();
}
}
private static User getUserById(SqlSessionFactory sqlSessionFactory,String userid){
return UserDAO.getUserById(sqlSessionFactory,userid);
}
private static void updateUser(SqlSessionFactory sqlSessionFactory,User user){
UserDAO.updateUser(sqlSessionFactory,user);
}
private static void deleteUser(SqlSessionFactory sqlSessionFactory, String userid) {
UserDAO.deleteUser(sqlSessionFactory, userid);
}
private static void getAllUsers(SqlSessionFactory sqlSessionFactory){
List list = UserDAO.getAllUsers(sqlSessionFactory);
for(User user : list)
System.out.println(user);
}
private static void insertUser(SqlSessionFactory sqlSessionFactory, User user) {
UserDAO.insertUser(sqlSessionFactory, user);
}
public static void createTableUser() {
try {
// DBUnitUtilities.createTable(create);
Connection conn = DBUnitUtilities.createHsqlDBConnection();
SqlGetResultMain sqlmain = new SqlGetResultMain(conn);
sqlmain.setIsAutoCommit(false);
int update = sqlmain.update(new CreateUser());
conn = DBUnitUtilities.createHsqlDBConnection();
MsSqlConnection dbunitConnection =
new MsSqlConnection(conn, null);
DBUnitUtilities.insertTableDataFromExistingXml("res/UserDatas.xml",
dbunitConnection);
sqlmain.commit();
} catch (Exception ex) {
ex.printStackTrace();
}
}
}