如何让window服务进程中自动加载MYSQL服务

如何让MYSQL服务进程中自动加载MYSQL

1.在 开始－－》运行中执行 c:/mysql/bin/mysqld-nt -install (卸载时执行-uninstall)

2.把c:/mysql/my-medium.ini改名为my.ini并修改里面的相关配置拷到c:/winnt 或c:/winnts c:/windows 下

3.然后在开始－－》运行 中执行 net start|stop|restart mysql

加入MySQL数据库和JPA。

配置:

pom.xml文件

[html] view plain copy

<!-- 添加Mysql和JPA-->

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-data-jpa</artifactId>

</dependency>

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

</dependency>

在Application.properties(在resource文件夹下新建，进行配置)文件中添加数据进行配置：

[html] view plain copy

spring.datasource.url = jdbc:mysql://localhost:3306/spring_boot

spring.datasource.username = root

spring.datasource.password = root

spring.datasource.driverClassName = com.mysql.jdbc.Driver

# Specify the DBMS

spring.jpa.database = MYSQL

# Show or not log for each sql query

spring.jpa.show-sql = true

# Hibernate ddl auto (create, create-drop, update)

spring.jpa.hibernate.ddl-auto = update

# Naming strategy

spring.jpa.hibernate.naming-strategy = org.hibernate.cfg.ImprovedNamingStrategy

# stripped before adding them to the entity manager)

spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect

User类

[java] view plain copy

package com.seawater.bean

import javax.persistence.*

import javax.validation.constraints.NotNull

/**

* Created by zhouhs on 2016/12/30.

*/

@Entity

@Table(name = "user")

public class User {

@Id

@GeneratedValue(strategy = GenerationType.AUTO)

private Long id

private String name

private int age

public Long getId() {

return id

}

public void setId(Long id) {

this.id = id

}

public String getName() {

return name

}

public void setName(String name) {

this.name = name

}

public int getAge() {

return age

}

public void setAge(int age) {

this.age = age

}

}

UserController

[java] view plain copy

package com.seawater.controller

import com.seawater.Dao.UserDao

import com.seawater.bean.User

import io.swagger.annotations.Api

import io.swagger.annotations.ApiImplicitParam

import io.swagger.annotations.ApiImplicitParams

import io.swagger.annotations.ApiOperation

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

import org.springframework.web.bind.annotation.RequestMethod

import org.springframework.web.bind.annotation.RequestParam

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

import javax.annotation.Resource

/**

* Created by zhouhs on 2016/12/30.

*/

@RestController

@RequestMapping(value = "/user")

@Api(description = "用户")

public class UserController {

@Resource

UserDao userDAO

@ApiOperation(value = "添加用户")

@ApiImplicitParams({

@ApiImplicitParam(name = "name" , value = "name" , paramType = "query" , required = true ),

@ApiImplicitParam(name = "age" , value = "age" , paramType = "query" , required = true )

})

@RequestMapping(value = "/addUser" , method = RequestMethod.POST)

public String addUser(@RequestParam(value = "name") String name,@RequestParam(value = "age") int age){

User user = new User()

user.setName(name)

user.setAge(age)

userDAO.save(user)

return "add user success !"

}

@ApiOperation(value = "查找用户")

@ApiImplicitParam(name = "id" , value = "id" , paramType = "query" , required = true , dataType = "int")

@RequestMapping(value = "/findById" , method = RequestMethod.POST)

public String findById(@RequestParam(value = "id") Long id){

User user = userDAO.findById(id)

if(user == null){

return "error"

}else{

return "name:" + user.getName() + " , age:" + user.getAge()

}

}

@ApiOperation(value = "查询所有用户")

@RequestMapping(value = "/findAll" , method = RequestMethod.POST)

public Iterable findAll(){

Iterable<User>userList = userDAO.findAll()

return userList

}

@ApiOperation(value = "删除用户")

@ApiImplicitParam(name = "id" , value = "id" , paramType = "query" , required = true , dataType = "int")

@RequestMapping(value = "/deleteById" , method = RequestMethod.POST)

public String deleteById(@RequestParam(value = "id") Long id){

userDAO.delete(id)

return "delete success !"

}

}

数据表(id定义为Integer)：

UserDao:

[java] view plain copy

package com.seawater.Dao

import com.seawater.bean.User

import org.springframework.data.repository.CrudRepository

/**

* Created by zhouhs on 2016/12/30.

*/

public interface UserDao extends CrudRepository<User, Long>{

public User findById(Long id)

}

然后启动项目：访问http://localhost:8081/swagger-ui.html

结果：

方法我就不一一 *** 作了。

收集了几条对策，希望对你能有所帮助：

1.在PHP.IHI中打开MYSQL.DLL的加载项

自5开始.默认不再打开MYSQL.DLL了

2.php5ts.dll要复制到windows目录下

3.修改php.ini文件

除了要除去extension=php_mysql.dll的注释符外还要添加extension=php_mysqli.dll项，PHP5中连接MySQL需要添加mysqli这个扩展！

4.libmysql.dll拷到system32下

5.

5.1.在你的php.ini中设定你的extensions的路径：如e:/php5/ext/

5.2.将php_mysql.dll复制到上面给定的目录。

5.3.将php5目录下的libmysql.dll复制到win/system/如果你以apache的方式加载php也可以把该文件放在apache目录。

5.4.重新启动apache或iis

还有很多建议在下面的网址里，找找看吧

祝你好运

---