Vgbhfive's Blog

java.sql.SQLException: 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.

org.springframework.beans.factory.BeanCreationException: 
Error creating bean with name 'persistenceExceptionTranslationPostProcessor' defined in class path resource [org/springframework/boot/autoconfigure/dao/PersistenceExceptionTranslationAutoConfiguration.class]: Initialization of bean failed; 
nested exception is java.lang.IllegalStateException: 
No persistence exception translators found in bean factory. 
Cannot perform exception translation.

$ git config --global user.name "YOUR USERNAME"
$ git config --global user.email "YOUR EMAIL"

import java.util.*;
import java.math.*;

//寻找阿姆斯特朗数
public class LookforNumber
{   

    public Scanner scanner = new Scanner(System.in);

    public static void main(String[] args){
        LookforNumber ln = new LookforNumber();
        ln.number();
    }

    public void number(){//计算三位，四位，五位的阿姆斯特朗数
        System.out.println("这是在求阿姆斯特朗数(n=3时，为水仙花数):");
        System.out.println("请输入要求数的位数:");
        int n = scanner.nextInt();
        int a=0,b=0,c=0,d=0,e=0;
        int x = (int)Math.pow(10,n-1);
        int y = (int)Math.pow(10,n);
        for(;x<y;x++){
            for(int z=1;z<=n;z++){
                switch(z){
                    case 1 : a = x/(int)Math.pow(10,n-z);break;
                    case 2 : b = x/(int)Math.pow(10,n-z)%10;break;
                    case 3 : c = x/(int)Math.pow(10,n-z)%10;break;
                    case 4 : d = x/(int)Math.pow(10,n-z)%10;break;
                    case 5 : e = x/(int)Math.pow(10,n-z)%10;break;
                    default : break;
                }
            }
            if(x == (int)Math.pow(a,n)+(int)Math.pow(b,n)+(int)Math.pow(c,n)
                +(int)Math.pow(d,n)+(int)Math.pow(e,n)){
                System.out.print(x + " ");
            }
        }
        System.out.println();
        System.out.println("上述都是阿姆斯特朗数。");
    }
}

spring-boot-starter-data-jpa
mysql-connector-java

#数据库使用的驱动类
hibernate.connection.driver_class=com.mysql.jdbc.Driver
#数据库连接地址
hibernate.connection.url=jdbc:mysql://localhost:3306/db
#数据库连接的用户名
hibernate.connection.username=user
#数据库连接的密码
hibernate.connection.password=password
#使用JNDI数据源连接数据库 -> 请看下一个JNDI配置
hibernate.connection.datasource=java:comp/env/jdbc/TestDb
#数据库使用的方言，将操作转为对应的SQL语句
hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect
#是否打印SQL语句
hibernate.show_sql=true
javax.persistence.validation.mode=none
#在 log 和 console 中打印出更漂亮的 SQL语句
hibernate.format_sql=true
#设置在Hibernate数据库连接池中的连接数量，这里我们一般使用c3p0连接池
hibernate.connection.pool_size=3