20190301——Dao设计思想与搭建骨架

这个是User实体类

package domain;

import java.util.Date;

public class User {
    private int id;
    private String name;
    private Date birthday;
    private  float money;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    public float getMoney() {
        return money;
    }

    public void setMoney(float money) {
        this.money = money;
    }
}

package imp;

import dao.UserDao;
import domain.User;

import java.sql.*;

public class UserDaoJdbcImpl implements UserDao {
    static final String JDBC_DRIVER="com.mysql.jdbc.Driver";
    static final String DB_URL="jdbc:mysql://localhost/jdbc";

    static final String USER="root";
    static final String PWD="password";
    @Override
    public void addUser(User user) {
        Connection conn=null;
        PreparedStatement ps=null;
        ResultSet rs=null;
        try{
            Class.forName(JDBC_DRIVER);
            conn = DriverManager.getConnection(DB_URL,USER,PWD);
            System.out.println("连接成功");
            String sql="insert into user(name,birthday,money,id)values(?,?,?,?)";
            ps = conn.prepareStatement(sql);
            ps.setString(1,user.getName());
            ps.setDate(2,new java.sql.Date(user.getBirthday().getTime()));
            ps.setFloat(3,user.getMoney());
            ps.setInt(4,user.getId());
            int i =ps.executeUpdate();
            System.out.println("i="+i);
            rs.close();
            ps.close();
            conn.close();
        }catch(SQLException se){
            //Handle errors for JDBC
            se.printStackTrace();
        }catch(Exception e){
            //Handle errors for Class.forName
            e.printStackTrace();
        }finally{
            //finally block used to close resources
            try{
                if(ps!=null)
                    ps.close();
            }catch(SQLException se2){
            }// nothing we can do
            try{
                if(conn!=null)
                    conn.close();
            }catch(SQLException se){
                se.printStackTrace();
            }//end finally try
        }
    }

    @Override
    public User findUser(String loginName, String password) {
        return null;
    }

    @Override
    public User getUser(int id) {
        return null;
    }

    @Override
    public void delete(User user) {

    }

    @Override
    public void update(User user) {
    }

    public static void main(String[] args) {
        User user=new User("xixi", new Date(1996, 02, 24) ,1000.0f,4);
        System.out.println("出错了");
        UserDaoJdbcImpl demo=new UserDaoJdbcImpl();
        System.out.println("出错了");
        demo.addUser(user);
    }
}