研究了很多天,终于能够把数据库获取的数据成功转换成jsonObject对象
重要代码:
NoticeDaoImpl.java
try {
conn3 = DBUtil.getConnection();
st3 = conn3.createStatement();
rs3 = st3
.executeQuery("SELECT [noticeID] ,[range],[expiration],[title],[info]"
+ " ,[orgID],[depID],[usersID],[affix] ,[logDate]"
+ " FROM [WisdomOffice].[dbo].[Notice]");
result3.append("{'noticeList':[");
if (rs3 != null) {
while (rs3.next()) {
int id = rs3.getInt(1);
String range = rs3.getString(2);
String expiration = rs3.getString(3);
String title = rs3.getString(4);
String info = rs3.getString(5);
int orgId = rs3.getInt(6);
int depid = rs3.getInt(7);
int userId = rs3.getInt(8);