本文共 661 字，大约阅读时间需要 2 分钟。

 Connection conn = null;

  PreparedStatement pstm = null;  ResultSet rs = null;  conn = JDBC_Connection.getConnection();  String sqlinsert ="insert into tbvideo(panoramaId,no,title,duration,publisher) values('"+panoramaId+"','"+no+"','"+title+"','"+duration+"','"+publisher+"')";    try {    pstm= conn.prepareStatement(sqlinsert);    pstm.execute();    System.out.print("kkkk");  //  pstm.executeUpdate();  } catch (SQLException e) {    // TODO Auto-generated catch block   e.printStackTrace();  }

 

 

 

1. 自动编号的字段不能显性插入。2. 数字值不要用单引号包围。3. 日期时间型数据用#号包围，而不是单引号。String sql2 = "insert into reply(pid, rTitle, rcontent, rauthor,rdate)

values(" +id+",'"+rtitle+"','"+re+"','"+author+"',#"+date+"#)";

转载地址：http://akdai.baihongyu.com/