操作系统体系结构
底层 从 linux
上层 windows 网站;
同学录 :app
后台:作为app提供数据 业务管理
创建工程spriingboot
1下载开发intelijlde 百度
配置环境:jdk maven
创建project 选择springintiazer 官网 创建工程
创建工程结构
entriy
从troller
service
common
dao
private int login(String telephone,String password) throws IOException, JSONException {
int returnResult=0;
//建立网络连接
String urlstr=“你的服务器url地址”;
URL url=new URL(urlstr);
HttpURLConnection http=(HttpURLConnection)url.openConnection(); http.setDoOutput(true);
http.setDoInput(true);
http.setRequestMethod(“POST”);
http.setUseCaches(false);
http.setRequestProperty(“Content-type”, “application/json;charset=utf-8”);
http.connect();
//获取输入流,想服务器写入数据
OutputStream out=http.getOutputStream();
//post请求
JSONObject data=new JSONObject();
data.put(“telephone”,telephone);
data.put(“password”,password);
out.write(data.toString().getBytes());
out.flush();
out.close();
//读取网页返回的数据
BufferedReader bufferedReader=new BufferedReader(new InputStreamReader(http.getInputStream()));//获取输入流
String line="";
StringBuilder builder=new StringBuilder();//建立输入缓冲区
while(null !=(line=bufferedReader.readLine())){ //结束会读入一个null值
line=new String(line.getBytes(),“utf-8”);
builder.append(line); //写缓冲区
}
String result=builder.toString(); //返回结果
bufferedReader.close();
http.disconnect();
try{
//获取服务器返回的Json数据
JSONObject jsonObject=new JSONObject(result);
returnResult=jsonObject.getInt(“status”);
if(returnResult !=0){
user_account=jsonObject.getString(“telephone”);
address=jsonObject.getString(“address”);
username=jsonObject.getString(“username”);
sex=jsonObject.getString(“sex”);
if(username == null){
username =“未输入昵称”;
}
}
} catch (JSONException e) {
Log.e(“log_tag”, "the Error parsing data "+e.toString());
}
return returnResult;
}
测试接口工具
构建请求地址
url=new Uel(urlstr);
// 执行SQL查询语句
return sta.execute(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return false;
}
// 关闭数据库连接
public void closeConnect() {
try {
if (rs != null) {
rs.close();
}
if (sta != null) {
sta.close();
}
if (conn != null) {
conn.close();
}
System.out.println(“关闭数据库连接成功”);
} catch (SQLException e) {
System.out.println("Error: " + e.getMessage());
}
}
}
// 请求数据库
DBUtils dbUtils = new DBUtils();
dbUtils.openConnect();
// 打开数据库连接
BaseBean data = new BaseBean(); // 基类对象,回传给客户端的json对象
UserBean userBean = new UserBean(); // user的对象
if (dbUtils.isExistInDB(username, password)) {
// 判断账号是否存在
data.setCode(-1);
data.setData(userBean);
data.setMsg(“该账号已存在”);
} else if (!dbUtils.insertDataToDB(username, password)) {
// 注册成功
data.setCode(0);
data.setMsg(“注册成功!!”);