一个简单的MVC实例
利用jsp+javabean+Servlet模拟一个用户登陆,实现对数据库的增删改查。
1,创建数据库
我使用的数据库是MySql,创建一个Iuser表,具体如下
2,创建一个javabean类,对表中的3个属性进行封装
User.java
package cn.jw.vo;
public class User {
private String username;
private String userspass;
private String userid;
public User(){
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getUserspass() {
return userspass;
}
public void setUserspass(String userspass) {
this.userspass = userspass;
}
public String getUserid() {
return userid;
}
public void setUserid(String userid) {
this.userid = userid;
}
}
3,创建一个名为DataBaseConnection.java的类,实现数据库的驱动
DataBaseConnection.java
package cn.jw.dbc;
import java.sql.*;
public class DataBaseConnection {
public static final String DBDRIVER="com.mysql.jdbc.Driver";
public static final String DBURL="jdbc:mysql://localhost:3306/test";
public static final String DBUSER="root";
public static final String DBPASS="zhy1121";
private Connection conn=null;
public DataBaseConnection(){
try {
Class.forName(DBDRIVER);
this.conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public Connection getConnection() {
// TODO Auto-generated method stub
return this.conn;
}
public void close() {
// TODO Auto-generated method stub
try {
this.conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
4,创建一个dao接口,并创建一个实现类和一个代理类,继承这个接口
接口用来定义一些方法,在下面会用到
UserDao.java
package cn.jw.dao;
import java.util.List;
import cn.jw.vo.User;
public interface UserDAO {
}
UserDaoImpl.java
public class UserDaoImpl implements UserDAO {
private Connection conn=null;
private PreparedStatement pstmt=null;
private int count=0;
public UserDaoImpl(Connection conn1){
this