oracle语句
String sql = "insert into t_mc_type(nid,sname,npid,norder) values (seq_t_mc_type.nextval,?,?,?)";求对应Mysql语句,跪求!!谢谢!!!
String sql = "insert into t_mc_type(nid,sname,npid,norder) values (seq_t_mc_type.nextval,?,?,?)";求对应Mysql语句,跪求!!谢谢!!!
/**
* 添加商品类别.
*
* @param mcTypeBean
* 商品类别对象.
* @return 添加是否成功.
*/
public boolean insertMcType(McTypeBean mcTypeBean) {
int count = 0;
DataSource ds = Conn.getDS();
if (ds != null) {
QueryRunner qr = new QueryRunner(ds);
String sql = "insert into t_mc_type(nid,sname,npid,norder) values (seq_t_mc_type.nextval,?,?,?)";
Object[] tmp = { mcTypeBean.getSname(), mcTypeBean.getNpid(),
mcTypeBean.getNorder() };
try {
count = qr.update(sql, tmp);
} catch (SQLException e) {
e.printStackTrace();
}
}
if (count != 0) {
return true;
} else {
return false;
}
}