数据库:PostgreSQL
开发环境:Visual Studio 2010
开发语言:C#
操作系统:Win7 家庭普通版 SP1(简体中文)
数据库:PostgreSQL
开发环境:Visual Studio 2010
开发语言:C#
操作系统:Win7 家庭普通版 SP1(简体中文)
--------------------------------------------------------------------------------
文本朗读语音合成引擎:
日语女声Misaki:Neospeech.Japanese.Misaki.rar
下载地址:ed2k://|file|Neospeech.Japanese.Misaki.rar|749378491|
378AC5437CE2542F3548B0B402A6878C|h=NXPREIKMLRHFBITNK2I7BUTNX25PEVOK|/
日文单词发音:
1.安装并配置文本朗读语音合成引擎:
控制面板/轻松访问/语音识别->文本到语音转换->语音选择:VM Misaki
2.添加引用System.Speech(System.Speech.dll)
C:/Program Files/Reference Assemblies/Microsoft/Framework/.NETFramework/v4.0/
Profile/Client/System.Speech.dll
3.代码:
using System.Speech.Synthesis;
SpeechSynthesizer speecher;
speecher.SpeakAsync(“Hello World”);
--------------------------------------------------------------------------------
PostgreSQL的安装ODBC数据源的配置及使用:
1.数据库驱动安装:利用Application Stack Builder安装psqlODBC v08.04.0200-1。
类别->Database Drivers ->psqlODBC v08.04.0200-1
2.ODBC数据源配置:
控制面板/系统和安全/管理工具->双击数据源(ODBC)
ODBC数据源管理器窗口->选择用户DSN Tab页->按下添加按钮->
创建新数据源窗口->选择PostgreSQL ODBC Driver(UNICODE)->按下完成按钮
PostgreSQL Unicode ODBC Driver(psqlODBC) Setup 窗口
Data Source:PostgreSQL35W
Database:postgres
Server:localhost
Post:5432
User Name:postgres
Password:1
按下test按钮,连接成功,则按下save按钮。
3..Net连接ODBC数据源:
using System.Data.Odbc;
OdbcConnection cn;
OdbcCommand cmd;
DataTable books;
cn = new OdbcConnection("dsn=PostgreSQL35W;UID=postgres;PWD=1;");
cn.Open();
cmd = cn.CreateCommand();
cmd.CommandText = "select * from books ";
OdbcDataAdapter adapter = new OdbcDataAdapter(cmd);
books=new DataTable();
adapter.Fill(books);
adapter.Dispose();
cn.Close();
--------------------------------------------------------------------------------
PostgreSQL创建数据表
1.创建books表
-- Table: books
-- DROP TABLE books;
CREATE TABLE books
(
bookid integer NOT NULL,
booknm character varying(50),
CONSTRAINT "key_bookId" PRIMARY KEY (bookid)
)
WITH (
OIDS=FALSE
);
ALTER TABLE books OWNER TO postgres;
2.创建words表
-- Table: words
-- DROP TABLE words;
CREATE TABLE words
(
id integer NOT NULL,
japan character varying(50) NOT NULL,
hiragana character varying(50),
chinese character varying(50),
sound character varying(10),
wordtype character varying(20),
bookid integer NOT NULL,
CONSTRAINT words_key PRIMARY KEY (id, bookid),
CONSTRAINT fk_bookid FOREIGN KEY (bookid)
REFERENCES books (bookid) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
OIDS=TRUE
);
ALTER TABLE words OWNER TO postgres;
-- Index: "words_Index"
-- DROP INDEX "words_Index";
CREATE INDEX "words_Index"
ON words
USING btree
(id, bookid);
3.导入数据
insert into books values('1','標準日本語 初級上');
insert into books values('2','標準日本語 初級下');
insert into words values('1','わたし','わたし','我','0','代词','1');
insert into words values('2','会社員','かいしゃいん','公司职员','3','名词','1');
insert into words values('3','学生','がくせい','学生','0','名词','1');
insert into words values('4','留学生','りゅうがくせい','留学生','4','名词','1');
insert into words values('5','初めまして','はじめまして','初次见面','4',
'寒暄语','1');