fine report

最新推荐文章于 2024-03-28 21:53:34 发布

weixin_33979363

最新推荐文章于 2024-03-28 21:53:34 发布

阅读量210

点赞数

文章标签： python 数据库

原文链接：https://my.oschina.net/yangjiandong/blog/2251595

版权

2019独角兽企业重金招聘Python工程师标准>>>

FineReport xx

no: 0941626c-5e513d196-f528-74a7c52d8e61

hsql

报表内置hsql数据库finedb

sqlite3

export

>sqlite3 c:/sqlite/chinook.db
sqlite> .headers on
sqlite> .mode csv
sqlite> .output data.csv
sqlite> SELECT customerid,
   ...>        firstname,
   ...>        lastname,
   ...>        company
   ...>   FROM customers;
sqlite> .quit

sqlserver


--drop table [dbo].[demo_employee]
--go

CREATE TABLE [dbo].[demo_employee](
	--[EMPID] [int] IDENTITY(1,1) NOT NULL,
	[EMPID] [int] NOT NULL,
	[EMPNAME] [varchar](20) NOT NULL,
	[SEX] [varchar](20) NULL,
	[BIRTHDATE] [varchar](50) NULL,
	[POLITICAL] [varchar](100) NULL,
	[NATIONAL] [varchar](100) NULL,
	[ORIGIN] [varchar](100) NULL,
	[HEIGHT] [decimal](10,2) NULL,
	[WEIGHT] [decimal](10,2) NULL,
	[HEALTHCONDITION] [varchar](100) NULL,
	[STATUSID] [varchar](100) NULL,
	[QUALIFICATION] [varchar](100) NULL,
	[SCHOOL] [varchar](100) NULL,
	[MAJOR] [varchar](100) NULL,
	[ADDRESS] [varchar](100) NULL,
	[ZIPCODE] [varchar](100) NULL,
	[EMAIL] [varchar](100) NULL,
	[TEL] [varchar](100) NULL,
	[LANGUAGE] [varchar](100) NULL,
	[LEVER] [varchar](100) NULL,
	[COMPUTER] [varchar](100) NULL,
	[GRADUATED] [varchar](100) NULL,
	[REPORTDATE] [varchar](100) NULL,
	[TITLE] [varchar](100) NULL,
	[EDUCATION] [varchar](100) NULL,
	[WORKEXPERIENCE] [varchar](100) NULL,
	[PHOTO] [varchar](100) NULL,
	[WRITEDATE] [varchar](100) NULL,
	[SALARY] [decimal](10,2) NULL
) ON [PRIMARY]

GO

import data from csv

BULK INSERT demo_employee
FROM 'D:\FineReport_9.0\WebReport\data.csv'
WITH
(
    FIRSTROW = 2,
    FIELDTERMINATOR = ',',  --CSV field delimiter
    ROWTERMINATOR = '\n',   --Use to shift the control to next row
    TABLOCK
)

在sql server 2008 “工具”菜单栏下的“选项”菜单，在弹出的对话框中左边的列表中有一个“Designers”，取消“阻止保存要求重新创建表的修改”复选框，点击确认。就可以完成表结构的修改操作

转载于:https://my.oschina.net/yangjiandong/blog/2251595