Java入门项目model

来源:互联网 发布:矩阵分析 编辑:程序博客网 时间:2024/04/29 05:04
package com.java1234.dao;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import com.java1234.model.User;/** * 用户Dao类 * @author Administrator * */public class UserDao {/** * 登录验证 * @param con * @param user * @return * @throws Exception */public User login(Connection con,User user) throws Exception{User resultUser=null;String sql="select * from t_user where userName=? and password=?";PreparedStatement pstmt=con.prepareStatement(sql);pstmt.setString(1, user.getUserName());pstmt.setString(2, user.getPassword());ResultSet rs=pstmt.executeQuery();if(rs.next()){resultUser=new User();resultUser.setUserName(rs.getString("userName"));resultUser.setPassword(rs.getString("password"));}return resultUser;}}


package com.java1234.model;/** * 图书类型实体 * @author Administrator * */public class BookType {private int id; // 编号private String bookTypeName; // 图书类型名称private String bookTypeDesc; // 备注public BookType() {super();// TODO Auto-generated constructor stub}public BookType(String bookTypeName, String bookTypeDesc) {super();this.bookTypeName = bookTypeName;this.bookTypeDesc = bookTypeDesc;}public BookType(int id, String bookTypeName, String bookTypeDesc) {super();this.id = id;this.bookTypeName = bookTypeName;this.bookTypeDesc = bookTypeDesc;}public int getId() {return id;}public void setId(int id) {this.id = id;}public String getBookTypeName() {return bookTypeName;}public void setBookTypeName(String bookTypeName) {this.bookTypeName = bookTypeName;}public String getBookTypeDesc() {return bookTypeDesc;}public void setBookTypeDesc(String bookTypeDesc) {this.bookTypeDesc = bookTypeDesc;}@Overridepublic String toString() {return this.getBookTypeName();}}

package com.java1234.model;/** * 用户实体 * @author Administrator * */public class User {private int id; // 编号private String userName; // 用户名private String password; // 密码public User() {super();// TODO Auto-generated constructor stub}public User(String userName, String password) {super();this.userName = userName;this.password = password;}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;}}


0 0
原创粉丝点击