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

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條評論
主站蜘蛛池模板: www.国产在线观看 | 精品一区亚洲 | 亚洲精品美女视频 | 日本高清不卡网站免费 | 99热2| 久久色成人 | 国产精品美女久久久久久 | 精品中文字幕乱码一区二区 | 92精品国产自产在线观看 | 狠狠色噜噜狠狠狠狠狠色综合久久 | 老司机福利深夜亚洲入口 | 国产一区二区三区影院 | 亚洲国产精品人久久 | 免费福利入口在线观看 | 精品国产免费久久久久久 | 中文字幕久热 | 香蕉视频在线观看网站 | 亚洲人成在线免费观看 | 91精品国产人成网站 | 成人爽视频| 来自深渊在线观看 | 四虎影视最新 | 四虎影视在线看 | 99久久成人国产精品免费 | 毛茸茸成熟女性老太的女bbww | 97视频免费观看 | 久久中文字幕视频 | 99综合久久 | 91精品久久久久亚洲国产 | 手机看片国产免费久久网 | 国产精品视频不卡 | 久久精品免视看国产成人2021 | 国产伦乱| 日本高清在线一区二区三区 | 国产高清视频在线播放 | 久草视频在线看 | 免费看一级黄色毛片 | 久久久久久久尹人综合网亚洲 | 亚洲欧美在线精品一区二区 | 国产成人精品区在线观看 | 狠狠躁夜夜躁人人爽天天天天 |