day 8/7

weixin_45351817

于 2019-08-07 14:16:42 发布

阅读量76

点赞数

本文链接：https://blog.csdn.net/weixin_45351817/article/details/98744703

版权

SpringBoot实现注册

Controller

package com.zz.controller;

import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.zz.entity.User1;
import com.zz.entity.Homewokmaster;
import com.zz.service.UserService;
import com.zz.service.KeyUtil;
import com.zz.service.TService;
import com.zz.service.User;;

@RestController
public class UserController {

@RequestMapping("all")
public List<User1> getAll(){
	UserService us=new UserService();
	List<User1> userlist=us.selectAll();
	return userlist;
}

@RequestMapping("lod")
public void register(HttpServletRequest request){

	boolean aa = true;
	String name=request.getParameter("uname");
	String pwd=request.getParameter("pwd");
	String ageStr = request.getParameter("age");

	int age = 0;

	if(ageStr == null || ageStr.equals("")) {

	    age = 0;

	} else {

	    age = Integer.parseInt(ageStr);

	}
	String sex=request.getParameter("sex");
	String type=request.getParameter("type");
	System.out.println("信息为："+name);
	System.out.println("信息为："+type);
	
	System.out.println("信息为："+pwd);
	System.out.println("信息为："+age);
	System.out.println("信息为："+sex);
	User user = new User();
	user.setName(name);
	user.setPwd(pwd);
	user.setAge(age);
	user.setSex(sex);
	user.setId(KeyUtil.genUniqueKey());
	user.setType(type);
	TService dd= new TService();
	if (dd.findByName(user.getName())){;
	dd.add(user);
	
	 System.out.println("11");
	
	}
	else{
		HttpSession session=request.getSession();
		aa = false;
		session.setAttribute("aa", aa);
		 System.out.println("12");
		
	}
}

}

TService

package com.zz.service;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.springframework.stereotype.Service;

import com.zz.util.JDBCComon;

@Service
public class TService {
JDBCComon jdbc=new JDBCComon();
Connection conn=null;
/**
* 增加
* @param product
* @return
*/
public boolean add(User user){
boolean flag=false;
try {
conn=jdbc.getConnection();
String sql=“insert into user (name,pwd,age,sex,id,type) values (?,?,?,?,?,?)”;
PreparedStatement st=conn.prepareStatement(sql);
st.setString(1, user.getName());
st.setString(2, user.getPwd());
st.setInt(3, user.getAge());
st.setString(4, user.getSex());
st.setString(5, user.getId());
st.setString(6, user.getType());
if(st.execute()){
flag=true;
}
st.close();
conn.close();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flag;
};

public boolean findByName(String productName){
boolean flag=true;
try {
conn=jdbc.getConnection();
String sql=“select * from user where name=?”;
PreparedStatement st=conn.prepareStatement(sql);
st.setString(1, productName);
ResultSet rs=st.executeQuery();
while(rs.next()){
User product=new User();

		product.setName(rs.getString("name"));
		flag=false;
	}
	rs.close();
	st.close();
	conn.close();
} catch (ClassNotFoundException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
} catch (SQLException e) {
	// TODO Auto-generated catch block
	e.printStackTrace();
}
return flag;

}
}