亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

為了賬號安全,請及時綁定郵箱和手機立即綁定
已解決430363個問題,去搜搜看,總會有你想問的

Java jdbc數據庫添加數據

Java jdbc數據庫添加數據

fenkapian 2016-07-16 11:36:55
下段代碼第71行究竟哪里錯了啊package cn.pd.news.dao;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Timestamp;import java.util.Date;import cn.pb.news.util.ConfigManager;public class NewsDao { public void getNewsList() {? Connection con = null;? //Statement st = null; PreparedStatement st = null; ResultSet rs = null; String driver = ConfigManager.getInstance().getString("jdbc.driver.class"); String url = ConfigManager.getInstance().getString("jdbc.connection.url"); String username = ConfigManager.getInstance().getString("jdbc.connection.username"); String password = ConfigManager.getInstance().getString("jdbc.connection.password"); try { Class.forName(driver); ? ? ? //url中主機地址也可以是127.0.0.1 con = DriverManager.getConnection(url,username,password); //System.out.println(con); String sql = "select * from news_detail"; ? ?//st = con.createStatement(); st = con.prepareStatement(sql); rs = st.executeQuery(sql); while(rs.next()) { int id = rs.getInt("id");? int categoryId = rs.getInt("categoryId"); String title = rs.getString("title"); String summary = rs.getString("summary"); String content = rs.getString("content");? String author = rs.getString("author"); Timestamp creatDate = rs.getTimestamp("createDate"); System.out.println("Id: " + id + "\t title: " + title + "\t summary: " + summary +? "\t content: " + content + "\t author: " + author + "\t creatDate" + creatDate ); } } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); }finally{ if(rs != null) { try { rs.close(); st.close(); con.close(); } catch (SQLException e) { e.printStackTrace(); } } } } public void add(int id,int categoryId,String title,String summary,String content,String author,Date creatDate) { Connection con = null;? //Statement st = null; PreparedStatement ps = null; ResultSet rs = null; String driver = ConfigManager.getInstance().getString("jdbc.driver.class"); String url = ConfigManager.getInstance().getString("jdbc.connection.url"); String user = ConfigManager.getInstance().getString("jdbc.connection.username"); String password = ConfigManager.getInstance().getString("jdbc.connection.password"); try { Class.forName(driver); con = DriverManager.getConnection(url, user, password); //String sql = "insert into news_detail (id,categoryId,title,summary,content,author,createDate) values ("+id+","+categoryId+",'"+title+"','"+summary+"','"+content+"','"+new Timestamp(createDate.getTime())+"')";? ? ? String sql = "insert into news_detail(id,categoryId,title,summary,content,createDate) values("+id+","+categoryId+",'"+title+"','"+summary+"','"+content+"','"+author+"','"+new Timestamp(createDate.getTime())+"')"; ps = con.prepareStatement(sql); int i = ps.executeUpdate(sql); if( i > 0 ) { System.out.println("插入成功"); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } public static void main(String [] args) { NewsDao nd = new NewsDao(); nd.getNewsList(); } }
查看完整描述

2 回答

?
慕粉3333924

TA貢獻3條經驗 獲得超1個贊

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

查看完整回答
反對 回復 2016-07-16
  • fenkapian
    fenkapian
    但又變成了運行時異常,調用add方法插入數據時報錯
  • 慕粉3333924
    慕粉3333924
    你要插入的是7個字段,但你前面括號里就寫了6個字段,所以出錯了
  • 2 回答
  • 0 關注
  • 2429 瀏覽
慕課專欄
更多

添加回答

舉報

0/150
提交
取消
微信客服

購課補貼
聯系客服咨詢優惠詳情

幫助反饋 APP下載

慕課網APP
您的移動學習伙伴

公眾號

掃描二維碼
關注慕課網微信公眾號