数据库 | Access | MySQL | Oracle |
SQL语句 | select * from UserInfo where sex=? and age>? | select * from UserInfo where sex=?sex and age>?age | select * from UserInfo where sex=:sex and age>:age |
参数 | OleDbParameter | MySqlParameter | OracleParameter |
实例化参数 | OleDbParameter p=new OleDbParameter(“?”, OleDbType. Boolean); | MySqlParameter p=new MySqlParameter(“?sex”, MySqlDbType.Bit); | OracleParameter p=new OracleParameter(“:sex”, OracleType.Byte); |
赋值 | p.Value=true; | p.Value=1; | p.Value=1; |
JDBC:参数化SQL
最新推荐文章于 2024-08-15 03:38:27 发布