JSP案例开发-源代码

CREATE TABLE ITEMREPLY( ID INTEGER NOT NULL PRIMARY KEY, ITEMID INTEGER, TABLENAME VARCHAR(30), FILEPATH1 VARCHAR(100), FILEPATH2 VARCHAR(100), FILEPATH3 VARCHAR(100), ); create table pass( passed varchar(50) not null primary key, passname varchar(40), passfile varchar(50) ); create table subhandtake( subid Integer not null primary key, handtake_id varchar(50) not null, subname varchar(30), englishname varchar(50), amount Integer, manu varchar(30), remark varchar(255) ); CREATE TABLE NOTEBOOK( BOOKID INTEGER NOT NULL PRIMARY KEY, USERNAME VARCHAR(20), BOOKDATE DATETIME, BOOKRECORD VARCHAR(255) ); create table usertranscat( usertranscat_id numeric(10,0) identity, //INTEGER NOT NULL primary key, id Integer, user_id varchar(20) , user_name varchar(50), processname varchar(30), unitid Integer ); create table transcat( id numeric(10,0) identity, //Integer NOT NULL primary key, itemid Integer, itemname varchar(50) not null, mainperson varchar(20), mainunit varchar(30), person varchar(20), unit varchar(30), unitid Integer, maincontent varchar(255) ); create table contractdraft( //draftid Integer NOT NULL primary key, draftid numeric(10,0) identity, draftname varchar(50) , draftpath varchar(40), itemid Integer, itemname varchar(50) ); create table intercourse( intercourse_id Integer not null primary key, title varchar(50) not null, content varchar(255), athor varchar(50), time Datetime, unitid Integer ); create table ITEMTABLE( ITEMID INTEGER NOT NULL PRIMARY KEY, //ITEMID numeric(10,0) identity, ITEMNAME varchar(50) not null, ITEMCODE varchar(20), FEE DOUBLE precision, DONEUNIT varchar(30), LEADUNIT varchar(30), UNIT varchar(30), ITEMTYPE Integer, ITEMTIME Datetime, USER_ID varchar(20) ); create table SEQUENCE( SEQUENCEID Integer, SEQUENCENAME varchar(20) ); create table BIDTEAM( BIDTEAMID Integer primary key not null, ITEMID Integer not null, MAINPERSON varchar(20), MAINUNIT varchar(30), MAINCONTENT varchar(255), USER_ID varchar(20), UNITID Integer ); create table BIDTEAM_X_EMPL( XEMPLID Integer not null primary key, BIDTEAMID Integer not null, ITEMID Integer not null, PERSON varchar(20), UNIT varchar(30) ); ////////////////////没有采用file////////////// create table FILE( FILEID numeric(10,0); //Integer not null primary key, FILENAME varchar(100), FILEPATH varchar(255), FILECODE varchar(50), KINDID Integer, APPLICATIONID Integer ); create table BIDBOOK( BIDBOOKID Integer not null primary key, ITEMID Integer not null, MANUNAME varchar(30), FEE DOUBLE precision, DONEUNIT varchar(30), TAG Integer , BIDTIME Datetime ); create table EXAM( EXAMID Integer not null primary key, ITEMID Integer not null, ITEMTYPE Integer, EXPERT varchar(200), EXPERTDATE Datetime, AGENT varchar(200), AGENTDATE Datetime, BIDTEAM varchar(200), BIDDATE Datetime, OFFICE varchar(200), OFFICEDATE Datetime, LEADER varchar(200), LEADERDATE Datetime ); create table rechange ( change_id VARCHAR(50) primary key NOT NULL , dev_type INTEGER NOT NULL , dev_name VARCHAR (30) NOT NULL , englishdevname varchar(40), dev_model VARCHAR(20) NOT NULL , amount INTEGER NOT NULL , hamount Integer, manufacturer VARCHAR(30) NOT NULL , time_intro datetime NOT NULL , contract_id VARCHAR(20) NOT NULL , price_usd DOUBLE precision, price_rmb DOUBLE precision, duty DOUBLE precision, s_fund VARCHAR (10) , handtake_id VARCHAR(50) NOT NULL , unit varchar(20), appendix Integer , time_change datetime , unitid Integer not null ); create table trainperson( train_id Integer not null primary key, person varchar(30) not null, unitid Integer not null, time Datetime, trainnum Integer, trainperson varchar(50), trincontent varchar(255), train_name varchar(50), persist Integer ); create table upreport( upid Integer not null primary key, sortid Integer not null , devname varchar(40) not null, devtype varchar(30), devnum Integer, devkind varchar(20), devmoney Double PRECISION, unitid Integer not null, year Integer, devuse varchar(255), devdemo varchar(255) ); CREATE TABLE contract ( //ht_id Integer NOT NULL primary key, ht_id numeric(10,0) identity, contract_id VARCHAR (20) , contractname varchar(40), time_sign Datetime NOT NULL , manurity Datetime NOT NULL , itemname varchar(50), diff varchar(30), manufacturer VARCHAR (30) NOT NULL, unitid Integer not null, maincontent varchar(255), applix varchar(30), devicename varchar(30), devicenumber Integer, lastnumber Integer, status Integer ); CREATE TABLE officeunit ( unitid Integer not null, processname VARCHAR ( 30 ) NOT NULL, upunitid Integer, unitremark varchar(255) ); CREATE TABLE navigationmark( mark_id VARCHAR (20) NOT NULL primary key, mark_name VARCHAR (20) NOT NULL , mark_type INTEGER NOT NULL , area VARCHAR (20) NOT NULL , longitude VARCHAR (20) NOT NULL , latitude VARCHAR (20) NOT NULL , mark_unit VARCHAR (20) NOT NULL , light_height VARCHAR (20) NOT NULL , light_qualith VARCHAR (10) NOT NULL , light_lamp VARCHAR (10) NOT NULL , unitid Integer not null, navigationimage image, haiba_height varchar(20), userange varchar(200), installtime Datetime, range VARCHAR (20) NOT NULL ) ; CREATE TABLE scheme ( sch_id VARCHAR (30) NOT NULL primary key, unit VARCHAR (30) NOT NULL , person VARCHAR (15) NOT NULL , input_time Datetime NOT NULL , app_time Datetime , replied INTEGER NOT NULL , unitid Integer not null, tag Integer, rep_time Datetime ); CREATE TABLE schemedetails ( sch_id VARCHAR (30) primary key NOT NULL , type INTEGER NOT NULL , name VARCHAR (30) NOT NULL , model VARCHAR (20) NOT NULL , price VARCHAR (30) , amount INTEGER NOT NULL , reason VARCHAR (100) , r_amount INTEGER , r_reason VARCHAR (100) , unitid Integer not null ); CREATE TABLE hsjscheme ( sch_id VARCHAR (30) NOT NULL primary key, unit VARCHAR (30) NOT NULL , person VARCHAR (15) NOT NULL , input_time Datetime NOT NULL , app_time Datetime , replied INTEGER NOT NULL , unitid Integer not null, tag Integer, rep_time Datetime ); CREATE TABLE hsjschemedetails ( sch_id VARCHAR (30) primary key NOT NULL , type INTEGER NOT NULL , name VARCHAR (30) NOT NULL , model VARCHAR (20) NOT NULL , price VARCHAR (30) , amount INTEGER NOT NULL , reason VARCHAR (100) , r_amount INTEGER , r_reason VARCHAR (100) , unitid Integer not null ); CREATE TABLE hqscheme ( sch_id VARCHAR (30) NOT NULL primary key, unit VARCHAR (30) NOT NULL , person VARCHAR (15) NOT NULL , input_time Datetime NOT NULL , app_time Datetime , replied INTEGER NOT NULL , unitid Integer not null, tag Integer, rep_time Datetime ); CREATE TABLE hqschemedetails ( sch_id VARCHAR (30) primary key NOT NULL , type INTEGER NOT NULL , name VARCHAR (30) NOT NULL , model VARCHAR (20) NOT NULL , price VARCHAR (30) , amount INTEGER NOT NULL , reason VARCHAR (100) , r_amount INTEGER , r_reason VARCHAR (100) , unitid Integer not null ); CREATE TABLE checkreport ( check_id VARCHAR (50) primary key NOT NULL , dev_type INTEGER NOT NULL , dev_name VARCHAR (30) NOT NULL , dev_model VARCHAR (20) NOT NULL , amount INTEGER NOT NULL , lastamount INTEGER , contract_id VARCHAR (20) , time_land Datetime NOT NULL , checkreport VARCHAR (100) NOT NULL , opinion VARCHAR (50) NOT NULL , time_check Datetime NOT NULL , unitid Integer not null, price_usb DOUBLE precision, price_rmb DOUBLE precision, checkperson varchar(30) not null ); CREATE TABLE handtake ( handtake_id VARCHAR (50)