java编写mvc架构_二十九、JavaMVC架构写数据库操作

1.Swing是什么东东？

一.MVC架构思维

二、MVC架构代码

整体代码结构，总的代码分为了

image.png

controler包

控制器包，用于创建什么实类，调用什么管理类在这里控制

db包

(所有的用于直接操作数据库的类都放此包下面)

entity包

实体类包，新有的实体都放到此包下面

manage包

这里把对实的增删改查操作的封装类都下这包下面

MVC的案例

1.控制器类Test

package com.joychenmvc.controler;

import com.joychenmvc.entity.User;

import com.joychenmvc.manager.UserManager;

public class Test {

public static void main(String args[]){

User user = new User(-1,"joychen","123456",1,"0007");

UserManager userManager = new UserManager();

userManager.addUser(user);

}

}

2.用户实体类User

package com.joychenmvc.entity;

public class User {

private int id;

private String username;

private String password;

private int sex;

private String number;

public User() {

}

public User(int id, String username, String password, int sex, String number) {

this.id = id;

this.username = username;

this.password = password;

this.sex = sex;

this.number = number;

}

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public String getUsername() {

return username;

}

public void setUsername(String username) {

this.username = username;

}

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password;

}

public int getSex() {

return sex;

}

public void setSex(int sex) {

this.sex = sex;

}

public String getNumber() {

return number;

}

public void setNumber(String number) {

this.number = number;

}

@Override

public String toString() {

return "User{" +

"id=" + id +

", username='" + username + '\'' +

", password='" + password + '\'' +

", sex=" + sex +

", number='" + number + '\'' +

'}';

}

}

3.用户实体管理类UserManager

package com.joychenmvc.manager;

import com.joychenmvc.db.DBHelper;

import com.joychenmvc.entity.User;

import java.sql.ResultSet;

import java.util.ArrayList;

import java.util.List;

public class UserManager {

DBHelper dbHelper;

public UserManager() {

dbHelper = new DBHelper();

}

/**

* @param user

*/

public void addUser(User user) {

String sql = "insert into users(name,password,sex,number) values" +

"('" + user.getUsername() + "','" + user.getPassword() + "'," + user.getSex() +

",'" + user.getNumber() + "')";

dbHelper.init();

dbHelper.updateDb(sql);

dbHelper.colse();

}

public void edidUser(User user) {

String sql = "update users set name='" + user.getUsername() + "',password='" + user.getPassword() + "',sex=" + user.getSex() + ",number='" + user.getNumber() + "' where id=" + user.getId();

dbHelper.init();

dbHelper.updateDb(sql);

dbHelper.colse();

}

public void editUserByName(User user,String name){

String sql = "update users set name='" + user.getUsername() + "',password='" + user.getPassword() + "',sex=" + user.getSex() + ",number='" + user.getNumber() + "' where name=" +name;

dbHelper.init();

dbHelper.updateDb(sql);

dbHelper.colse();

}

public void deleteUser(int id) {

String sql = "delete from users where id=" + id;

dbHelper.init();

dbHelper.updateDb(sql);

dbHelper.colse();

}

public List getAllUsers() {

List users = new ArrayList<>();

String sql = "select * from users";

dbHelper.init();

ResultSet resultSet = dbHelper.query(sql);

try {

while (resultSet.next()) {

int id = resultSet.getInt("id");

String aaa =resultSet.getString("name");

String passwd = resultSet.getString("password");

int sex = resultSet.getInt("sex");

String number =resultSet.getString("number");

User u = new User(id,aaa,passwd,sex,number);

users.add(u);

}

} catch (Exception e) {

}

dbHelper.colse();

return users;

}

}

4.数据库连接类DbHelper

package com.joychenmvc.db;

import java.sql.*;

import java.util.ArrayList;

import java.util.List;

public class DBHelper {

//驱动包的路径

String driverName = "com.mysql.jdbc.Driver";

Connection conn;

String username = "root";

String password = "joy123";

String url = "jdbc:mysql://127.0.0.1:3306/studentdb?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull";

/**

* 初使化函数

*/

public void init() {

try {

//1.加载驱动类

Class.forName(driverName);

conn = DriverManager.getConnection(url, username, password);

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

}

/**

* 支持 新增 修改 删除

*

* @param sql

* @return

*/

public int updateDb(String sql) {

int reslut = 0;

try {

Statement statement = conn.createStatement();

reslut = statement.executeUpdate(sql);

} catch (SQLException e) {

e.printStackTrace();

}

return reslut;

}

/**

* 关闭数据库操作

*/

public void colse() {

try {

if (conn != null || !conn.isClosed()) {

conn.close();

}

} catch (SQLException e) {

e.printStackTrace();

}

}

/**

* 执行查询操作

* @param sql

* @return

*/

public ResultSet query(String sql) {

ResultSet resultSet = null;

try {

Statement statement = conn.createStatement();

resultSet = statement.executeQuery(sql);

} catch (SQLException e) {

e.printStackTrace();

}

return resultSet;

}

}