highcharts java json_如何使用json的数据格式给Highcharts赋值

展开全部

package cn.sdeit.beans;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import cn.sdeit.mysql.ConnectMySql;

public class User

{

private String email;

private String password;

private String rePassword;

private String tel;

private String name;

private String sex;

private String birthday;

private String university;

private String major;

private String sID;

private int year;

public User(String email, String password, String rePassword,

e5a48de588b662616964757a686964616f31333361323565String tel, String name, String sex, String birthday,

String university, String major, String sID, int year)

{

super();

this.email = email;

this.password = password;

this.rePassword = rePassword;

this.tel = tel;

this.name = name;

this.sex = sex;

this.birthday = birthday;

this.university = university;

this.major = major;

this.sID = sID;

this.year = year;

}

public User(String email)

{

super();

/*

* 此构造方法目的获取 UserBean 对象

* */

this.email = email;

}

public String getEmail()

{

return email;

}

public void setEmail(String email)

{

this.email = email;

}

public String getPassword()

{

return password;

}

public void setPassword(String password)

{

this.password = password;

}

public String getRePassword()

{

return rePassword;

}

public void setRePassword(String rePassword)

{

this.rePassword = rePassword;

}

public String getTel()

{

return tel;

}

public void setTel(String tel)

{

this.tel = tel;

}

public String getName()

{

return name;

}

public void setName(String name)

{

this.name = name;

}

public String getSex()

{

return sex;

}

public void setSex(String sex)

{

this.sex = sex;

}

public String getBirthday()

{

return birthday;

}

public void setBirthday(String birthday)

{

this.birthday = birthday;

}

public String getUniversity()

{

return university;

}

public void setUniversity(String university)

{

this.university = university;

}

public String getMajor()

{

return major;

}

public void setMajor(String major)

{

this.major = major;

}

public String getsID()

{

return sID;

}

public void setsID(String sID)

{

this.sID = sID;

}

public int getYear()

{

return year;

}

public void setYear(int year)

{

this.year = year;

}

public String getUserString()

{

return "邮箱：" + email + ""

+ "密码："+password+ ""

+ "号码：" + tel + ""

+ "姓名："+ name + ""

+ "性别：" + sex + ""

+ "生日：" + birthday+ ""

+ "学校：" + university + ""

+ "专业：" + major + ""

+ "学号："+ sID + ""

+ "入学年份：" + year;

}

public User getOnlineUserBean()

{

Connection connection = ConnectMySql.createConnection();

String sql = "select * from user where email = ?";

PreparedStatement prepared = ConnectMySql.createPreparedStatement(connection, sql);

User onlineUserBean = null;

try

{

prepared.setString(1, email);

ResultSet set = prepared.executeQuery();

while(set.next())

{

onlineUserBean = new User(set.getString("email"), set.getString("password"),

set.getString("password"), set.getString("tel"), set.getString("name"),

set.getString("sex"), set.getString("birthday"), set.getString("university"),

set.getString("major"), set.getString("sid"), set.getInt("year"));

}

connection.close();

} catch (SQLException e)

{

e.printStackTrace();

}

return onlineUserBean;

}

}