if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[book_table]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[book_table]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[login_table]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[login_table]
GO
CREATE TABLE [dbo].[book_table] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[book_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[author] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[price] [float] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[login_table] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
insert into book_table values ('C#','admin',12)
insert into book_table values ('Java','accp',20)
insert into book_table values ('WEB开发','aptech',45)
insert into login_table values('admin',123456)
sshAndajax.rar （65个子文件） 
sshAndajax 
.mystrutsdata 262B .springBeans 273B .myhibernatedata 475B src com xfaccp ssh interf ICommand.java 723B IDAO.java 508B dao BookTableDAO.java 523B LoginTableDAO.java 533B ApplicationResources.properties 90B form LoginTable.java 736B LoginTable.hbm.xml 813B BookTable.java 987B BookTable.hbm.xml 955B base BaseAction.java 268B BaseForm.java 328B command SelectCommand.java 280B LoginCommand.java 445B action CreatetLoginTableAction.java 998B AjaxShowInfoAction.java 2KB adpater CommandAdpater.java 2KB DAOAdpater.java 1002B .project 2KB
db.txt 1015B WebRoot META-INF MANIFEST.MF 39B WEB-INF struts-nested.tld 63KB struts-template.tld 2KB validator-rules.xml 41KB applicationContext_dao.xml 1KB struts-bean.tld 9KB applicationContext_action.xml 514B struts-html.tld 65KB struts-logic.tld 14KB struts-tiles.tld 8KB web.xml 2KB dwr.xml 357B .struts-config.mex 522B classes com xfaccp ssh interf ICommand.class 677B IDAO.class 512B dao BookTableDAO.class 1KB LoginTableDAO.class 1KB ApplicationResources.properties 90B form BookTable.class 1KB LoginTable.class 964B LoginTable.hbm.xml 813B BookTable.hbm.xml 955B base BaseForm.class 619B BaseAction.class 500B command LoginCommand.class 992B SelectCommand.class 618B action AjaxShowInfoAction.class 3KB CreatetLoginTableAction.class 2KB adpater CommandAdpater.class 2KB DAOAdpater.class 2KB struts-config.xml 1KB applicationContext_command.xml 2KB lib spring.tld 13KB spring-form.tld 51KB ajax ajaxshowinfo.jsp 2KB
1.html 604B dwrshowinfo.jsp 2KB index.jsp 222B jsp createLogin.jsp 751B error.jsp 942B displayBooksList.jsp 906B .mymetadata 303B .classpath 6KB .myeclipse 资源评论
lovting2013-09-07嗯，不错。很有参考价值。谢谢了
