Spring mvc+Ajax用户登录增删改查功能

package com.userplay; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; import java.io.IOException; import java.util.ArrayList; import java.util.List ; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.sql. * ; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMethod; @Controller public class UsersController { @RequestMapping({"/Login","/"}) public String list(Model model) { return "Login"; } @RequestMapping(value="/login",method=RequestMethod.POST) @ResponseBody public boolean login(String userName,String Password) throws IOException{ boolean result = false; try { Class.forName( "org.postgresql.Driver" ).newInstance(); String url = "jdbc:postgresql://localhost:5432/test" ; Connection con = DriverManager.getConnection(url, "postgres" , "123456" ); Statement st = con.createStatement(); String sql = "select * from person where name ='"+userName+"' and password = '"+Password+"' "; ResultSet rs = st.executeQuery(sql); if (rs.next()) { result = true; } rs.close(); st.close(); con.close(); } catch (Exception ee) { System.out.print(ee.getMessage()); } return result; } @RequestMapping(value="/Show",method=RequestMethod.POST) @ResponseBody public List<List<String>> Show() throws IOException{ List<List<String>> listStr = new ArrayList<List<String>>(); try { Class.forName( "org.postgresql.Driver" ).newInstance(); String url = "jdbc:postgresql://localhost:5432/test" ; Connection con = DriverManager.getConnection(url, "postgres" , "123456" ); Statement st = con.createStatement(); String sql = "select * from person order by id"; ResultSet rs = st.executeQuery(sql); while(rs.next()) { String id = rs.getInt(1)+""; String name = rs.getString(2); String password = rs.getString(3); List<String> list = new ArrayList<String>(); list.add(id); list.add(name); list.add(password); listStr.add(list); } rs.close(); st.close(); con.close(); } catch (Exception ee) { System.out.print(ee.getMessage()); } return listStr; } @RequestMapping(value="/Update") @ResponseBody public boolean Update(String userId,String userName,String Password) throws IOException{ int id = Integer.valueOf(userId).intValue(); boolean result = false; try { Class.forName( "org.postgresql.Driver" ).newInstance(); String url = "jdbc:postgresql://localhost:5432/test" ; Connection con = DriverManager.getConnection(url, "postgres" , "123456" ); Statement st = con.createStatement(); String sql = "update person set name = '"+userName+"',password = '"+Password+"' where id = '"+id+"'"; int count = st.executeUpdate(sql); if(count > 0){ result = true; } st.close(); con.close(); } catch (Exception ee) { System.out.print(ee.getMessage()); } return result; } @RequestMapping(value="/Delete") @ResponseBody public boolean Delete(String userId,String userName,String Password) throws IOException{ int id = Integer.valueOf(userId).intValue(); boolean result = false; try { Class.forName( "org.postgresql.Driver" ).newInstance(); String url = "jdbc:postgresql://localhost:5432/test" ; Connection con = DriverManager.getConnection(url, "postgres" , "123456" ); Statement st = con.createStatement(); String sql = "delete from person where id = '"+id+"' and name = '"+userName+"'and password = '"+Password+"'"; int count = st.executeUpdate(sql); if(count > 0){ result = true; } st.close(); con.close(); } catch (Exception ee) { System.out.print(ee.getMessage()); } return result; } @RequestMapping(value="/Insert") @ResponseBody public boolean Insert(HttpServletRequest request,HttpServletResponse response) throws IOException{ String userId = request.getParameter("userId"); int id = Integer.valueOf(userId).intValue(); String userName = request.getParameter("userName"); String userPw = request.getParameter("Password"); boolean result = false; try { Class.forName( "org.postgresql.Driver" ).newInstance(); String url = "jdbc:postgresql://localhost:5432/test" ; Connection con = DriverManager.getConnection(url, "postgres" , "123456" ); Statement st = con.createStatement(); String sql = "insert into person(id,name,password) values('"+id+"','"+userName+"','"+userPw+"')"; int count = st.executeUpdate(sql); if(count > 0){ result = true; } st.close(); con.close(); } catch (Exception ee) { System.out.print(ee.getMessage()); } return result; } }