JDBC向数据库中插入数据

新建数据库并插入相关数据

create database bbs;

use bbs;

create table article 
(
id int primary key auto_increment,
pid int,
rootid int,
title varchar(255),
cont text,
pdate datetime,
isleaf int 
);

insert into article values (null, 0, 1, '蚂蚁大战大象', '蚂蚁大战大象', now(), 1);
insert into article values (null, 1, 1, '大象被打趴下了', '大象被打趴下了',now(), 1);
insert into article values (null, 2, 1, '蚂蚁也不好过','蚂蚁也不好过', now(), 0);
insert into article values (null, 2, 1, '瞎说', '瞎说', now(), 1);
insert into article values (null, 4, 1, '没有瞎说', '没有瞎说', now(), 0);
insert into article values (null, 1, 1, '怎么可能', '怎么可能', now(), 1);
insert into article values (null, 6, 1, '怎么没有可能', '怎么没有可能', now(), 0);
insert into article values (null, 6, 1, '可能性是很大的', '可能性是很大的', now(), 0);
insert into article values (null, 2, 1, '大象进医院了', '大象进医院了', now(), 1);
insert into article values (null, 9, 1, '护士是蚂蚁', '护士是蚂蚁', now(), 0);

为每一张表建立一个实体类，实体类中的属性对应着表的字段名。

package qddx.JDBC;
import java.sql.*;
public class bbsVo {

    private int id;
    private int pid;
    private int rootid;
    private String title;
    private String cont;
    private Timestamp pdate;
    private int isleaf;

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

    public int getPid(){
        return pid;
    }
    public void setPid(int pid){
        this.pid = pid;
    }

    public int getRootid(){
        return rootid;
    }
    public void setRootid(int rootid){
        this.rootid = rootid;
    }

    public String getTitle(){
        return cont;
    }
    public void setCont(String title){
        this.title = title;
    }

    public String getCont(){
        return title;
    }
    public void setTitle(String cont){
        this.cont = cont;
    }
    public Timestamp getPdate(){
        return pdate;
    }
    public void setPdate(Timestamp pdate){
        this.pdate = pdate;
    }

    public int getIsleaf(){
        return isleaf;
    }
    public void setIsleaf(int isleaf){
        this.isleaf = isleaf;
    }

}

插入数据

package qddx.JDBC;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.Timestamp;
import java.sql.*;
public class Addbbs {

    public void add(bbsVo vo){
        Connection conn = null;
         PreparedStatement pst = null;
         ResultSet rs = null;
         try{
         conn = JDBC_Connection.getConnection();
         String sql = "INSERT INTO ARTICLE(id,pid,rootid,title,cont,pdate,isleaf) values(?,?,?,?,?,?,?)";
         pst=conn.prepareStatement(sql);
         //把相应的参数 添加到pst对象中
         pst.setInt( 1, vo.getId());
         pst.setInt(2, vo.getPid());
         pst.setInt(3, vo.getRootid());
         pst.setString(4, vo.getTitle());
         pst.setString(5, vo.getCont());
         pst.setTimestamp(6, vo.getPdate());
         pst.setInt(7, vo.getIsleaf());
         //提交pst对象
         pst.executeUpdate();
         }catch(SQLException e){
             e.printStackTrace();
         }finally{
             JDBC_Connection.free(rs, conn, pst);//关闭数据库连接
         }
    }
    public static void main(String[] args) {
        // TODO Auto-generated method stub
        Addbbs addbbs = new Addbbs();
        bbsVo vo = new bbsVo();
        int id=13;
        int pid = 10;
        int rootid = 1;
        String title = "蚂蚁";
        String cont = "蚂蚁";
        java.util.Date date = new java.util.Date();
        Timestamp pdate = new Timestamp(date.getTime());
        int isleaf = 1;
        //设置要添加的变量值，放入bbsvo中
        vo.setId(id);
        vo.setPid(pid);
        vo.setRootid(rootid);
        vo.setTitle(cont);
        vo.setCont(title);
        vo.setIsleaf(isleaf);
        vo.setPdate(pdate);
        addbbs.add(vo);
    }

}