| 提交 | 用户 | age | ||
| a6a76f | 1 | package com.yc.service.panel; |
| F | 2 | |
| 3 | ||
| 4 | import org.springframework.stereotype.Service; | |
| 5 | ||
| 6 | import com.yc.service.BaseService; | |
| 7 | @Service("GetDataType") | |
| 8 | public class GetDataTypeImpl extends BaseService implements GetDataTypeIfc { | |
| 9 | ||
| 10 | @Override | |
| 11 | public Object getDataTypeByName(String tableName,String name) { | |
| 12 | try { | |
| 98c7bf | 13 | String sql = "set nocount on ; select data_type from INFORMATION_SCHEMA.columns where table_name= ? and column_name= ?"; |
| J | 14 | return jdbcTemplate.queryForObject(sql,String.class,new Object[]{tableName,name}); |
| a6a76f | 15 | } catch (Exception e) { |
| F | 16 | return e.getMessage(); |
| 17 | } | |
| 18 | ||
| 19 | } | |
| 20 | ||
| 21 | } | |
