Maven + Spring MVC＋Mybatis + MySQL +AngularJS + Bootstrap 实现简单微博应用（二）访问数据库

最新推荐文章于 2020-05-29 17:49:45 发布
最新推荐文章于 2020-05-29 17:49:45 发布
阅读量4.5k 收藏 6
点赞数
分类专栏： 综合 文章标签： bootstrap spring mybatis maven angularjs
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/shymi1991/article/details/51985371
版权

半年过去了，为了对得起看过（一）的三百多位朋友和我自己，还是得要把这系列写完。AnyWay，迟做总比不做好。

（上一节：Maven + Spring MVC＋Mybatis + MySQL +AngularJS + Bootstrap 实现前后台交互页面（一）环境搭建）

这一节我们将整合spring、mybatis成功连接数据库并可以进行表的增删改查。

1. 准备所需要的pom依赖

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>com.sommer.sample</groupId>
	<artifactId>webproject</artifactId>
	<packaging>war</packaging>
	<version>0.0.1-SNAPSHOT</version>
	<name>webproject Maven Webapp</name>
	<url>http://maven.apache.org</url>
	<properties>
		<!-- spring版本号 -->
		<spring.version>4.2.4.RELEASE</spring.version>
		<!-- mybatis版本号 -->
		<mybatis.version>3.4.1</mybatis.version>
	</properties>
	<dependencies>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>4.12</version>
			<scope>test</scope>
		</dependency>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.4.1</version>
		</dependency>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.3.0</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-core</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-beans</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<!-- Spring 在 3.2.13版本后，要单独引用 -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-oxm</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-tx</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-web</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>4.2.4.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context-support</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-test</artifactId>
			<version>${spring.version}</version>
		</dependency>
		<!-- java ee (注解什么的都要用到它) -->
		<dependency>
			<groupId>javax</groupId>
			<artifactId>javaee-api</artifactId>
			<version>7.0</version>
		</dependency>
		<!-- dbcp用来在applicationContext.xml中配置数据库 -->
		<dependency>
			<groupId>commons-dbcp</groupId>
			<artifactId>commons-dbcp</artifactId>
			<version>1.4</version>
		</dependency>
		<!-- Mysql数据库链接 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>6.0.2</version>
		</dependency>
		<!-- Spring 4.x 依赖的相关 json jar -->
		<dependency>
			<groupId>com.fasterxml.jackson.core</groupId>
			<artifactId>jackson-databind</artifactId>
			<version>2.5.4</version>
		</dependency>
		<dependency>
			<groupId>com.fasterxml.jackson.core</groupId>
			<artifactId>jackson-core</artifactId>
			<version>2.5.4</version>
		</dependency>
		<dependency>
			<groupId>com.fasterxml.jackson.core</groupId>
			<artifactId>jackson-annotations</artifactId>
			<version>2.5.4</version>
		</dependency>
	</dependencies>
	<build>
		<finalName>webproject</finalName>
	</build>
</project>

2. 配置文件

spring-mvc是web层的配置，我们放到下一节。


2.1 数据库连接配置


为了方便管理和修改，我们将这些信息放在jdbc.properties里面

#database

driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/weibo?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&useSSL=false
jdbc.username=root
jdbc.password=123456
jdbc.maxWait=5000

com.mysql.cj.jdbc.Driver是mysql-connector-java 6.2的新驱动名称，老的是com.mysql.jdbc.Driver。

useUnicode、characterEncoding 指定字符的编码、解码格式； serverTimezone为了让server（tomcat）和mysql的时区同步，不加的话会可能会报下面的错，这是mysql-connector-java 从5.1.33版本后TimeUtil类存在bug。mysql新的安全性设置要求SSL连接，所以加上参数userSSL=false。

Cannot create PoolableConnectionFactory
 (The server time zone value '?й???????' is unrecognized or represents more than one time zone. 
You must configure either the server or JDBC driver
 (via the serverTimezone configuration property) 
to use a more specifc time zone value if you want to utilize time zone support.)


2.2 spring-mybatis整合 

<span style="font-size:14px;"><beans xmlns="http://www.springframework.org/schema/beans"
		xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
		xmlns:aop="http://www.springframework.org/schema/aop"
		xmlns:tx="http://www.springframework.org/schema/tx"
		xmlns:context="http://www.springframework.org/schema/context"
		xsi:schemaLocation="
			http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
			http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.2.xsd
			http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.2.xsd
			http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd">

    <!-- 自动扫描的包 ,将带有注解的类 纳入spring容器管理 -->
    <context:component-scan base-package="com.sommer.sample"></context:component-scan>

    <!-- 引入jdbc配置文件 -->
    <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="locations">
            <list>
                <value>classpath*:conf/jdbc.properties</value>
            </list>
        </property>
    </bean>

    <!-- dataSource 配置 -->
    <bean id="sampleDataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <!-- 基本属性 url、user、password -->
        <property name="driverClassName" value="${driver}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
 		<property name="maxWait" value="${jdbc.maxWait}" />

    </bean>

    <!-- mybatis文件配置，扫描所有mapper文件 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    	<property name="dataSource" ref="sampleDataSource"/>
    	<property name="mapperLocations" value="classpath:mappers/*.xml"/>
    </bean>

    <!-- spring与mybatis整合配置，扫描所有dao -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    	<property name="basePackage" value="com.sommer.sample.dashboard.dao"/>
    	<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
    </bean>

</beans>
</span>

3. Java 代码

Java代码分成实体层entity、数据访问层dao、业务服务层service（又分为接口和实现）和控制层controller。控制层是与前端交互打交道的，可以先不管。



package com.weibo.dashboard.entity;

public class User {
	private int id;
	private String name;
	private String password;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
}

package com.weibo.dashboard.dao;

import org.apache.ibatis.annotations.Param;

import com.weibo.dashboard.entity.User;

public interface UserMapper {
	User select(@Param("name")String name);
	int userNameExits(@Param("name")String name);
	int accountValid(User user);
	int insert(User user);
}

package com.weibo.dashboard.service;

import com.weibo.dashboard.entity.User;

public interface UserService {
	User select(String name);
	int userNameExits(String name);
	boolean accountValid(User user);
	int insert(User user);
}


package com.weibo.dashboard.service.impl;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import com.weibo.dashboard.dao.UserMapper;
import com.weibo.dashboard.entity.User;
import com.weibo.dashboard.service.UserService;

@Service
public class UserServiceImpl implements UserService{

	@Resource
	private UserMapper userMapper;
	
	public User select(String name) {
		return userMapper.select(name);
	}

	public int userNameExits(String name) {
		return userMapper.userNameExits(name);
	}

	public boolean accountValid(User user) {
		return userMapper.accountValid(user)>0;
	}

	public int insert(User user) {
		return userMapper.insert(user);
	}

}

4. SQL映射的xml文件



<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper
	namespace="com.weibo.dashboard.dao.UserMapper">
	<resultMap id="userMap" type="com.weibo.dashboard.entity.User">
		<id property="id" column="id" javaType="int"/>
		<result property="name" column="name" javaType="String"/>
		<result property="password" column="password" javaType="String"/>
	</resultMap>
	<select id="select" resultMap="userMap">
		select * from users
		<where>
			<if test="name!=null">
				and name=#{name}
			</if>
		</where>
	</select>
	<select id="userNameExits" resultType="int">
		select count(0) from users where name=#{name}
	</select>
	<select id="accountValid" parameterType="com.weibo.dashboard.entity.User" resultType="int">
		select count(0) from users where name=#{name} and password=#{password}
	</select>
	<insert id="insert" parameterType="com.weibo.dashboard.entity.User" useGeneratedKeys="true" keyProperty="id">
		insert into users (name, password) values (#{name},#{password})
	</insert>
</mapper>



这里要注意的是映射文件的头部，mybatis的配置文件是： 

<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD  Config 3.0//EN"               
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
...
</configuration>

mapper.xml文件的头部是

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper>
...
</mapper>

 
doctype定义写错的话eclipse一般会提示的。 

 

 

5. 单元测试：
 

 

package webproject;

import javax.annotation.Resource;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import com.weibo.dashboard.entity.User;
import com.weibo.dashboard.service.UserService;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations={"classpath:conf/spring-mybatis.xml"})
public class UserTest {
	@Resource
	UserService us;
	
	@Test
	public void testAdd(){
		User user = new User();
		user.setName("test");
		user.setPassword("testpd");
		int res= us.insert(user);
		System.out.println(res);
	}
	
	@Test
	public void testAccountValid(){
		User user = new User();
		user.setName("test");
		user.setPassword("testpd");
		boolean res = us.accountValid(user);
		System.out.println(res);
	}
	
}

 

 

 

 

 
执行单元测试，打印出 

 

testAdd方法打印出1，表示插入成功；testAccountValid方法打印出true，表示用户账号有效。
 


 
 

同理我们加上posts，comments的插入、删除等功能：
 


 
 

Post.java
 

 

package com.weibo.dashboard.entity;

import java.util.Date;
import java.util.List;

public class Post {
	private int id;
	private Date date;
	private String authorName;
	private String content;
	private int likes;
	private List<Comment> commentList;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public Date getDate() {
		return date;
	}
	public void setDate(Date date) {
		this.date = date;
	}
	
	public String getAuthorName() {
		return authorName;
	}
	public void setAuthorName(String authorName) {
		this.authorName = authorName;
	}
	public String getContent() {
		return content;
	}
	public void setContent(String content) {
		this.content = content;
	}
	public int getLikes() {
		return likes;
	}
	public void setLikes(int likes) {
		this.likes = likes;
	}
	public List<Comment> getCommentList() {
		return commentList;
	}
	public void setCommentList(List<Comment> commentList) {
		this.commentList = commentList;
	}
	
}<span style="color:#006600;"><strong><span style="font-size: 18px;">
</span></strong></span>
 
PostMapper.java 

 

 

package com.weibo.dashboard.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.weibo.dashboard.entity.Post;

public interface PostMapper {
	List<Post> findList();
	List<Post> postByUser(@Param("userName") String userName);
	int insert(Post post);
	int delete(@Param("id") int id);
	int like(@Param("id") int id);
	int dislike(@Param("id") int id);
	
}
 

 


 PostService.java
 
 

 

package com.weibo.dashboard.service;

import java.util.List;

import com.weibo.dashboard.entity.Post;

public interface PostService {
	List<Post> findList();

	List<Post> postByUser(String userName);

	int insert(Post post);

	int delete(int id);

	int like(int id);

	int dislike(int id);
}<span style="color:#006600;">
</span>
 

  

 
PostServiceImpl.java 

 

package com.weibo.dashboard.service.impl;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import com.weibo.dashboard.dao.PostMapper;
import com.weibo.dashboard.entity.Post;
import com.weibo.dashboard.service.PostService;
@Service
public class PostServiceImpl implements PostService{

	@Resource
	PostMapper postMapper;
	
	public List<Post> findList() {
		return postMapper.findList();
	}

	public List<Post> postByUser(String userName) {
		return postMapper.postByUser(userName);
	}

	public int insert(Post post) {
		return postMapper.insert(post);
	}

	public int delete(int id) {
		return postMapper.delete(id);
	}

	public int like(int id) {
		return postMapper.like(id);
	}

	public int dislike(int id) {
		return postMapper.dislike(id);
	}

}
 

 

 

postMapper.xml
 

 

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.weibo.dashboard.dao.PostMapper">
	<resultMap id="postMap" type="com.weibo.dashboard.entity.Post">
		<id property="id" column="id" javaType="int"/>
		<result property="date" column="date" javaType="Date"/>
		<result property="authorName" column="author_name" javaType="String"/>
		<result property="content" column="content" javaType="String"/>
		<result property="likes" column="likes" javaType="int"/>
		<collection property="commentList" column="commentList" ofType="com.weibo.dashboard.entity.Comment">
			<result property="cDate" column="c_date" javaType="Date"/>
			<result property="cContent" column="c_content" javaType="String"/>
			<result property="cAuthorName" column="c_author_name" javaType="String"/>
		</collection>
	</resultMap>
	<select id="findList" resultMap="postMap">
		select * from posts left outer join comments on post_id = posts.id order by posts.date desc
	</select>
	<select id="postByUser" resultMap="postMap">
		select * from posts,comments where post_id = posts.id and posts.author_name = #{userName} order by posts.date desc
	</select>
	<insert id="insert" parameterType="com.weibo.dashboard.entity.Post" useGeneratedKeys="true" keyProperty="id">
		insert into posts
		(date,author_name,content)values
		(now(),#{authorName},#{content})
	</insert>
	<delete id="delete">
		delete from posts where id=#{id}
	</delete>
	<update id="like">
		update posts set likes=IF(likes IS NULL, 1,likes+1) where id=#{id}
	</update>
	<update id="dislike">
		update posts set likes=IF(likes >0, likes-1,0) where id=#{id}
	</update>
</mapper>
 

 


 
 
Comment.java 

 

package com.weibo.dashboard.entity;

import java.util.Date;

public class Comment {
	private int id;
	private Date cDate;
	private String cContent;
	private String cAuthorName;
	private int postId;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public Date getcDate() {
		return cDate;
	}
	public void setcDate(Date cDate) {
		this.cDate = cDate;
	}
	public String getcContent() {
		return cContent;
	}
	public void setcContent(String cContent) {
		this.cContent = cContent;
	}
	public String getcAuthorName() {
		return cAuthorName;
	}
	public void setcAuthorName(String cAuthorName) {
		this.cAuthorName = cAuthorName;
	}
	public int getPostId() {
		return postId;
	}
	public void setPostId(int postId) {
		this.postId = postId;
	}

}<span style="color:#009900;"><span style="font-size: 18px;">
</span></span>
 

 

 
CommentMapper.java 

 

 


 
 

public interface CommentMapper {
<span style="white-space:pre">	</span>
<span style="white-space:pre">	</span>int insert(Comment comment);
<span style="white-space:pre">	</span>int delete(@Param("id") int id);
<span style="white-space:pre">	</span>
}
 

 
CommentService.java 

 

package com.weibo.dashboard.service;

import com.weibo.dashboard.entity.Comment;

public interface CommentService {
	
	int insert(Comment comment);
	int delete(int id);
}

 

 
CommentServiceImpl.java 

 

 

package com.weibo.dashboard.service.impl;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import com.weibo.dashboard.dao.CommentMapper;
import com.weibo.dashboard.entity.Comment;
import com.weibo.dashboard.service.CommentService;
@Service
public class CommentServiceImpl implements CommentService{

	@Resource
	CommentMapper commentMapper;
	public int insert(Comment comment) {
		return commentMapper.insert(comment);
	}

	public int delete(int id) {
		return commentMapper.delete(id);
	}

}
 

 


 commentMapper.xml
 

 

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.weibo.dashboard.dao.CommentMapper">
	<resultMap id="commentMap" type="com.weibo.dashboard.entity.Comment">
		<id property="id" column="id" javaType="int" />
		<result property="cDate" column="c_date" javaType="Date" />
		<result property="cContent" column="c_content" javaType="String" />
		<result property="cAuthorName" column="c_author_name" javaType="String" />
		<result property="postId" column="post_id" javaType="String" />
	</resultMap>
	
	<insert id="insert" parameterType="com.weibo.dashboard.entity.Comment" useGeneratedKeys="true" keyProperty="id">
		insert into comments
		(c_date,c_author_name,post_id,c_content)values
		(now(),#{cAuthorName},#{postId},#{cContent})
	</insert>
	<delete id="delete">
		delete from comments where id=#{id}
	</delete>
	
</mapper>
 

 

 


 
 

下一节将使用SpringMVC实现前后台交互。
 

http://blog.csdn.net/shymi1991/article/details/52563870
 
 


 

                

        

        

    




    

      

        

            

              
                
                  Sommer_Xia
                
              
            

            

                关注
              
            

        

        

          
    
            
  • 
              
                
                
                
                
                      0
                
              
              
    点赞
    
            
    • 
            
  • 
              
                
                
                
              
              
    踩
    
            
    • 
            
  • 
              
                
                
                
                
                    6
                
              
              
    
                
    
                  
                    收藏
                  
                
    
              
    
              
    
                
    
                  觉得还不错?
                  
                    一键收藏
                  
                 
                
    
              
    
            
    • 
          
  • 
            
    
              
              
            
    
              
              
              
                    0
              
            
            
    评论
    
          
    • 
          
  • 
          
    • 
          
  • 
            
              
            
              
    
            
              
                
            
    
          
    • 
        

      

      

            

                专栏目录
          










                



	

		

			

				
					
Cannot create PoolableConnectionFactory (......)

				
			

			

				

					comfortable_z的博客
				

				

					06-09
					
					1773
					
				

			

		

		

			
				
解决Cannot create PoolableConnectionFactory (......)

			
		

	



                

              
                



	

		

			

				
					
spring4 MVC +maven + mysql数据库 + mybatis+根据后台json前台动态生成table

				
			

			

				

					01-05
				

			

		

		

			
				
在本项目中，我们主要探讨的是如何利用Spring4 MVC、Maven、MySQL数据库、MyBatis框架以及前端JSON数据来动态生成表格。这是一个常见的Web应用开发模式，它可以帮助开发者快速构建数据驱动的Web应用程序。  首先，...

			
		

	



                


  
              

                


	

		

			

				
					
spring学习bug记录：Cannot create PoolableConnectionFactory (The server time zone value 'Öйú±ê׼ʱ¼ä'...

				
			

			

				

					刘甜的博客
				

				

					05-10
					
					802
					
				

			

		

		

			
				
Q：


Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone. Yo...

			
		

	





	

		

			

				
					
spring boot连接Mybatis数据库的配置文件(MySql、SQLserver、Oracle)

				
			

			

				

					lydms的博客
				

				

					05-29
					
					3013
					
				

			

		

		

			
				
一、MySql连接数据库
1、pom依赖
<!--mybatis配置-->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.0.1</version>
</dependency>

&lt

			
		

	



		

			
		



	

		

			

				
					
Jmeter连接mysql数据报“Cannot create PoolableConnectionFactory (The server time zone value '?”

				
			

			

				

					qq19970496的博客
				

				

					09-17
					
					3988
					
				

			

		

		

			
				
Jmeter连接Mysql数据库报
“Cannot create PoolableConnectionFactory (The server time zone value ‘?��???’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driv...

			
		

	





	

		

			

				
					
spring+spring mvc+mybatis+bootstrap+jquery+Mysql运动会管理系统源码

				
			

			

				

					06-28
				

			

		

		

			
				
这是一个基于Java技术栈的运动会管理系统源码，使用了Spring、Spring MVC、MyBatis、Bootstrap、jQuery和MySQL数据库。下面将详细介绍这套系统的核心技术和组成部分。  首先，Spring框架是整个系统的基石，它提供了...

			
		

	





	

		

			

				
					
ssm(spring+spring mvc+mybatis)+bootstrap开发预警后台管理系统

				
			

			

				

					06-14
				

			

		

		

			
				
自己花5天时间写的，带分页查询 模糊查询 按时间查询 js验证手机 验证身份 验证姓名，  ... 运行环境  jdk7+tomcat7+mysql+eclipse+maven  项目技术(必填) ...spring+spring mvc+mybatis+bootstrap+jquery+jsp

			
		

	





	

		

			

				
					
Spring+SpringMVC+Mybatis+Maven+bootstrap+ajax+jQuery整合开发简单的员工后台管理系统

				
			

			

				

					05-08
				

			

		

		

			
				
在本项目中，"Spring+SpringMVC+Mybatis+Maven+bootstrap+ajax+jQuery整合开发简单的员工后台管理系统"，我们看到一个基于Java技术栈的Web应用开发实例。这个系统利用了多个核心技术来构建一个功能完备的员工管理...

			
		

	





	

		

			

				
					
spring boot+mybatis+spring mvc+bootstrap开发停车位管理系统

				
			

			

				

					06-15
				

			

		

		

			
				
项目描述  随着时代和科技的进步，人们的生活水平越来越高，私家车的数量不断上涨，随之产生了一些问题，其中就包括停车难，很多地方人们根本...spring+spring mvc+mybatis+bootstrap+jquery+html+springboot+thymeleaf

			
		

	





	

		

			

				
					
springmvc+mybatis+mysql+angularjs+bootstrap

				
			

			

				

					02-28
				

			

		

		

			
				
springmvc+mybatis+mysql+angularjs+bootstrap实例项目

			
		

	





	

		

			

				
					
J2EE spring mvc mybatis bootstrap HTML5 后台框架 控制台 mysql版本_spring3.0

				
			

			

				

					04-01
				

			

		

		

			
				
【源码】mysql版本_spring3.0 系统模块 1. 组织管理：角色管理，分角色组和成员，有组权限和成员权限。 2. 系统用户：对各个基本的组会员增删改查，单发、群发邮件短信，导入导出excel表格，批量删除 3. 会员管理：对前台用户管理，分配会员级别，到期时间，状态，联系信息等资料 4. 菜单管理：增删改查菜单 ztree（自定义菜单）业务菜单和系统菜单分离 5. 数据字典：无限级别，支持多级别无限分类。内设编号，排序等 6. 系统设置：修改系统名称，邮件服务器配置，短信账号设置，图片水印配置，微信配置 7. 代码生成：打开代码生成器模块 8. 图库管理：对批量上传的图片统一管理 9. 性能监控：监控整个系统的性能，SQL监控，SQL防火墙，URL监控，SPRING监控，SESSION监控等 10. 接口测试：POST or GET 方式检测系统接口，参数加密，json返回结果，计算服务器响应时间 11. 发送邮件：单发，群发邮件 12. 置二维码：生成 or 解析二维码 13.地图工具：经纬度操作 14.即时通讯：打开即时聊天窗口 技术点 1. 导出 导入 excel 文件 2 导出word文件 3. IO 流上传下载文件 4. 群发邮件，可以发html、纯文本格式，可以发给任意邮箱(实现批量发送广告邮件) 5. 群发or单独 发送短信，支持两种第三方短信商接口 6. spring aop 事物处理 7. 代码生成器 (freemarker)， 代码 zip 压缩打包 8. MD5加密 SHA加密（登录密码用此加密） 9. 数据库连接池 阿里的 druid。Druid在监控、可扩展性、稳定性和性能方面都有明显的优势,支持并发 10.加入安全框架 shiro (登录授权)(session管理) 11.根据汉字 解析汉字的全拼(拼音)和首字母(导入excel到用户表，根据用户的汉字姓名生成拼音的用户名) 12.app接口（支持与其它语言数据交互） 12.极光推送 (推送给APP及时消息，APP不启动也能收到) 14.微信接口(身份验证，文本、图文回复等) 微信远程控制服务器重启、锁定、其它应用程序 15.java Quartz 定时器 （定时执行某程序，精确到秒，可设置周期） 16.java websocket 即时通讯技术，点对点，群聊，单聊，EXT4对话框 17.新增Lucene全文检索 18.Base64传输图片 19.图片加水印(图片水印，文字水印） 20.生成 or 解析 二维码 21.HTML5 + JAVAEE WebSocket 通信技术 22.批量异步上传图片，可预览，有进度条，支持拖拽上传(百度webuploader )。列表动态滑动放大展示。 23.ehcache 自定义二级缓存 ，选择缓存存放目录，处理并发，增加系统性能 24.服务器内部GET POST 请求 25.uploadify 上传插件，单条、批量上传，带进度条，异步，图片、视频, 其它文件格式均可上传 26.地图选点获取经纬度坐标，根据俩经纬度计算距离

			
		

	





	

		

			

				
					
maven spring  springmvc mybatis bootstrap oracle  整合项目

				
			

			

				

					06-19
				

			

		

		

			
				
maven spring  springmvc mybatis bootstrap oracle  整合项目

			
		

	





	

		

			

				
					
Spring、SpringMVC、Mybatis、BootStrap、Mysql、Maven、Eclipse增删改查

				
			

			

				

					06-04
				

			

		

		

			
				
Spring、SpringMVC、Mybatis、BootStrap、Mysql、Maven、Eclipse增删改查

			
		

	





	

		

			

				
					
SSM框架整合maven项目ssm源码 Spring+SpringMVC+Mybatis+Bootstrap shardingjdbc

				
			

			

				

					03-13
				

			

		

		

			
				
绝对可以直接用，SSM框架整合，maven项目ssm源码 Spring+SpringMVC+Mybatis+Bootstrap shardingjdbc

			
		

	





	

		

			

				
					
JAVA Maven Spring Boot Mybatis bootstrap增删改查分页实战

				
			

			

				

					11-30
				

			

		

		

			
				
JAVA Maven3.5.2 Spring Boot1.3.0 Mybatis3.2.8 bootstrap3.3.7 Mysql5.1.4 pageHelp4.1.6增删改查分页实战

			
		

	





	

		

			

				
					
SpringMVC + Angularjs

				
			

			

				

					u010381707的专栏
				

				

					11-09
					
					6508
					
				

			

		

		

			
				
本博客将展示使用AngularJS和Spring MVC4，我们将创建一个增删查改的应用。前端使用AngularJS，后端使用Spring REST API。AngularJS使用$http服务和后端进行异步通信，同时使用AngularJS进行表单验证。

			
		

	





	

		

			

				
					
jmeter JDBC Request发送select出现报错Cannot create PoolableConnectionFactory (The server time zone value '

				
			

			

				

					qq_27213989的博客
				

				

					06-21
					
					4935
					
				

			

		

		

			
				
报错：Cannot create PoolableConnectionFactory (The server time zone value 'CST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverT...

			
		

	





	

		

			

				
					
pan baidu 基于spring+springmvc+mybatis博客系统的开发教程

					
最新发布

				
			

			

				

					10-10
				

			

		

		

			
				
接下来，创建一个新的Maven项目，并在pom.xml文件中添加依赖项，包括Spring MVC、MyBatis、数据库连接池、日志等。这些依赖项可以通过Maven自动下载和管理。  然后，在src/main/java目录下创建相应的包结构，如...

			
		

	



              



  
“相关推荐”对你有帮助么？

  

      
    
          
  • 
              
    
                  
                  
              
    
              
    非常没帮助
    
          
    • 
          
  • 
              
    
                  
                  
              
    
              
    没帮助
    
          
    • 
          
  • 
              
    
                  
                  
              
    
              
    一般
    
          
    • 
          
  • 
              
    
                  
                  
              
    
              
    有帮助
    
          
    • 
          
  • 
              
    
                  
                  
              
    
              
    非常有帮助
    
          
    • 
      

      

      

          
          提交
      

      

  




          




        



    





    



      

      

        
      

      





	

		评论	
	

	
	




  

    

      添加红包
      
    

    

      

        
        

          
          
        

        
请填写红包祝福语或标题

      

      

        
        

          
          个
        

        
红包个数最小为10个

      

      

        
        

          
          元
        

        
红包金额最低5元

      

      

        
        

          当前余额3.43元
          前往充值 >
        

      

      

        

          需支付：10.00元
        

        
        
      

    

  





  

    
    
  

  

    
    
  








  

    

      

        

          

            
            
成就一亿技术人!

          

          

        

        

          

          

            领取后你会自动成为博主和红包主的粉丝
            规则
          

        

      

      

        

          

            
              
            
            

              
hope_wisdom
 发出的红包
            

          

        

        

          

          

          

        

      

    

    

  



      
      

      
实付元

      
使用余额支付

      

        

          

            
            点击重新获取
          

        

        
扫码支付

      

      

        
          
            
          
          
        
      

      

        
        钱包余额
          0
          

            
            

              

                
抵扣说明：

                
 1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
 2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

              

            

          

      

      余额充值