struts mysql 增删改查_struts2+dao实现增删查改

一、数据库设计:

/*

NavicatMySQLDataTransfer

SourceServer:localhost

SourceServerVersion:50611

SourceHost:localhost:3306

SourceDatabase:mldn

TargetServerType:MYSQL

TargetServerVersion:50611

FileEncoding:65001

Date:2013-09-1621:03:49

*/

SETFOREIGN_KEY_CHECKS=0;

------------------------------

--Tablestructurefor`person`

------------------------------

DROPTABLEIFEXISTS`person`;

CREATETABLE`person`(

`id`int(4)NOTNULLAUTO_INCREMENT,

`name`varchar(20)NOTNULL,

`password`varchar(20)DEFAULTNULL,

PRIMARYKEY(`id`)

)ENGINE=InnoDBAUTO_INCREMENT=25DEFAULTCHARSET=utf8;

------------------------------

--Recordsofperson

------------------------------

INSERTINTO`person`VALUES('1','aa','aa');

INSERTINTO`person`VALUES('2','user','user12');

INSERTINTO`person`VALUES('4','mldn','mldn');

INSERTINTO`person`VALUES('14','cc','aa');

INSERTINTO`person`VALUES('15','cc','aa');

INSERTINTO`person`VALUES('19','xiaoqun','aa');

INSERTINTO`person`VALUES('21','cc','cc');

INSERTINTO`person`VALUES('22','cc','dd');

INSERTINTO`person`VALUES('23','bb','cc');

二、DAO设计

1、DataBaseConnection.java

//本类只用于数据库连接及关闭操作

packageorg.lxh.dbc;

importjava.sql.*;

publicclassDataBaseConnection

{

//属性

//定义数据库操作的常量、对象

//数据库驱动程序

privatefinalStringDBDRIVER="com.mysql.jdbc.Driver";

//数据库连接地址

privatefinalStringDBURL="jdbc:mysql://localhost:3306/mldn";

//数据库用户名

privatefinalStringDBUSER="root";

//数据库连接密码

privatefinalStringDBPASSWORD="root";

//声明一个数据库连接对象

privateConnectionconn=null;

//在构造方法之中连接数据库

publicDataBaseConnection()

{

try

{

//加载驱动程序

Class.forName(DBDRIVER);

//连接数据库

conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);

}

catch(Exceptione)

{

System.out.println(e);

}

}

//返回一个数据库连接

publicConnectiongetConnection()

{

///返回连接对象

returnthis.conn;

}

//关闭数据库连接

publicvoidclose()

{

try

{

this.conn.close();

}

catch(Exceptione)

{

}

}

};

2、PersonVo.java

//只包含setter和getter方法的类

packageorg.lxh.vo;

publicclassPersonVo

{

privateintid;

privateStringname;

privateStringpassword;

publicintgetId(){

returnid;

}

publicvoidsetId(intid){

this.id=id;

}

publicStringgetName(){

returnname;

}

publicvoidsetName(Stringname){

this.name=name;

}

publicStringgetPassword(){

returnpassword;

}

publicvoidsetPassword(Stringpassword){

this.password=password;

}

};

3、PersonDAO.java

//本接口定义本项目中所操作person表的全部方法

packageorg.lxh.dao;

//使用PersonVo类

importorg.lxh.vo.*;

importjava.util.List;

//登录验证的接口

publicinterfacePersonDAO

{

//需要一个登陆验证的方法

publicbooleanisLogin(PersonVopv);

publicvoidinser