今天做的事

之前没有按规范建表

把之前的全删了

按照师兄的格式重新建立了一下

写好了工具类

DAO

实体类

package com.pojo;


import java.math.BigInteger;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class Student {
    private Long id;

    private String name;

    private String qq;

    private String job;

    private Long start_time;

    private String college;

    private Long number;
    private Long daily_url;
    private Long wish;
    private String brother;
    private String whereknow;

    public Long getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

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

    public String getQq() {
        return qq;
    }

    public void setQq(String qq) {
        this.qq = qq;
    }

    public String getJob() {
        return job;
    }

    public void setJob(String job) {
        this.job = job;
    }

    public Long getStart_time() {
        return start_time;
    }

    public void setStart_time(Long start_time) {
        this.start_time = start_time;
    }

    public String getCollege() {
        return college;
    }

    public void setCollege(String college) {
        this.college = college;
    }

    public Long getNumber() {
        return number;
    }

    public void setNumber(Long number) {
        this.number = number;
    }

    public Long getDaily_url() {
        return daily_url;
    }

    public void setDaily_url(Long daily_url) {
        this.daily_url = daily_url;
    }

    public Long getWish() {
        return wish;
    }

    public void setWish(Long wish) {
        this.wish = wish;
    }

    public String getBrother() {
        return brother;
    }

    public void setBrother(String brother) {
        this.brother = brother;
    }

    public String getWhereknow() {
        return whereknow;
    }

    public void setWhereknow(String whereknow) {
        this.whereknow = whereknow;
    }
}

实现类没写完

package com.daolmpl;

import com.dao.Studentdao;
import com.pojo.Student;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;

public class StudentDaolmpl    implements Studentdao {
    @Override
    public void add(Student user) {

        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }

        try (
                Connection c = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/how2j?characterEncoding=UTF-8",
                        "root", "root");
                Statement s = c.createStatement();
        )
        {
            String sql = "insert into student values(null,"+user.getName()+",11,11,11,11,11,11,11,11,11)";
            s.execute(sql);

        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }

    @Override
    public void delete(Integer id) {

    }

    @Override
    public void update(Student user) {

    }

    @Override
    public Student queryOne(Integer id) {
        return null;
    }

    @Override
    public List<Student> queryAll() {
        return null;
    }
}

收获

任务终于推进了一点 知道接下来要做什么

问题

无

明计划 

继续