fork download
copy 
  1. My Select Quesry looks like: 
  2. SELECT u.User_ID,u.FirstName,u.MiddleName,u.LastName,u.Email,u.WorkPhone,u.OrganizationName,us.Username,us.Password,us.Status_ID FROM User u, UserSecurity us WHERE u.User_ID = us.User_ID AND u.User_ID=?
  3.  
  4. The two classes are
  5.  
  6.  
  7.  
  8. import javax.persistence.Entity;
  9. import javax.persistence.Table;
  10. import javax.persistence.Id;
  11. import javax.persistence.Column;
  12.  
  13. 	@Entity
  14. 	@Table(name="UserSecurity")
  15. 	public class UserSecurity {
  16.  
  17. 		@Id
  18. 		@Column(name="User_ID")
  19. 		private int userId;
  20.  
  21. 		@Column(name="Username")
  22. 		private String username;
  23.  
  24. 		@Column(name="Password")
  25. 		private String password;
  26.  
  27. 		@Column(name="CorporateAccount_ID")
  28. 		private int corporateAccountId;
  29.  
  30. 		@Column(name="UserType_ID")
  31. 		private int userTypeId;
  32.  
  33. 		@Column(name="Registration_DT")
  34. 		private String registrationDt;
  35.  
  36. 		@Column(name="Activation_DT")
  37. 		private String activationDt;
  38.  
  39. 		@Column(name="LastLogin_DT")
  40. 		private String lastLoginDt;
  41.  
  42. 		@Column(name="Status_ID")
  43. 		private int statusId;
  44.  
  45. 		@Column(name="LoggedIn")
  46. 		private int loggedIn;
  47.  
  48. 		@Column(name="Agency_ID")
  49. 		private int agencyId;
  50.  
  51. 		@Column(name="Role_ID")
  52. 		private int roleId;
  53.  
  54. 		@Column(name="Group_ID")
  55. 		private int groupId;
  56.  
  57. 		@Column(name="UserAccountType_ID")
  58. 		private int userAccountTypeId;
  59.  
  60. 		@Column(name="LoginCount")
  61. 		private int loginCount;
  62.  
  63. 		@Column(name="LastUpdatedDate")
  64. 		private String lastUpdatedDate;
  65.  
  66. 		@Column(name="AgreedFlag")
  67. 		private int agreedFlag;
  68.  
  69. 		@Column(name="LastAgreeDate")
  70. 		private String lastAgreeDate;
  71.  
  72. 		public int getUserId() {
  73. 			return userId;
  74. 		}
  75.  
  76. 		public void setUserId(int userId) {
  77. 			this.userId = userId;
  78. 		}
  79.  
  80. 		public String getUsername() {
  81. 			return username;
  82. 		}
  83.  
  84. 		public void setUsername(String username) {
  85. 			this.username = username;
  86. 		}
  87.  
  88. 		public String getPassword() {
  89. 			return password;
  90. 		}
  91.  
  92. 		public void setPassword(String password) {
  93. 			this.password = password;
  94. 		}
  95.  
  96. 		public int getCorporateAccountId() {
  97. 			return corporateAccountId;
  98. 		}
  99.  
  100. 		public void setCorporateAccountId(int corporateAccountId) {
  101. 			this.corporateAccountId = corporateAccountId;
  102. 		}
  103.  
  104. 		public int getUserTypeId() {
  105. 			return userTypeId;
  106. 		}
  107.  
  108. 		public void setUserTypeId(int userTypeId) {
  109. 			this.userTypeId = userTypeId;
  110. 		}
  111.  
  112. 		public String getRegistrationDt() {
  113. 			return registrationDt;
  114. 		}
  115.  
  116. 		public void setRegistrationDt(String registrationDt) {
  117. 			this.registrationDt = registrationDt;
  118. 		}
  119.  
  120. 		public String getActivationDt() {
  121. 			return activationDt;
  122. 		}
  123.  
  124. 		public void setActivationDt(String activationDt) {
  125. 			this.activationDt = activationDt;
  126. 		}
  127.  
  128. 		public String getLastLoginDt() {
  129. 			return lastLoginDt;
  130. 		}
  131.  
  132. 		public void setLastLoginDt(String lastLoginDt) {
  133. 			this.lastLoginDt = lastLoginDt;
  134. 		}
  135.  
  136. 		public int getStatusId() {
  137. 			return statusId;
  138. 		}
  139.  
  140. 		public void setStatusId(int statusId) {
  141. 			this.statusId = statusId;
  142. 		}
  143.  
  144. 		public int getLoggedIn() {
  145. 			return loggedIn;
  146. 		}
  147.  
  148. 		public void setLoggedIn(int loggedIn) {
  149. 			this.loggedIn = loggedIn;
  150. 		}
  151.  
  152. 		public int getAgencyId() {
  153. 			return agencyId;
  154. 		}
  155.  
  156. 		public void setAgencyId(int agencyId) {
  157. 			this.agencyId = agencyId;
  158. 		}
  159.  
  160. 		public int getRoleId() {
  161. 			return roleId;
  162. 		}
  163.  
  164. 		public void setRoleId(int roleId) {
  165. 			this.roleId = roleId;
  166. 		}
  167.  
  168. 		public int getGroupId() {
  169. 			return groupId;
  170. 		}
  171.  
  172. 		public void setGroupId(int groupId) {
  173. 			this.groupId = groupId;
  174. 		}
  175.  
  176. 		public int getUserAccountTypeId() {
  177. 			return userAccountTypeId;
  178. 		}
  179.  
  180. 		public void setUserAccountTypeId(int userAccountTypeId) {
  181. 			this.userAccountTypeId = userAccountTypeId;
  182. 		}
  183.  
  184. 		public int getLoginCount() {
  185. 			return loginCount;
  186. 		}
  187.  
  188. 		public void setLoginCount(int loginCount) {
  189. 			this.loginCount = loginCount;
  190. 		}
  191.  
  192. 		public String getLastUpdatedDate() {
  193. 			return lastUpdatedDate;
  194. 		}
  195.  
  196. 		public void setLastUpdatedDate(String lastUpdatedDate) {
  197. 			this.lastUpdatedDate = lastUpdatedDate;
  198. 		}
  199.  
  200. 		public int getAgreedFlag() {
  201. 			return agreedFlag;
  202. 		}
  203.  
  204. 		public void setAgreedFlag(int agreedFlag) {
  205. 			this.agreedFlag = agreedFlag;
  206. 		}
  207.  
  208. 		public String getLastAgreeDate() {
  209. 			return lastAgreeDate;
  210. 		}
  211.  
  212. 		public void setLastAgreeDate(String lastAgreeDate) {
  213. 			this.lastAgreeDate = lastAgreeDate;
  214. 		}
  215.  
  216.  
  217. }
  218.  
  219.  
  220.  
  221.  
  222.  
  223.  
  224. import javax.persistence.Entity;
  225. import javax.persistence.Table;
  226. import javax.persistence.Id;
  227. import javax.persistence.GeneratedValue;
  228. import javax.persistence.Column;
  229.  
  230. 	@Entity
  231. 	@Table(name="User")
  232. 	public class User {
  233.  
  234. 		@Id
  235. 		@GeneratedValue
  236. 		@Column(name="User_ID")
  237. 		private int userId;
  238.  
  239. 		@Column(name="FirstName")
  240. 		private String firstName;
  241.  
  242. 		@Column(name="MiddleName")
  243. 		private String middleName;
  244.  
  245. 		@Column(name="LastName")
  246. 		private String lastName;
  247.  
  248. 		@Column(name="Email")
  249. 		private String email;
  250.  
  251. 		@Column(name="WorkPhone")
  252. 		private String workPhone;
  253.  
  254. 		@Column(name="HomePhone")
  255. 		private String homePhone;
  256.  
  257. 		@Column(name="CellPhone")
  258. 		private String cellPhone;
  259.  
  260. 		@Column(name="FaxNumber")
  261. 		private String faxNumber;
  262.  
  263. 		@Column(name="Address_ID")
  264. 		private int addressId;
  265.  
  266. 		@Column(name="Designation")
  267. 		private String designation;
  268.  
  269. 		@Column(name="OrganizationName")
  270. 		private String organizationName;
  271.  
  272. 		@Column(name="OrganizationType_ID")
  273. 		private int organizationTypeId;
  274.  
  275. 		@Column(name="OrganizationSize_ID")
  276. 		private int OrganizationSizeId;
  277.  
  278. 		@Column(name="Revenue_ID")
  279. 		private int revenueId;
  280.  
  281. 		@Column(name="OrgRole_ID")
  282. 		private int orgRoleId;
  283.  
  284. 		@Column(name="HowHearAboutUs_ID")
  285. 		private int howHearAboutUsId;
  286.  
  287. 		@Column(name="MailingListFlag")
  288. 		private int mailingListFlag;
  289.  
  290. 		@Column(name="Comments")
  291. 		private String comments;
  292.  
  293. 		public int getUserId() {
  294. 			return userId;
  295. 		}
  296.  
  297. 		public void setUserId(int userId) {
  298. 			this.userId = userId;
  299. 		}
  300.  
  301. 		public String getFirstName() {
  302. 			return firstName;
  303. 		}
  304.  
  305. 		public void setFirstName(String firstName) {
  306. 			this.firstName = firstName;
  307. 		}
  308.  
  309. 		public String getMiddleName() {
  310. 			return middleName;
  311. 		}
  312.  
  313. 		public void setMiddleName(String middleName) {
  314. 			this.middleName = middleName;
  315. 		}
  316.  
  317. 		public String getLastName() {
  318. 			return lastName;
  319. 		}
  320.  
  321. 		public void setLastName(String lastName) {
  322. 			this.lastName = lastName;
  323. 		}
  324.  
  325. 		public String getEmail() {
  326. 			return email;
  327. 		}
  328.  
  329. 		public void setEmail(String email) {
  330. 			this.email = email;
  331. 		}
  332.  
  333. 		public String getWorkPhone() {
  334. 			return workPhone;
  335. 		}
  336.  
  337. 		public void setWorkPhone(String workPhone) {
  338. 			this.workPhone = workPhone;
  339. 		}
  340.  
  341. 		public String getHomePhone() {
  342. 			return homePhone;
  343. 		}
  344.  
  345. 		public void setHomePhone(String homePhone) {
  346. 			this.homePhone = homePhone;
  347. 		}
  348.  
  349. 		public String getCellPhone() {
  350. 			return cellPhone;
  351. 		}
  352.  
  353. 		public void setCellPhone(String cellPhone) {
  354. 			this.cellPhone = cellPhone;
  355. 		}
  356.  
  357. 		public String getFaxNumber() {
  358. 			return faxNumber;
  359. 		}
  360.  
  361. 		public void setFaxNumber(String faxNumber) {
  362. 			this.faxNumber = faxNumber;
  363. 		}
  364.  
  365. 		public int getAddressId() {
  366. 			return addressId;
  367. 		}
  368.  
  369. 		public void setAddressId(int addressId) {
  370. 			this.addressId = addressId;
  371. 		}
  372.  
  373. 		public String getDesignation() {
  374. 			return designation;
  375. 		}
  376.  
  377. 		public void setDesignation(String designation) {
  378. 			this.designation = designation;
  379. 		}
  380.  
  381. 		public String getOrganizationName() {
  382. 			return organizationName;
  383. 		}
  384.  
  385. 		public void setOrganizationName(String organizationName) {
  386. 			this.organizationName = organizationName;
  387. 		}
  388.  
  389. 		public int getOrganizationTypeId() {
  390. 			return organizationTypeId;
  391. 		}
  392.  
  393. 		public void setOrganizationTypeId(int organizationTypeId) {
  394. 			this.organizationTypeId = organizationTypeId;
  395. 		}
  396.  
  397. 		public int getOrganizationSizeId() {
  398. 			return OrganizationSizeId;
  399. 		}
  400.  
  401. 		public void setOrganizationSizeId(int organizationSizeId) {
  402. 			OrganizationSizeId = organizationSizeId;
  403. 		}
  404.  
  405. 		public int getRevenueId() {
  406. 			return revenueId;
  407. 		}
  408.  
  409. 		public void setRevenueId(int revenueId) {
  410. 			this.revenueId = revenueId;
  411. 		}
  412.  
  413. 		public int getOrgRoleId() {
  414. 			return orgRoleId;
  415. 		}
  416.  
  417. 		public void setOrgRoleId(int orgRoleId) {
  418. 			this.orgRoleId = orgRoleId;
  419. 		}
  420.  
  421. 		public int getHowHearAboutUsId() {
  422. 			return howHearAboutUsId;
  423. 		}
  424.  
  425. 		public void setHowHearAboutUsId(int howHearAboutUsId) {
  426. 			this.howHearAboutUsId = howHearAboutUsId;
  427. 		}
  428.  
  429. 		public int getMailingListFlag() {
  430. 			return mailingListFlag;
  431. 		}
  432.  
  433. 		public void setMailingListFlag(int mailingListFlag) {
  434. 			this.mailingListFlag = mailingListFlag;
  435. 		}
  436.  
  437. 		public String getComments() {
  438. 			return comments;
  439. 		}
  440.  
  441. 		public void setComments(String comments) {
  442. 			this.comments = comments;
  443. 		}
  444.  
  445.  
  446.  
  447.  
  448.  
  449.  
  450.  
  451.  
  452.  
  453. }
  454.  
Compilation error #stdin compilation error #stdout 0s 0KB
comments (?)
stdin
copy 
Standard input is empty
compilation info 
Main.java:1: error: class, interface, or enum expected
My Select Quesry looks like: 
^
Main.java:222: error: class, interface, or enum expected
package nasdaq.db;
^
Main.java:224: error: class, interface, or enum expected
import javax.persistence.Entity;
^
Main.java:225: error: class, interface, or enum expected
import javax.persistence.Table;
^
Main.java:226: error: class, interface, or enum expected
import javax.persistence.Id;
^
Main.java:227: error: class, interface, or enum expected
import javax.persistence.GeneratedValue;
^
Main.java:228: error: class, interface, or enum expected
import javax.persistence.Column;
^
7 errors
stdout
copy 
Standard output is empty
https://ideone.com/c9ZJuP
language:
Java (HotSpot 12)
created:
12 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!