看了好久都没看出错误在哪里，请高手指点
/**
*
*/
package com.shop.conndb;
/**
* @author sunjiekun
*
*/
import javax.naming.*;
import javax.sql.DataSource;
import java.sql.*;
public class Condata {
private static Connection con;
ResultSet rs;
private static Context ctx;
private static Context env;
public static synchronized Connection getConnection() throws Exception{
try{
ctx=new InitialContext();
env=(Context)ctx.lookup( "java:comp/env ");
DataSource ds=(DataSource)env.lookup( "jdbc/sa ");
return con=ds.getConnection();
}
catch(SQLException e){
throw e;
}
catch(NamingException e){
throw e;
}
}
public ResultSet executeQuery(String sql){
try{
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sql);
}catch(SQLException er){
System.err.print(er.getMessage());
}
return rs;
}
public int executeUpdate(String sql){
int result=0;
try{
Statement stmt=con.createStatement();
result=stmt.executeUpdate(sql);
}catch(SQLException eer){
System.out.print(eer.getMessage());
}
return result;
}
public int executeUpdate_id(String sql)
{
int result=0;
try{
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
result=stmt.executeUpdate(sql);
String ID= "select @@IDENTITY as id ";
rs=stmt.executeQuery(ID);
if(rs.next())
{
int autoID=rs.getInt( "id ");
result=autoID;
}
}catch(SQLException ex)
{
result=0;
}
return result;
}
public void close(){
try{
if(con!=null){
con.close();
}
}catch(Exception err){
System.out.print(err);
}
try{
if(rs!=null){
rs.close();
}
}catch(Exception err){
System.out.print(err);
}
}
}
/**
*
*/
package com.shop.goods;
import com.shop.conndb.*;
import java.sql.*;
//import javax.sql.DataSource;
/**
* @author sunjiekun
*
*/
public class GoodsOperation implements GoodsInterface
{
private Condata con = new Condata();
private Connection conn;
chStr chStr = new chStr();
public GoodsOperation() throws Exception
{
conn=con.getConnection();
}
public int insert(goods g) {
int ret = -1;
try {
String sql = "Insert into tb_goods (TypeID,GoodsName,Introduce,Price,nowPrice,picture,newgoods,sale) values( " +
g.getTypeID() + ", ' " + chStr.chStr(g.getGoodsName()) + " ', ' " +
chStr.chStr(g.getIntroduce()) + " ', " + g.getPrice() + ", " +
g.getPrice() + ", ' " + chStr.chStr(g.getPicture()) + " ', " +
g.getNewGoods() + ", " + g.getSale() + ") ";
ret = conn.executeUpdate(sql);
}
catch (Exception e) {
ret = 0;
}
conn.close();
return ret;
}
public int update(goods g) {
int ret = -1;
try {
String sql = "update tb_Goods set TypeID= " +g.getTypeID() +
",GoodsName= ' " + chStr.chStr(g.getGoodsName()) + " ',introduce= ' " +
chStr.chStr(g.getIntroduce()) + " ',price= " + g.getPrice() +
",nowprice= " + g.getNowPrice() + ",picture= ' " + chStr.chStr(g.getPicture())+ " ',newgoods= " +
g.getNewGoods() + ",sale= " + g.getSale() + " where ID= " + g.getID();
ret = conn.executeUpdate(sql);
}
catch (Exception e) {
ret = 0;
}
conn.close();
return ret;
}
public int delete(goods g) {
int ret=-1;
try{
String sql= "Delete from tb_goods where ID= "+g.getID();
ret=conn.executeUpdate(sql);
}catch(Exception e){
ret=0;
}
conn.close();
return ret;
}
}
结果说没有为类型 Connection 定义方法 executeUpdate（String），是什么原因啊，不是已经定义好了吗
[解决办法]
這里的values( " +少了個 '符號啊,
樓主,把你的insert語句放到查詢分析器里面運行一下就知道錯誤了.
