亚洲免费在线-亚洲免费在线播放-亚洲免费在线观看-亚洲免费在线观看视频-亚洲免费在线看-亚洲免费在线视频

Spring使用JdbcTemplate操作數據庫---使用RowCa

系統 1555 0

首先,假設如下SQL表中有數據username=test1,passwd=test1,address=test1

CREATE TABLE `login` (
? `username` varchar(10) default NULL,
? `passwd` varchar(10) default NULL,
? `address` varchar(10) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

?

配置文件:

?

<? xml?version="1.0"?encoding="UTF-8" ?>
<! DOCTYPE?beans?PUBLIC?"-//SPRING//DTD?BEAN//EN"?"http://www.springframework.org/dtd/spring-beans.dtd"? >
< beans >
?
< bean? id ="dataSource" ?class ="org.apache.commons.dbcp.BasicDataSource" >
???
< property? name ="driverClassName" >
?????
< value > com.mysql.jdbc.Driver </ value >
???
</ property >
???
< property? name ="url" >
?????
< value > jdbc:mysql://localhost:3306/javaee </ value >
???
</ property >
???
< property? name ="username" >
?????
< value > root </ value >
???
</ property >
???
< property? name ="password" >
?????
< value > 1234 </ value >
???
</ property >
?
</ bean >
?
< bean? id ="jdbcTemplate" ?class ="org.springframework.jdbc.core.JdbcTemplate" >
???
< property? name ="dataSource" >
?????
< ref? local ="dataSource" />
???
</ property >
?
</ bean >

< bean? id ="personDAO" ?class ="SpringJDBCSupport.ReadData.PersonDAO" >
??
< property? name ="jdbcTemplate" >
????
< ref? local ="jdbcTemplate" />
??
</ property >
</ bean > ?
</ beans >

?JavaBean:

?

package ?SpringJDBCSupport.ReadData;
import ?com.mysql.jdbc.Driver;
public ? class ?Person? ... {
??
private ?String?name;
??
private ?String?password;
??
private ?String?address;
??
public ?Person() ... {
??????
??}

??
public ?Person(String?name,String?password,String?address) ... {
??????
this .name = name;
??????
this .password = password;
??????
this .address = address;
??}

public ?String?getAddress()? ... {
????
return ?address;
}

public ? void ?setAddress(String?address)? ... {
????
this .address? = ?address;
}

public ?String?getName()? ... {
????
return ?name;
}

public ? void ?setName(String?name)? ... {
????
this .name? = ?name;
}

public ?String?getPassword()? ... {
????
return ?password;
}

public ? void ?setPassword(String?password)? ... {
????
this .password? = ?password;
}

public ?String?toString() ... {
????
return ? this .getName() + " - " + this .getPassword() + " - " + this .getAddress();
}

}

?

DAO:

其中getPersonByRowCallbackHandler方法根據username獲得person對象

package ?SpringJDBCSupport.ReadData;

import ?java.sql.PreparedStatement;
import ?java.sql.ResultSet;
import ?java.sql.SQLException;
import ?java.sql.Types;
import ?java.util.List;

import ?org.springframework.jdbc.core.BatchPreparedStatementSetter;
import ?org.springframework.jdbc.core.JdbcTemplate;
import ?org.springframework.jdbc.core.RowCallbackHandler;

public ? class ?PersonDAO? ... {
??
private ?JdbcTemplate?jdbcTemplate;

public ?JdbcTemplate?getJdbcTemplate()? ... {
????
return ?jdbcTemplate;
}


public ? void ?setJdbcTemplate(JdbcTemplate?jdbcTemplate)? ... {
????
this .jdbcTemplate? = ?jdbcTemplate;
}


public ? int ?insertPersonUseUpdate(Person?person) ... {
????String?sql
= " insert?into?login?values(?,?,?) " ;
????Object[]?params
= new ?Object[] ... {
????????????person.getName(),
????????????person.getPassword(),
????????????person.getAddress()
????}
;
????
return ? this .getJdbcTemplate().update(sql,params);
}

public ? int ?insertPersonUseExecute(Person?person) ... {
????String?sql
= " insert?into?login?values(?,?,?) " ;
????Object[]?params
= new ?Object[] ... {
????????????person.getName(),
????????????person.getPassword(),
????????????person.getAddress()
????}
;
????
int []?types = new ? int [] ... {
????????????Types.VARCHAR,
????????????Types.VARCHAR,
????????????Types.VARCHAR
????}
;
????
return ? this .getJdbcTemplate().update(sql,params,types);
}

public ? int []?updatePersonUseBatchUpdate(? final ?List?persons) ... {
????String?sql
= " insert?into?login?values(?,?,?) " ;
????BatchPreparedStatementSetter?setter
= null ;
????setter
= new ?BatchPreparedStatementSetter() ... {
????????
public ? int ?getBatchSize() ... {
????????????
return ?persons.size();
????????}

????????
public ? void ?setValues(PreparedStatement?ps, int ?index)? throws ?SQLException ... {
????????????Person?person
= (Person)persons.get(index);
????????????ps.setString(
1 ,person.getName());
????????????ps.setString(
2 ,person.getPassword());
????????????ps.setString(
3 ,person.getAddress());
????????}

????}
;
????
return ? this .getJdbcTemplate().batchUpdate(sql,setter);
}


public ?Person?getPersonByRowCallbackHandler(String?username) ... {

????String?sql
= " select?*?from?login?where?username=? " ;
????
final ?Person?person = new ?Person();
????
final ?Object?params[] = new ?Object[] ... {username} ;
????
this .getJdbcTemplate().query(sql,params, new ?RowCallbackHandler() ... {
????????
public ? void ?processRow(ResultSet?rs) throws ?SQLException ... {
????????????person.setName(rs.getString(
" username " ));
????????????p

Spring使用JdbcTemplate操作數據庫---使用RowCallbackHander讀數據篇


更多文章、技術交流、商務合作、聯系博主

微信掃碼或搜索:z360901061

微信掃一掃加我為好友

QQ號聯系: 360901061

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。

【本文對您有幫助就好】

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描上面二維碼支持博主2元、5元、10元、自定義金額等您想捐的金額吧,站長會非常 感謝您的哦!!!

發表我的評論
最新評論 總共0條評論
主站蜘蛛池模板: 97在线免费视频观看 | 精品视频一区二区三区免费 | 97夜夜澡人人爽人人免费 | 免费一级毛片在线播放不收费 | 一级做性色a爱片久久片 | 精品色 | 免费高清在线爱做视频 | 麻豆亚洲 | 高清不卡一区二区三区 | 老司机午夜在线视频免费观 | 黄色的网站在线观看 | 俄欧美做爰xxxⅹ在线视频 | 99热这里只有精品第一页 | 天天做夜夜做 | 爱爱99 | 123日本不卡在线观看 | 老头老太做爰xxx视频 | 男女xxⅹ爽免费视频 | 亚洲国产高清在线精品一区 | 国产一区二区精品久久 | 国产精品亚洲玖玖玖在线靠爱 | 亚洲爱婷婷色婷婷五月 | 色综合天天综久久久噜噜噜久久〔 | 国产精品久久久久久久久齐齐 | 中国女人内谢69xxxxx高清 | 国产精品日韩欧美一区二区三区 | 久久久国产免费影院 | 香港之夜免费观看 | 精品欧美高清一区二区免费 | 久久伊人在 | 天天射天天操天天 | 午夜欧美性视频在线播放 | 亚洲精品久久久久久久无 | 目韩一区二区三区系列片丶 | 视频在线观看一区 | 97天天做天天爱夜夜爽 | 精品成人免费一区二区在线播放 | 亚洲码在线| 国产精品第一页爽爽影院 | 一级免费看 | 少妇美女极品美軳人人体 |