jpa将数据库表数据生成新增语句，查询字段，查询注释，查询表字段

@Override
public void signForm(HttpServletResponse response, Map map) {
    try{
        String substring = url.substring(0, url.indexOf("?"));
        String substring1 ="'"+ substring.substring(substring.lastIndexOf("/")+1)+"'";
        response.setContentType("application/octet-stream");
        response.setHeader("Content-Disposition", "attachment;filename="+new String((System.currentTimeMillis()+".sql").getBytes("utf-8"),"ISO-8859-1"));
        OutputStream out = response.getOutputStream();
        String name=map.get("name").toString();
        String sql0="SHOW CREATE TABLE "+name;
        Query query0 = entityManager.createNativeQuery(sql0);
        List resultList2 = query0.getResultList();
        String s1 = JSON.parseArray(JSON.toJSONString(resultList2.get(0)), String.class).get(1)+";";
        out.write((s1+System.getProperty("line.separator")).getBytes());
        String sql="SELECT table_name, COLUMN_NAME dbName, DATA_TYPE dbType, COLUMN_COMMENT label FROM INFORMATION_SCHEMA.COLUMNS where table_name=" + "'"+name+"'" + "AND table_schema="+substring1;
        Query query = entityManager.createNativeQuery(sql);
        List resultList = query.getResultList();
        String insetSql="insert into "+name+" (";
        String sql2="SELECT ";
        for (Object map1:resultList){
            List strings = JSON.parseArray(JSON.toJSONString(map1), String.class);
            String s = strings.get(2);
            String sd = "`" + strings.get(1) + "`,";
            if(s.contains("int")){
                sql2+="(`" + strings.get(1) + "`+0) "+strings.get(1)+",";
            }else{
                sql2+=sd;
            }
            insetSql+=sd;
        }
        insetSql=insetSql.substring(0,insetSql.length()-1);
        sql2=sql2.substring(0,sql2.length()-1);
        insetSql+=" )values";
        sql2+=" FROM "+name;
        Query query2 = entityManager.createNativeQuery(sql2);
        query2.unwrap(SQLQuery.class).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
        List> resultList1 = query2.getResultList();
        for (Map map1 :resultList1){
            String insetSql2=insetSql;
            insetSql2+="  ( ";
            for (Object map2:resultList){
                String s = JSON.parseArray(JSON.toJSONString(map2), String.class).get(1);
                String type = JSON.parseArray(JSON.toJSONString(map2), String.class).get(2);
                if(type.contains("int")||type.equals("Integer")||map1.get(s)==null){
                    insetSql2+=map1.get(s)+",";
                }else{
                    insetSql2+="'"+map1.get(s)+"',";
                }
            }
            insetSql2=insetSql2.substring(0,insetSql2.length()-1)+");";
            out.write((insetSql2+System.getProperty("line.separator")).getBytes());
        }
        out.flush();
        out.close();
    }catch (Exception e){
    }
}
						  
					  
						
							


						

							
							
			jpa							
						



						

						
						


						

						
					
					

					
					

						
相关

						

				
						
			

																
								

										
jdbc,jpa,springjdbc，springdatajpa,mybatis之间的区别

									
									

								 

        

								

							
							

																
								

										
jpa实现级联操作

									
									

								 

        

								

							
							

																
								

										
jpa删除数据错误No EntityManager with actual transaction available for current th

									
									

								 

        

								

							
							

																
								

										
SpringData JPA之方法名查询的关键字表

									
									

								 

        

								

							
							

																
								

										
Springboot Jpa 有关多数据源的问题

									
									

								 

        

								

							
							

																
								

										
springboot 整合/集成 jpa

									
									

								 

        

								

							
							

																
								

										
【JPA】Spring Data JPA 实现分页和条件查询

									
									

								 

        

								

							
							

																
								

										
JPA 笔记

									
									

								 

        

								

							
							

																
								

										
JPA EntityManager查询--使用原生sql 并且把查询结果转为实体对象

									
									

								 

        

								

							
							

																
								

										
Spring Data Jpa 基本使用

									
									

								 

        

								

							
							

																
								

										
springdataJpa

									
									

								 

        

								

							
							

																
								

										
SpringDataJpa打印Sql详情(含参数)

									
									

								 

        

								

							
							
            
            
            
                                    
           
  			
						

					

					
				

				

														
					
					

					
									

					
									   
标签

										

										
    
										

									

										
										

									

					

					
				


			
		
		
		
			


						





	

	
一品网 冀ICP备14022925号-6