package cn.com.jsp.goods.dao.impl;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import cn.com.jsp.goods.vo.GoodsModel;
public class JdbcImpl {
public static boolean creat (GoodsModel gm) throws ClassNotFoundException, SQLException{
Connection conn=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "goods", "goods");
String sql="insert into tbl_goods(uuid,name,decription,price) values(?,?,?,?)";
if(conn==null){
System.out.println("连接失败");
}else{
System.out.println(sql);
}
PreparedStatement pstmt=conn.prepareStatement(sql); //从这句之后就执行不到了
pstmt.setInt(1, gm.getUuid());
pstmt.setString(2, gm.getName());
pstmt.setString(3, gm.getDescription());
pstmt.setFloat(4, gm.getPrice());
pstmt.executeUpdate();
pstmt.close();
conn.close();
return true;
}
public static void main(String[] args) throws ClassNotFoundException, SQLException {
GoodsModel gm=new GoodsModel();
gm.setUuid(1);
gm.setName("wang");
gm.setDescription("ddddd");
gm.setPrice(50.2F);
boolean ss=JdbcImpl.creat(gm);
System.out.println("结果是"+ss);
}
}
----------------------------------------------下面是GoodsModel代码---------------------------------------
package cn.com.jsp.goods.vo;
public class GoodsModel implements java.io.Serializable {
private int uuid;
private String name;
private String description;
private float price;
public int getUuid() {
return uuid;
}
public void setUuid(int uuid) {
this.uuid = uuid;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getDescription() {
return description;
}
public void setDescription(String description) {
this.description = description;
}
public float getPrice() {
return price;
}
public void setPrice(float price) {
this.price = price;
}
@Override
public int hashCode() {
final int prime = 31;
int result = 1;
result = prime * result + uuid;
return result;
}
@Override
public boolean equals(Object obj) {
if (this == obj)
return true;
if (obj == null)
return false;
if (getClass() != obj.getClass())
return false;
final GoodsModel other = (GoodsModel) obj;
if (uuid != other.uuid)
return false;
return true;
}
}
------------------------------------运行报错信息如下-----------------------------------
Exception in thread "main" java.sql.SQLException: ORA-00904: "DECRIPTION": 标识符无效
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:952)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
at cn.com.jsp.goods.dao.impl.JdbcImpl.creat(JdbcImpl.java:30)
at cn.com.jsp.goods.dao.impl.JdbcImpl.main(JdbcImpl.java:42) //发现不出这两个地方问题出在哪里?
请前辈费心指点一下,期待回复?