}
}
public void test_sql_error() throws Exception {
try {
Sql selectSql = new SqlFactory().parseSql("update user_info1 set username = :username where password = :password and age=:age and sex=:sex");
fail();
}catch(Exception e){
assertTrue(true);
}
try {
Sql selectSql = new SqlFactory().parseSql("insert into user_info (username,password) values(?,?,?)");
fail();
}catch(Exception e){
assertTrue(true);
}
try {
Sql selectSql = new SqlFactory().parseSql("delete from user_info where 123username1javaeye = :username and password123 = :password and age=:age and sex=:sex");
fail("列错误");
}catch(Exception e){
e.printStackTrace();
assertTrue(true);
}
try {
Sql selectSql = new SqlFactory().parseSql("select * from user_info where username = :username and password =:password and age=1:age ");
fail();
}catch(Exception e){
assertTrue(true);
}
try {
Sql selectSql = new SqlFactory().parseSql("insert into userinfo2 values(:username,:password,:age,:sex)");
fail();
}catch(Exception e){
assertTrue(true);
}
}