Summary for week2
来源:互联网 发布:小猪cms伪静态 编辑:程序博客网 时间:2024/06/05 04:44
July 19th1:30pmH2DB memory database2:00pmemail-writing should be simple and clear. Tell most important thing firstly.Structure: opeing (purpose or action), body(detail), close(follow-up or gratitude)
3:30pmdatabase schema design
July 20th1:30pmAPI stream: STAX can be used to read file.Use executor or thread.
July 21st:Recursive traverse items.Use KeyHolder to return key.Use updateBatch to improve performance.
July 22ndCODE + DOCS = SOLID INPUTNight: Mysql test sql statements. Pay attention to DateTime, Duration and so on.Configure database in config.xml.
July 23rdNight summaryDatabase design.Use sybase to store, we can use other tools to get direct sql executed.Dont forget to grant permission for others to visit tables. commands like sp_help.
==================================常用DDL语句===========================================Sybase中DDL语句不能修改字段的数据类型,只能修改空与非空:1.删除列:ALTER TABLE table_name DELETE column_name;2.增加列:ALTER TABLE table_name ADD (column_name DATA_TYPE [NOT] NULL);3.修改列的空与非空:ALTER TABLE table_name MODIFY column_name [NOT] NULL;4.修改列名:ALTER TABLE table_name RENAME old_column_name TO new_column_name;5.快速建立临时表:SELECT * INTO [#]table_name FROM .....;6、修改表名:ALTER TABLE old_table_name RENAME new_table_name7.增加主键约束:ALTER TABLE tb_name ADD CONSTRAINT pk_name PRIMARY KEY(col_name,..)8.删除主键约束:ALTER TABLE tb_name DROP CONSTRAINT pk_name;9.建立自增长字段,与Oracle的SEQUENCE类似:CREATE TABLE TMP_001 (RES_ID INTEGER IDENTITY NOT NULL);10.添加表注释:COMMENT ON TABLE table_name IS '....';11.创建索引:CREATE INDEX index_name ON table_name(column_name);
Use queue to get sth
Bug fix:default value should be valid.setXXX should be specific.pay attention to each detail.
Night:JDBC template seems to be more useful for query not for update.Insert into database timestamp.
July 24th1:30pmTransaction: try {commit();} catch(){rollback();} finnaly{clean connection rsc}JPA wrap object to db.Junit test codes.Weeklist should be objective and seems to move to the right direction.Excel and tableau
Night:Summary for whole week.Some Tips:Dont worry, take it easy. You will get used to it, and just be confident and careful.
0 0
- Summary for week2
- 【Summary】——>Web组·Week2
- 【Summary】——Web组·大三·Week2
- week2
- Week2
- week2
- Week2
- week2
- week2
- Summary for these days
- C++ Summary for Interview
- Summary For iOS Develop
- Summary for SourceInsight
- Summary for maven project
- Summary for week1
- Summary for week3
- Summary for week4
- Summary for week5
- HMM
- QT官方下载地址
- Graph Coloring 图着色问题
- 定义构造方法的程序.java
- 关系数据库理论:范式判断、函数依赖、无损分解、正则覆盖
- Summary for week2
- Makefile中常用的一些符号
- 虚函数的实现机制
- 《C++编程思想》(第二版)第3章 C++中的C(笔记、习题及答案)(一)
- 基于Linux的智能家居的设计(3)
- java多线程学习笔记(2)——中断线程
- hihoCoder - 1079 - 离散化 (线段树 + 离散化)
- BP神经网络(检测故障的实例)
- swift2 扩展