Sroing boot访问postgresql数据库

1. 配置pom.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<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/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>

	<groupId>com.example</groupId>
	<artifactId>demo-1</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>

	<name>demo-1</name>
	<description>Demo project for Spring Boot</description>

	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>1.5.6.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
		<java.version>1.8</java.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
		
		<dependency>
  			<groupId>postgresql</groupId>
  			<artifactId>postgresql</artifactId>
  			<version>9.1-901-1.jdbc4</version>
		</dependency>
		<dependency>
  			<groupId>org.postgresql</groupId>
  			<artifactId>postgresql</artifactId>
  			<scope>runtime</scope>
		</dependency>
		<dependency>
  			<groupId>org.springframework.boot</groupId>
 			 <artifactId>spring-boot-starter-jdbc</artifactId>
		</dependency>
		<dependency>
  			<groupId>org.springframework.boot</groupId>
 			 <artifactId>spring-boot-starter-data-jpa</artifactId>
		</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
	</build>


</project>

2. application.properties

spring.datasource.url=jdbc:postgresql://localhost:5432/postgres
spring.datasource.username=postgres
spring.datasource.password=123456
spring.datasource.driverClassName=org.postgresql.Driver
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
spring.jpa.properties.hibernate.hbm2ddl.auto=update

3. 实体类

package com.example.model;

import javax.persistence.Entity;
import javax.persistence.Id;

@Entity
public class User1 {
	
	@Id
	private Integer id;
	String name;
	
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	
	

}

4. DAO

package com.example.respositroy;

import org.springframework.data.jpa.repository.JpaRepository;

import com.example.model.User1;

public interface UserRepository extends JpaRepository<User1, Integer>{

}

5 Controller

package com.example.controller;

import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.example.model.Student;
import com.example.model.User1;
import com.example.respositroy.StudentRespositroy;
import com.example.respositroy.UserRepository;

@RestController
public class LoginController {

	@Autowired
	StudentRespositroy studentRepository;
	
	@Autowired
	UserRepository userRepository;
	
	@RequestMapping("/")
    public String home() {
        return "index";
    }
	
	@RequestMapping(value="/testdb")
	public List<Student> stuList(){
		return studentRepository.findAll();
	}
	
	@RequestMapping(value="/user")
	public List<User1> userList(){
		return userRepository.findAll();
	}
//    public String testDataBase(Map<String, Object> model){
//        //Long id = (long) 1;
//        Student stu = studentRepository.findStudentById(id);
//        model.put("student", stu);
//        return "testDataBase";
//    }
}

注：不要用数据库关键字定义表名或字段名（如 user）