import java.text.DateFormat;

//数据库的查询

public class SelectTable {

     String dbDriver="com.mysql.jdbc.Driver";

     String dbUrl="jdbc:mysql://localhost:3306/sss";//根据实际情况变化

     String username="root";

     String password="123";

     public Connection getConn()

     {

     Connection conn=null;

     try

     {

     Class.forName(dbDriver);

     }

     catch (ClassNotFoundException e)

     {

     e.printStackTrace();

     }

     try

     {

     conn = DriverManager.getConnection(dbUrl,username,password);//注意是三个参数

     }

     catch (SQLException e)

     {

     e.printStackTrace();

     }

     return conn;

     }

    public void select(){

    Connection conn = getConn();

    try{

     Statement stmt = conn.createStatement(); //创建Statement对象

     System.out.println("成功连接到数据库！");

     String sql = "select * from jdbc"; //要执行的SQL

     ResultSet rs = stmt.executeQuery(sql);//创建数据对象

     System.out.println("id"+"\t"+"name"+"\t"+"brithday");

     while (rs.next()){

     System.out.print(rs.getInt(1) + "\t");

     System.out.print(rs.getString(2) + "\t");

     System.out.print(rs.getDate(3) + "\t");

     System.out.println();

     }

    }catch(Exception e){

    e.printStackTrace();

    }

}

public void insert(){

Connection conn = getConn();

try{

    Statement stmt = conn.createStatement();

    System.out.println("成功连接到数据库！");

    String sql = "insert into jdbc (id,name,birthday) values(?,?,?)";

    PreparedStatement pst =conn.prepareStatement(sql);

    DateFormat df = DateFormat.getDateInstance();

    java.util.Date dd = df.parse("2000-12-12");//将YYYY-MM-DD格式的时间转换为date

    long t = dd.getTime();

    java.sql.Date date = new java.sql.Date(t);

    pst.setInt(1, 5);

    pst.setString(2, "limazhi");

    pst.setDate(3, date);

    pst.executeUpdate();

    select();

}catch(Exception e){

e.printStackTrace();

}

}

public static void main(String args[]){

    SelectTable st = new SelectTable();

    st.insert();

}

}