实验5Spri
g与数据库
一、实验目的1掌握在Spri
g中配置数据源的方法1掌握JdbcTemplate的使用方法二、实验器材1计算机
三、实验内容使用Spri
gJdbcTemplate实现登录功能。具体要求如下：根据账号和密码进行登录操作，登录结果分为三种情况：1账号不存在2账号存在，但密码错误3账号密码都正确根据不同的登录结果，给出相应的提示信息。四、实验步骤编写User类packageorghrbustexperime
te
titypublicclassUseri
tIDStri
guserNameStri
gpasswordpublici
tgetIDretur
ID
fpublicvoidsetIDi
tiDIDiDpublicStri
ggetUserNameretur
userNamepublicvoidsetUserNameStri
guserNamethisuserNameuserNamepublicStri
ggetPasswordretur
passwordpublicvoidsetPasswordStri
gpasswordthispasswordpassword编写UserRowMapperpackageorghrbustexperime
tserviceimportjavasqlResultSetimportjavasqlSQLExceptio
importorghrbustexperime
te
tityUser
fimportorgspri
gframeworkdaoDataAccessExceptio
importorgspri
gframeworkjdbccoreResultSetExtractorimportorgspri
gframeworkjdbccoreRowMapperpublicclassUserRowMapperimpleme
tsRowMapperpublicObjectmapRowResultSetrsi
tidxthrowsSQLExceptio
TODOAutoge
eratedmethodstubUseru
ewUserusetIDrsgetI
t