Java jdbc数据库添加数据

Question

下段代码第71行究竟哪里错了啊

1. package cn.pd.news.dao;

2. 
   

3. import java.sql.Connection;

4. import java.sql.DriverManager;

5. import java.sql.PreparedStatement;

6. import java.sql.ResultSet;

7. import java.sql.SQLException;

8. import java.sql.Timestamp;

9. import java.util.Date;

10. 
    

11. import cn.pb.news.util.ConfigManager;

12. 
    

13. public class NewsDao {

14. public void getNewsList() { 

15. Connection con = null; 

16. //Statement st = null;

17. PreparedStatement st = null;

18. ResultSet rs = null;

19. String driver = ConfigManager.getInstance().getString("jdbc.driver.class");

20. String url = ConfigManager.getInstance().getString("jdbc.connection.url");

21. String username = ConfigManager.getInstance().getString("jdbc.connection.username");

22. String password = ConfigManager.getInstance().getString("jdbc.connection.password");

24. try {

25. Class.forName(driver);       //url中主机地址也可以是127.0.0.1

26. con = DriverManager.getConnection(url,username,password);

27. //System.out.println(con);

28. String sql = "select * from news_detail";

29.    //st = con.createStatement();

30. st = con.prepareStatement(sql);

31. rs = st.executeQuery(sql);

32. while(rs.next()) {

33. int id = rs.getInt("id"); 

34. int categoryId = rs.getInt("categoryId");

35. String title = rs.getString("title");

36. String summary = rs.getString("summary");

37. String content = rs.getString("content"); 

38. String author = rs.getString("author");

39. Timestamp creatDate = rs.getTimestamp("createDate");

40. System.out.println("Id: " + id + "\t title: " + title + "\t summary: " + summary + 

41. "\t content: " + content + "\t author: " + author + "\t creatDate" + creatDate );

42. }

43. } catch (ClassNotFoundException | SQLException e) {

44. e.printStackTrace();

45. }finally{

46. if(rs != null) {

47. try {

48. rs.close();

49. st.close();

50. con.close();

51. } catch (SQLException e) {

52. e.printStackTrace();

53. }

54. }

55. }

56. }

57. 
    

58. public void add(int id,int categoryId,String title,String summary,String content,String author,Date creatDate) {

59. Connection con = null; 

60. //Statement st = null;

61. PreparedStatement ps = null;

62. ResultSet rs = null;

63. String driver = ConfigManager.getInstance().getString("jdbc.driver.class");

64. String url = ConfigManager.getInstance().getString("jdbc.connection.url");

65. String user = ConfigManager.getInstance().getString("jdbc.connection.username");

66. String password = ConfigManager.getInstance().getString("jdbc.connection.password");

67. try {

68. Class.forName(driver);

69. con = DriverManager.getConnection(url, user, password);

70. //String sql = "insert into news_detail (id,categoryId,title,summary,content,author,createDate) values ("+id+","+categoryId+",'"+title+"','"+summary+"','"+content+"','"+new Timestamp(createDate.getTime())+"')";

71.       String sql = "insert into news_detail(id,categoryId,title,summary,content,createDate) values("+id+","+categoryId+",'"+title+"','"+summary+"','"+content+"','"+author+"','"+new Timestamp(createDate.getTime())+"')";

72. 
    

73. ps = con.prepareStatement(sql);

74. int i = ps.executeUpdate(sql);

75. if( i > 0 ) {

76. System.out.println("插入成功");

77. }

78. } catch (ClassNotFoundException e) {

79. e.printStackTrace();

80. } catch (SQLException e) {

81. e.printStackTrace();

82. }

83. }

85. public static void main(String [] args) {

86. NewsDao nd = new NewsDao();

87. nd.getNewsList();

88. }

90. }

Answer 1

不要写+和“”，直接String sql = "insert into news_detail(id,categoryId,title,summary,content,createDate) values(id,categoryId,title,summary,content,author,new Timestamp(createDate.getTime()))";你试一下