junit junit 3.8.1 test javax.servlet javax.servlet-api 4.0.1 provided org.springframework spring-webmvc 4.3.23.RELEASE org.springframework spring-jdbc 4.3.23.RELEASE mysql mysql-connector-java 8.0.26 com.mchange c3p0 0.9.5.5 javax.servlet jstl 1.2 com.alibaba fastjson 1.2.47 log4j log4j 1.2.17 org.mybatis mybatis 3.5.7 org.mybatis mybatis-spring 2.0.6
spring-springMVC20221121 login.jsp characterEncodingFilter org.springframework.web.filter.CharacterEncodingFilter encoding UTF-8 characterEncodingFilter /* contextConfigLocation classpath:applicationContext.xml org.springframework.web.context.ContextLoaderListener springmvc org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:springmvc-common.xml springmvc /
#LOG_DIR:/usr/local/.../logs\
LOG_DIR = E:\\logs
#Level:ERROR,WARN,INFO,DEBUG
log4j.rootLogger = INFO,Console,File
log4j.appender.Console = org.apache.log4j.ConsoleAppender
log4j.appender.Console.Threshold = DEBUG
log4j.appender.Console.ImmediateFlush = true
log4j.appender.Console.Target = System.out
log4j.appender.Console.layout = org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern = [%-5p] %d{yyyy-MM-dd HH:mm:ss,SSS} method:%l%n%m%n
log4j.appender.File = org.apache.log4j.DailyRollingFileAppender
log4j.appender.File.Threshold = INFO
log4j.appender.File.ImmediateFlush = true
log4j.appender.File.Append = true
log4j.appender.File.DatePattern = '_'yyyy-MM-dd'.log'
log4j.appender.File.encoding=UTF-8
log4j.appender.File.File = ${LOG_DIR}/info
log4j.appender.File.layout = org.apache.log4j.PatternLayout
log4j.appender.File.layout.ConversionPattern = [%-5p][%d{ISO8601}]%m%n
根据个人连接数据库信息更改
a=jdbc:mysql://localhost:3306/test?characterEncoding=UTF-8
b=root
c=123
d=com.mysql.cj.jdbc.Driver
classpath:jdbc.properties
insert into tb_user (uname,upwd,email,phone,addr,birth)values(#{uname},#{upwd},#{email},#{phone},#{addr},#{birth})
public interface UserService {void insertUser(User user);
}
@Service
public class UserServiceImpl implements UserService {@Autowiredprivate UserDao userDao;@Overridepublic void insertUser(User user) {userDao.addUser(user);}}
public class MyConverter implements Converter{@Overridepublic Date convert(String source) {SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");try {Date d=sdf.parse(source);return d;} catch (ParseException e) {e.printStackTrace();return null;}}}
@Controller
@RequestMapping("/user")
public class UserController {@Autowiredprivate UserService userService;@RequestMapping("/reg")public String reg(User user) {userService.insertUser(user);return "login";}
}