java 调用mysql的事务如何传入查询参数？

2024-12-01 10:26:42

推荐回答（5个）

回答1：

Statement换成preparedStatement，就有相应的set方法了。

或者既然addBatch里面传入的是String类型，那我们自己构造，

stmt.addBatch(“insert into users values ("+"values1"+","+"values2"+");");

或者既然是users类，我们可以根据users中属性是否为初始值来自动生成inset语句，下面是我以前写的代枣羡槐码，仅供参考

注释：

1、下面的User.NAME等就是user中name属性在表中的列名

2、方法ConvertStr就是把插入的列的value加上单引号。

private static String ConvertStr(Object object) {

return "'"凳友 + object.toString() + "'";

}

3、其他

public static final String strIns = "insert into users(";

public static final String strVal = ") values(";

派宽 public static final String strEnd = ");";

4、调用

stmt.addBatch(User.InsetStr(user));//这样就不用考虑传参了

代码如下：

public static String InsetStr(User user) {
        String StrCol = "";
        String Values = "";
        if (user.getName() != null && !user.getName().equals("")) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.NAME;
                Values = Values + "," + ConvertStr(user.getName());
            } else {
                StrCol = StrCol + User.NAME;
                Values = Values + ConvertStr(user.getName());
            }
        }
        if (user.getNick() != null && !user.getNick().equals("")) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.NICK;
                Values = Values + "," + ConvertStr(user.getNick());
            } else {
                StrCol = StrCol + User.NICK;
                Values = Values + ConvertStr(user.getNick());
            }
        }
        if (user.getStudentid() != 0) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.STUDENTID;
                Values = Values + "," + ConvertStr(user.getStudentid());
            } else {
                StrCol = StrCol + User.STUDENTID;
                Values = Values + ConvertStr(user.getStudentid());
            }
        }
        if (user.getSex() != '') {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.SEX;
                Values = Values + "," + ConvertStr(user.getSex());
            } else {
                StrCol = StrCol + User.SEX;
                Values = Values + ConvertStr(user.getSex());
            }
        }
        if (user.getPassword() != null && !user.getPassword().equals("")) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.PASSWORD;
                Values = Values + "," + ConvertStr(user.getPassword());
            } else {
                StrCol = StrCol + User.PASSWORD;
                Values = Values + ConvertStr(user.getPassword());
            }
        }
        if (user.getHash() != null && !user.getHash().equals("")) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.HASH;
                Values = Values + "," + ConvertStr(user.getHash());
            } else {
                StrCol = StrCol + User.HASH;
                Values = Values + ConvertStr(user.getHash());
            }
        }
        if (user.getSchool() != null && !user.getSchool().equals("")) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.SCHOOL;
                Values = Values + "," + ConvertStr(user.getSchool());
            } else {
                StrCol = StrCol + User.SCHOOL;
                Values = Values + ConvertStr(user.getSchool());
            }
        }
        if (user.getMajor() != null && !user.getMajor().equals("")) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.MAJOR;
                Values = Values + "," + ConvertStr(user.getMajor());
            } else {
                StrCol = StrCol + User.MAJOR;
                Values = Values + ConvertStr(user.getMajor());
            }
        }
        if (user.getMobile() != 0) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.MOBILE;
                Values = Values + "," + ConvertStr(user.getMobile());
            } else {
                StrCol = StrCol + User.MOBILE;
                Values = Values + ConvertStr(user.getMobile());
            }
        }
        if (user.getCollege() != null && !user.getCollege().equals("")) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.COLLEGE;
                Values = Values + "," + ConvertStr(user.getCollege());
            } else {
                StrCol = StrCol + User.COLLEGE;
                Values = Values + ConvertStr(user.getCollege());
            }
        }
        if (user.getGrade() != 0) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.GRADE;
                Values = Values + "," + ConvertStr(user.getGrade());
            } else {
                StrCol = StrCol + User.GRADE;
                Values = Values + ConvertStr(user.getGrade());
            }
        }
        if (user.getBclass() != null && !user.getBclass().equals("")) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.BCLASS;
                Values = Values + "," + ConvertStr(user.getBclass());
            } else {
                StrCol = StrCol + User.BCLASS;
                Values = Values + ConvertStr(user.getBclass());
            }
        }
        if (user.getIdnum() != null && !user.getIdnum().equals("")) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.IDNUM;
                Values = Values + "," + ConvertStr(user.getIdnum());
            } else {
                StrCol = StrCol + User.IDNUM;
                Values = Values + ConvertStr(user.getIdnum());
            }
        }
        if (user.getEmail() != null && !user.getEmail().equals("")) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.EMAIL;
                Values = Values + "," + ConvertStr(user.getEmail());
            } else {
                StrCol = StrCol + User.EMAIL;
                Values = Values + ConvertStr(user.getEmail());
            }
        }
        if (user.getRegip() != null && !user.getRegip().equals("")) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.REGIP;
                Values = Values + "," + ConvertStr(user.getRegip());
            } else {
                StrCol = StrCol + User.REGIP;
                Values = Values + ConvertStr(user.getRegip());
            }
        }
        if (user.getRegdate() != 0) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.REGDATE;
                Values = Values + "," + ConvertStr(user.getRegdate());
            } else {
                StrCol = StrCol + User.REGDATE;
                Values = Values + ConvertStr(user.getRegdate());
            }
        }
        if (user.getUnit() != null && !user.getUnit().equals("")) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.UNIT;
                Values = Values + "," + ConvertStr(user.getUnit());
            } else {
                StrCol = StrCol + User.UNIT;
                Values = Values + ConvertStr(user.getUnit());
            }
        }
        if (user.getRegion() != null && !user.getRegion().equals("")) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.REGION;
                Values = Values + "," + ConvertStr(user.getRegion());
            } else {
                StrCol = StrCol + User.REGION;
                Values = Values + ConvertStr(user.getRegion());
            }
        }
        if (user.getDepartments() != null && !user.getDepartments().equals("")) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.DEPARTMENTS;
                Values = Values + "," + ConvertStr(user.getDepartments());
            } else {
                StrCol = StrCol + User.DEPARTMENTS;
                Values = Values + ConvertStr(user.getDepartments());
            }
        }
        if (user.getTdcj() > 0) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.TDCJ;
                Values = Values + "," + ConvertStr(user.getTdcj());
            } else {
                StrCol = StrCol + User.TDCJ;
                Values = Values + ConvertStr(user.getTdcj());
            }
        }
        if (user.getTzcj() > 0) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.TZCJ;
                Values = Values + "," + ConvertStr(user.getTzcj());
            } else {
                StrCol = StrCol + User.TZCJ;
                Values = Values + ConvertStr(user.getTzcj());
            }
        }
        if (user.getAddress() != null && !user.getAddress().equals("")) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.ADDRESS;
                Values = Values + "," + ConvertStr(user.getAddress());
            } else {
                StrCol = StrCol + User.ADDRESS;
                Values = Values + ConvertStr(user.getAddress());
            }
        }
        if (user.getPostcode() != 0) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.POSTCODE;
                Values = Values + "," + ConvertStr(user.getPostcode());
            } else {
                StrCol = StrCol + User.POSTCODE;
                Values = Values + ConvertStr(user.getPostcode());
            }
        }
        if (user.getBankcard() != 0) {
            if (!StrCol.equals("")) {
                StrCol = StrCol + "," + User.BANKCARD;
                Values = Values + "," + ConvertStr(user.getBankcard());
            } else {
                StrCol = StrCol + User.BANKCARD;
                Values = Values + ConvertStr(user.getBankcard());
            }
        }
        return Sql.strIns + StrCol + Sql.strVal + Values + Sql.strEnd;
    }

回答2：

参数可以封装在一个javabean中，从javabean中取仔姿得参弯嫌数，埋戚手比如：
stmt.setXxx(1, javaBean.getXxx());
stmt.setXxx(2, javaBean.getXxx());
stmt.setXxx(3, javaBean.getXxx());
stmt.setXxx(4, javaBean.getXxx());

回答3：

直接在sql语句后边追加where 查询条件，这样就可以进行查询参数查询了

回答4：

你是要宽誉查询还是插入???
查询的话参数肯定通过方法参数传入
插入的话加事务也不是你这样加的啊
生成Statement之歼卖前调用以下代码,设慎改段置手动提交
conn.setAutoCommit(false);
所有SQL语句执行完成后conn.commit()提交整个事务,如果有异常rollback回滚事务.

回答5：

使用有？号物粗这样的SQL语句，需要使用的是PreparedStatement
不是Statement

使用方法如下，你局搏参考一下。

---------------------------------------------------------------------------------
String sql = "桐蚂祥insert into users values (?,?,?,?);";
PreparedStatement pst = conn.prepareStatement(sql);
pst.setObject(1, xxxx);
pst.setObject(2, yyy);
pst.setObject(3, zzz);
pst.setObject(4, nnnnn);
ResultSet rs = pst.executeQuery();

最新问答

2012山西考生未达一本线不能报一本志愿吗分数线刚下山西理 2本 476

想知道: 沈阳市沈阳天士力医药连锁有限公司在哪

约相亲的女孩，连着三天约了三次，都说没时间，什么意思？

你能用配方法求代数式3x^+6x-5的最小值吗？

960÷(16×5-20)的简便运算怎么写？

国有资金的建设工程，必须通过财政部门的政府采购方式招标吗？招标代理机构招标可以吗？