dao mvc连接mysql_MVC简单分层思想（连接数据库）

图片内容是所有的包名，文件名。

1.创建(M)模型

packageoa.bean;public classUser {privateString userName;privateString passWord;publicString getUserName() {returnuserName;

}public voidsetUserName(String userName) {this.userName =userName;

}publicString getPassWord() {returnpassWord;

}public voidsetPassWord(String passWord) {this.passWord =passWord;

}

@OverridepublicString toString() {return "User [userName=" + userName + ", passWord=" + passWord + "]";

}

}

2.创建DAO层

创建Dao层接口packageoa.dao;importoa.bean.User;/***@authorAdministrator

**/

public interfaceIUserDao {public booleanlogin(User user);public booleaninsert(User entity);

}2.创建Dao层实现类packageoa.dao;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importoa.Util.JDBCuntl;importoa.bean.User;public class UserDaoImpl implementsIUserDao {//封装数据库操作属性

Connection conn= null;

PreparedStatement pstm= null;

ResultSet rs= null;//第一步：声明返回值变量

boolean falg = false;//登录

@Overridepublic booleanlogin(User user) {//第二步：获取连接对象

try{

conn=JDBCuntl.getConnection();//第三步：声明sql语句

String sql = "select * from user";//第四步：根据sql语句创建预处理对象

pstm =conn.prepareStatement(sql);//第五步：执行查询

rs =pstm.executeQuery();//第六步：判断

while(rs.next()) {

String uname= rs.getString(1);

String upwd= rs.getString(2);if(uname.equals(user.getUserName())&&upwd.equals(user.getPassWord())) {return true;

}

}

}catch(Exception e) {

e.printStackTrace();

}finally{//第八步：释放资源

try{

JDBCuntl.close(rs, pstm, conn);

}catch(SQLException e) {

e.printStackTrace();

}

}//判断

/** if("admin".equals(user.getUserName()) &&

* "123456".equals(user.getPassWord())){ return true; }else{ return

* false; }*/

return false;

}//注册

@Overridepublic booleaninsert(User entity) {try{//第二步：获取连接对象

conn =JDBCuntl.getConnection();//第三步：声明sql语句(插入)

String sql = "insert into user(userName,passWord) values(?,?)";//第四步：根据sql语句出创建对象

pstm =conn.prepareStatement(sql);//第五步：为占位符赋值

int index = 1;

pstm.setObject(index++, entity.getUserName());<