CREATE TABLE `validate_student` (
`id` varchar(20) NOT NULL,
`passwd` varchar(20) NOT NULL DEFAULT '12345',
PRIMARY KEY (`id`),
CONSTRAINT `id` FOREIGN KEY (`id`) REFERENCES `student`
(`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8
/**
* 学生登录验证
*
* @param id
* @param passwd
* @throws SQLException
* @author snowalker
* @return String_tag
*/
@Override
@GET
@Path("student/{id}/{passwd}")
public String validateStudentByIdAndPasswd(@PathParam("id") String id, @PathParam("passwd") String passwd) throws SQLException {
// 建立连接
Connection connection = new Conn().getCon();
// 根据id获取数据
String sql = "select * from validate_student where id='" + id + "'";
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery(sql);
while (rs.next()) {
String passwdInDB = rs.getString("passwd");
System.out.println(passwdInDB);
if (passwd.equals(passwdInDB)) {
return "登陆成功";
} else {
return "登录失败";
}
}
return sql;
}
测试ip
http://119.29.3.138:8080/eback/webapi/loginValidate/student/2013005620/12345
返回:success
数据传输方式为明文,应当使用加密方式传输。