MySQL插入数据

package MySQLExercise;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;
import java.text.SimpleDateFormat;

public class ExerciseFirst {
    public static final String DBDRIVER="com.mysql.jdbc.Driver";
    public static final String DBURL="jdbc:mysql://127.0.0.1:3306/javademo";
    public static final String DBUSER="root";
    public static final String DBPASS="123";
    public static void main(String args[])throws Exception{
        Connection conn=null;
        Statement stmt=null;
        PreparedStatement pstmt=null;

        BufferedReader buff=new BufferedReader(new InputStreamReader(System.in));
        String name=null;
        String password=null;
        int age=0;
        String sex=null;
        String birthday=null;

        System.out.print("Please input name : ");
        name=buff.readLine();
        System.out.print("Please input password : ");
        password=buff.readLine();
        System.out.print("Please input age : ");
        String agestr=buff.readLine();
        age=Integer.parseInt(agestr);
        System.out.print("Please input sex: ");
        sex=buff.readLine();
        System.out.print("Please input birthday : ");
        birthday=buff.readLine();
        java.util.Date temp=null;
        temp = new SimpleDateFormat("yyyy-MM-dd").parse(birthday);
        java.sql.Date bir=new java.sql.Date(temp.getTime());

        String sql="insert INTO user(name,password,age,sex,birthday) values(?,?,?,?,?)";
        Class.forName(DBDRIVER);
        conn= DriverManager.getConnection(DBURL,DBUSER,DBPASS);
        pstmt=conn.prepareStatement(sql);

        pstmt=conn.prepareStatement(sql);
        pstmt.setString(1,name);
        pstmt.setString(2,password);
        pstmt.setInt(3,age);
        pstmt.setString(4,sex);
        pstmt.setDate(5,bir);
        pstmt.executeUpdate();
        System.out.println("Insert successfully . ");
        pstmt.close();
        conn.close();

    }
}

转载于:https://www.cnblogs.com/ssMellon/p/6508116.html