Springboot+hibernate 操作原生sql语句实现建表，插入数据和查询数据

一开始是一个例子（前台到后台），上传数据新建数据表以及插入数据，如果不需要，可直接拉到最后看关键代码和简要代码

先看配置文件 

spring:
  datasource:
    url: （你的数据库地址）
    username: （用户名）
    password: （密码）
    driver-class-name: com.mysql.jdbc.Driver
  jpa:
    show-sql: true
    hibernate:
      ddl-auto: update
    properties:
      hibernate:
        current_session_context_class: org.springframework.orm.hibernate5.SpringSessionContext

package com.mlcp.config;

import javax.persistence.EntityManagerFactory;

import org.hibernate.SessionFactory;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;

@Configuration
@EnableAutoConfiguration
@EnableTransactionManagement
public class HibernateAutoConfiguration {
	@Bean
	public SessionFactory sessionFactory(EntityManagerFactory factory) {
		if (factory.unwrap(SessionFactory.class) == null) {
			throw new NullPointerException("factory is not a hibernate factory");
		}
		return factory.unwrap(SessionFactory.class);
	}

}

前台Html

这里我是创建表，并且上传csv的数据

<form action="tableactive/submitTable" method="post" id="nextSave">
			<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
				<div class="modal-dialog" role="document">
					<div class="modal-content">
						<div class="modal-header">
							<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
							<h4 class="modal-title" id="myModalLabel">创建表</h4>
						</div>
						<div class="modal-body">

							<p>表名</p>
							<div class="input-group input-group-sm">
								<input type="text" class="form-control" placeholder="请输入表名" aria-describedby="sizing-addon3" style="width:565px;" name="tableName">
							</div>

							<p style="margin-top:15px">保存时长(天)</p>
							<div class="input-group input-group-sm">
								<input name="activeTime" type="text" class="form-control" placeholder="请输入保存时长" aria-describedby="sizing-addon3" style="width:565px;" οnkeyup="if(this.value.length==1){this.value=this.value.replace(/[^1-9]/g,'')}else{this.value=this.value.replace(/\D/g,'')}" onafterpaste="if(this.value.length==1){this.value=this.value.replace(/[^1-9]/g,'0')}else{this.value=this.value.replace(/\D/g,'')}">
							</div>

							<p style="margin-top:15px">表结构</p>
							<a class="glyphicon glyphicon-plus-sign" οnclick="addrow()">添加一行</a>
							<table class="table table-bordered" id="tablestru">
								<tr>
									<td>列名</td>
									<td>类型</td>
									<td></td>
									<tr>
							</table>
						</div>
						<div class="modal-footer">
							<button type="button" class="btn btn-primary" οnclick="nextMyModal()">下一步</button>
							<button type="button" class="btn btn-default" data-dismiss="modal">关闭</button>
						</div>
					</div>
				</div>
			</div>

			<div class="modal fade" id="myModal2" tabindex="-1" role="dialog" aria-labelledby="myModalLabel">
				<div class="modal-dialog" role="document">
					<div class="modal-content">
						<div class="modal-header">
							<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></butto