用mvc和MySQL实现登录_JDBC MVC框架实现用户登录

MVC全名是Model View Controller，是模型(model)－视图(view)－控制器(controller)的缩写

1、实体entity

1 packagecom.uplooking.entity;2

3 importjava.io.Serializable;4

5 public class User implementsSerializable {6 private intid;7 privateString name;8 privateString pwd;9

10

11 public intgetId() {12 returnid;13 }14 public void setId(intid) {15 this.id =id;16 }17 publicString getName() {18 returnname;19 }20 public voidsetName(String name) {21 this.name =name;22 }23 publicString getPwd() {24 returnpwd;25 }26 public voidsetPwd(String pwd) {27 this.pwd =pwd;28 }29

30

31 }

2、

1 packagecom.uplooking.dao;2

3 importcom.uplooking.entity.User;4

5 importjava.sql.Connection;6 importjava.sql.DriverManager;7 importjava.sql.PreparedStatement;8 importjava.sql.ResultSet;9 importjava.sql.SQLException;10

11 public classUserDao {12 publicUser findByName(String name) {13 PreparedStatement statement = null;14 Connection con = null;15 try{16 //1、加载驱动

17 Class.forName("com.mysql.jdbc.Driver");18 //2、创建连接

19 String sqlUrl = "jdbc:mysql://127.0.0.1:3307/test?useunicode=true&characterEncoding=utf8";20 //Driver表示Java驱动的街口

21 con = DriverManager.getConnection(sqlUrl,"root","");22

23 //3、预编译，使用占位符

<