debug正確，sql陳述句正確，前一句能夠插入，后一句不能插入。
public void submit(Kaocha kaocha,String[] Kaochaxingming) {
try{
DBconnect.init();
}catch (Exception e){
e.printStackTrace();
}
KaochaDaoImplement kaocha1=new KaochaDaoImplement();
String sql="insert into ins_travel_arrange(leader,judger,drawer,iarrange,inumber,state,accomplishman,sdate,edate) values(" + kaocha.getLnumber() + "," + kaocha.getJudger_number() + "," + kaocha.getJudger_number() + ",'" + kaocha.getIarrange() + "'," + kaocha.getKaocha_id() +" ,'" + kaocha.getState() + "','" + kaocha.getAccomplishman() + "' ,'"+kaocha.getSdate1()+"','"+kaocha.getEdate1()+"')";
DBconnect.addUpdateDelete(sql);
DBconnect.closeConn();
for(int a=0;a<Kaochaxingming.length;a++)
{
try{
DBconnect.init();
}catch (Exception e){
e.printStackTrace();
}
int kaochaxingming= kaocha1.search_by_name(Kaochaxingming[0]);
String sql1="insert into serch_peple_table (inumber,penumber) values("+kaocha.getKaocha_id()+","+kaochaxingming+")";
DBconnect.addUpdateDelete(sql1);
DBconnect.closeConn();
}
DBconnect.closeConn();
}
DBconnect
package com.util;
import java.sql.*;
public class DBconnect
{
static String url="jdbc:mysql://localhost:3306/lingdao10001?useUnicode=true&characterEncoding=UTF-8";
static String user="root";
static String pw = "";
static Connection conn=null;
static PreparedStatement ps=null;
static ResultSet rs=null;
static Statement st=null;
public static void init() throws SQLException, ClassNotFoundException {//SQl程式初始化
try{
Class.forName("com.mysql.jdbc.Driver");//注冊驅動
conn= DriverManager.getConnection(url, user, pw); //建立連接
}catch (Exception e){
System.out.println("SQL程式初始化失敗");
e.printStackTrace();
}
}
public static int addUpdateDelete(String sql){
int i=0;
try{
ps=conn.prepareStatement(sql);
boolean flag= ps.execute();
//如果第一個結果是結果集物件，則回傳true;如果第一個結果是更新計數或者沒有結果，則回傳false
if(flag==false){
i++;
}
}catch(Exception e){
System.out.println("資料庫增刪改例外 ");
e.printStackTrace();
}
return i;
}
public static ResultSet selectSql(String sql){
try{
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
}catch(Exception e){
System.out.println("資料庫查詢例外");
e.printStackTrace();
}
return rs;
}
public static void closeConn(){
try{
conn.close();
}catch(Exception e){
System.out.println("資料庫關閉例外");
e.printStackTrace();
}
}
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/57387.html
標籤：MySQL
上一篇：mysql表索引設計問題。