怎样加载mysql数据库驱动程序？

1,首先写个方法package utilimport java.sql.Connection

import java.sql.DriverManager

import java.sql.SQLExceptionpublic class DBUtil { static String jdbcURL = "jdbc:mysql://localhost:3306/book"

static String jdbcDriver = "com.mysql.jdbc.Driver"

static String userName = "root"

static String password = "root"

/**

* 获取数据库连接对象

* @return 数据库连接对象

* @throws ClassNotFoundException

* @throws SQLException

*/

public static Connection getConnection() throws ClassNotFoundException,

SQLException {

Class.forName(jdbcDriver)

return DriverManager.getConnection(jdbcURL, userName, password)

}

} 2。项目名==>右键==>build path==>add external archivers.... 选择你mysql驱动 添加进去就ok了

安装与配置php

1.解压修改目录为php

php.ini-disk 改名为php.ini 复制至c盘windows下

2.设置环境变量

PHP_HOME=C:\PHPC:\PHP\ext

----------------------------------------------------------------

配置Apache使之支持PHP

1.配置Apache加载PHP模块

打开配置文件httpd.conf查找LoadModule字样的信息，在其最下方添加一行信息

LoadModule php5_module C:\PHP\php5apache2_2.dll

2.使Apache解析PHP文件

查找AddType在最下方添加如下几行信息

AddType application/x-httpd-php .php

PHPIniDir "C:\lamp\php5"//指定php.ini配置文件所在目录，默认在C:\Windows下

注意：在.php之前有个空格

-------------------------------------------------------------

配置PHP使之支持MySQL

1.设置php.ini里的extension_dir = "C:\php\ext"

2.将C:\PHP\libmysql.dll拷贝到C:\WINDOWS\system32

3.将C:\PHP\ext\php_mysql.dll拷贝到C:\WINDOWS\system32

4.修改C:\Windows\下的php.ini,去掉extension=php_mysql.dll之前的分号""

---------------------------------------------------------------------------------------------------------

修改80端口 打开配置文件httpd.conf，查找 Listen 80 修改

--------------------------------------------------------------------------------------------

配置phpmyadmin

1.解压phpmyadmin到htdocs目录中，例如htdocs\phpmyadmin。

2.打开phpmyadmin目录，在此目录下是否有config.sample.inc.php文件，如果存在，那么将其改名为 config.inc.php。（根据版本不同，有可能直接就有config.inc.php文件，那就无需改名，也有可能根本就没有 config.sample.inc.php或者config.inc.php，那我们就到phpmyadmin\libraries目录下将 config.default.php复制到phpmyadmin目录下并改名为config.inc.php）。

3.打开config.inc.php文件(可以用写字板)，找到$cfg['blowfish_secret'] = ''与$cfg['Servers'][$i]['auth_type'] = 'cookie'，如果$cfg['Servers'][$i]['auth_type']的值就像前面看到的那样为cookie的话，那么我们必须在$cfg['blowfish_secret'] = ''的引号中任意写入一串字符，大家可以把它理解为一个身份验证码。比如$cfg['blowfish_secret'] = 'sunec'。存盘退出。

至此，phpmyadmin的安装配置工作就结束了，进入浏览器，在地址栏输入http://localhost/phpmyadmin /main.php，(这里的路径是根据先前你将phpmyadmin解压在htdocs的目录名决定的)，顺利的话，页面上应该出现让你输入用户名密码的画面了，输入用户名密码（Mysql的用户名密码），随即进入phpmyadmin的主界面。

加入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

结果：

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

---