spring高级编程新闻发布系统报告.docx

3.3SpringDAO

UserDao.java

packagenews.dao;

importjava.util.List;

importnews.model.User;

publicinterfaceUserDao{

UserfindUser（Stringaccount,Stringpassword,inttype）;

booleanaddad（Stringaccount,Stringpassword,Stringname）;

}

UserDaoJdbcImpl.java

packagenews.dao;

importjava.sql.ResultSet;

importjava.sql.SQLException;

importjava.util.List;

importnews.model.Student;

importnews.model.User;

importorg.springframework.dao.EmptyResultDataAccessException;

importorg.springframework.jdbc.core.RowMapper;

importorg.springframework.jdbc.core.support.JdbcDaoSupport;

publicclassUserDaoJdbcImplextendsJdbcDaoSupportimplementsUserDao{

@Override

publicUserfindUser（Stringaccount,Stringpassword,inttype）{

try{

if（type==0）

returnthis.getJdbcTemplate（）.queryForObject（"selectaccount,password,namefromtuserswhereaccount=?

andpassword=?

",

newObject[]{account,password},

newRowMapper（）{

@Override

publicUsermapRow（ResultSetrs,introwNum）throwsSQLException{

Useru=newUser（）;

u.setAccount（rs.getString

（1））;

u.setPassword（rs.getString

（2））;

u.setName（rs.getString（3））;

u.setType（0）;

returnu;

}

}）;

else

returnthis.getJdbcTemplate（）.queryForObject（"selectstudentNo,password,name,clazzNofromstudentswherestudentNo=?

andpassword=?

",

newObject[]{account,password},

newRowMapper（）{

@Override

publicUsermapRow（ResultSetrs,introwNum）throwsSQLException{

Studentu=newStudent（）;

u.setAccount（rs.getString

（1））;

u.setPassword（rs.getString

（2））;

u.setName（rs.getString（3））;

u.setStudentNo（u.getAccount（））;

u.setClazzNo（rs.getString（4））;

u.setType（0）;

returnu;

}

}）;

}catch（EmptyResultDataAccessExceptione）{

returnnull;

}

}

@Override

publicbooleanaddad（Stringaccount,Stringpassword,Stringname）

{

intflag=0;

System.out.println（account）;

System.out.println（password）;

System.out.println（name）;

Stringsql="Insertintotusersvalues（?

?

?

）";

try{

flag=this.getJdbcTemplate（）.update（sql,

newObject[]{account,password,name}）;

}catch（Exceptionea）{System.out.println（"有重复的tuser，已取消！

！

！

"）;}

if（flag==1）

returntrue;

else

returnfalse;

}

}

3.4SpringMVC

Student.java

packagenews.model;

publicclassStudentextendsUser{

privateStringstudentNo;

//privateStringname;

privateStringclazzNo;

publicStudent（）{

super.setType

（1）;

}

publicStudent（StringstudentNo,Stringname,Stringpassword,StringclazzNo）{

super（studentNo,name,password）;

this.studentNo=studentNo;

this.clazzNo=clazzNo;

super.setType

（1）;

}

publicStringgetStudentNo（）{

returnstudentNo;

}

publicvoidsetStudentNo（StringstudentNo）{

this.studentNo=studentNo;

}

publicStringgetClazzNo（）{

returnclazzNo;

}

publicvoidsetClazzNo（StringclazzNo）{

this.clazzNo=clazzNo;

}

}

代码说明：

这段代码应用了mvc中model技术。

HomeController.java

packagenews.controller;

importjava.util.List;

importjavax.servlet.http.HttpSession;

importnews.model.Report;

importnews.model.Student;

importnews.model.User;

importnews.service.LabService;

importnews.vo.ExperimentScore;

importorg.springframework.beans.factory.annotation.Autowired;

importorg.springframework.stereotype.Controller;

importorg.springframework.ui.Model;

importorg.springframework.web.bind.annotation.RequestMapping;

@Controller

publicclassHomeController{

@Autowired

privateLabServicelabservice;

@RequestMapping（"/"）

publicStringindex（）{

return"index";

}

//添加了session处理

@RequestMapping（"/login"）

publicStringlogin（Stringaccount,Stringpassword,inttype,

HttpSessionsession,Modelmodel）{

Useruser=labservice.login（account,password,type）;

if（user==null）{

model.addAttribute（"msg","账号或密码错误！

"）;

return"index";

}

else{

session.setAttribute（"user",user）;

if（type==1）{

return"writer";

}

else

return"admin";

}

}

@RequestMappi