StuDAO

package com.svse.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.util.Scanner;

import com.svse.entity.StuEntity;

public class StuDAO {
    
    public static void main(String[] args) {
        Scanner sa=new Scanner(System.in);
        System.out.println("请输入学号：");
        int sid=sa.nextInt();
        System.out.println("请输入姓名：");
        String sname=sa.next();
        System.out.println("请输入性别：");
        String ssex=sa.next();
        System.out.println("请输入年龄：");
        int sage=sa.nextInt();
        System.out.println("请输入电话：");
        String stel=sa.next();
        //组装起来--放到实体类中
        StuEntity stu=new StuEntity();
        stu.setSid(sid);
        stu.setSname(sname);
        stu.setSsex(ssex);
        stu.setSage(sage);
        stu.setStel(stel);
        //连接数据库
        String driver="com.mysql.jdbc.Driver";
        String url="jdbc:mysql://localhost:3306/test";
        String user="root";
        String password="root";
        
        Connection conn=null;
        //注册并得到数据库的连接
        try {
            Class.forName(driver);
            conn=DriverManager.getConnection(url, user, password);
        } catch (Exception e) {
            e.printStackTrace();
        }
        //调用增加方法
        try {
            String sql="insert into stuinfo values(?,?,?,?,?)";
            PreparedStatement pre=conn.prepareStatement(sql);
            pre.setInt(1, stu.getSid());
            pre.setString(2, stu.getSname());
            pre.setString(3,stu.getSsex());
            pre.setInt(4,stu.getSage());
            pre.setString(5,stu.getStel());
            //提交
            pre.executeUpdate();
            
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

stuEntity

package com.xiaohu.entity;

public class stuEntity {
    private int sid;
    private String sname;
    private String ssex;
    private int sage;
    private String stel;
    public int getSid() {
        return sid;
    }
    public void setSid(int sid) {
        this.sid = sid;
    }
    public String getSname() {
        return sname;
    }
    public void setSname(String sname) {
        this.sname = sname;
    }
    public String getSsex() {
        return ssex;
    }
    public void setSsex(String ssex) {
        this.ssex = ssex;
    }
    public int getSage() {
        return sage;
    }
    public void setSage(int sage) {
        this.sage = sage;
    }
    public String getStel() {
        return stel;
    }
    public void setStel(String stel) {
        this.stel = stel;
    }
    
}