public void testCRUD() throws HibernateException, SQLException {
if (isUsingIdentity()) {
reportSkip("hand sql expecting non-identity id gen", "Custom SQL");
return;
}
Person p = new Person();
p.setName("Max");
p.setLastName("Andersen");
p.setNationalID("110974XYZ�");
p.setAddress("P. P. Street 8");
Session s = openSession();
s.save(p);
s.flush();
s.connection().commit();
s.close();
getSessions().evict(Person.class);
s = openSession();
Person p2 = (Person) s.get(Person.class, p.getId());
assertNotSame(p, p2);
assertEquals(p2.getId(), p.getId());
assertEquals(p2.getLastName(), p.getLastName());
s.flush();
List list = s.createQuery("select p from Party as p").list();
assertTrue(list.size() == 1);
s.connection().commit();
s.close();
s = openSession();
list = s.createQuery("select p from Person as p where p.address = 'L�rkev�nget 1'").list();
assertTrue(list.size() == 0);
p.setAddress("L�rkev�nget 1");
s.update(p);
list = s.createQuery("select p from Person as p where p.address = 'L�rkev�nget 1'").list();
assertTrue(list.size() == 1);
list = s.createQuery("select p from Party as p where p.address = 'P. P. Street 8'").list();
assertTrue(list.size() == 0);
s.delete(p);
list = s.createQuery("select p from Person as p").list();
assertTrue(list.size() == 0);
s.connection().commit();
s.close();
}
public static void main(String[] args) {
Person p = new Person("John", "Jones");
System.out.println(p.getFirstName());
System.out.println(p.getLastName());
Account acct = new Account(p, 1);
acct.deposit(100);
System.out.println(acct.getBalance());
acct.deposit(45.50);
System.out.println(acct.getBalance());
if (acct.withdraw(95)) {
System.out.println("New Balance is " + acct.getBalance());
} else {
System.out.println("insufficent funds");
}
if (acct.withdraw(100)) {
System.out.println("New Balance is " + acct.getBalance());
} else {
System.out.println("insufficent funds");
}
System.out.println("Owner is: " + acct.getOwnersName());
System.out.println("Account number is: " + acct.getAcctNumber());
System.out.println("Transaction History: " + acct.getTransactions());
}
// Delete person from firebase and notify when successful
@Override
public void deletePerson(int position, Person person) {
String key = person.getFirstName() + " " + person.getLastName();
myFirebaseRef.child("people").child(key).removeValue();
Toast.makeText(this, key + " has been deleted", Toast.LENGTH_LONG).show();
// reload page
startActivity(new Intent(MainActivity.this, MainActivity.class));
}
public boolean equals(Person p) {
boolean check = false;
if (p.getLastName().equals(lastName)
&& p.getName().equals(firstName)
&& p.getSSN().equals(this.getSSN())) {
check = true;
}
return check;
}
public void updateLastName(Person person) throws DAOException {
PreparedStatement pstmt;
try {
pstmt = getConnection().prepareStatement("UPDATE Person set Lastname = ? WHERE id = ?");
} catch (SQLException ex) {
throw new DAOException(ex);
}
execute(pstmt, person.getLastName(), person.getId());
}
public void update(Person newValues) {
this.firstName = newValues.getFirstName();
this.lastName = newValues.getLastName();
this.fullName = this.firstName + " " + this.lastName;
this.street = newValues.getStreet();
this.city = newValues.getCity();
this.state = newValues.getState();
this.zip = newValues.getZip();
this.country = newValues.getCountry();
}
@Override
public Person process(final Person person) throws Exception {
final String firstName = person.getFirstName().toUpperCase();
final String lastName = person.getLastName().toUpperCase();
final Person transformedPerson = new Person(lastName, firstName);
log.info("Converting (" + person + ") into (" + transformedPerson + ")");
return transformedPerson;
}
public Person find(String searchName) // Pass Lastname as an argument
{
Person q = null;
for (Person p : a) {
if (p.getLastName().equals(searchName)) {
q = p;
break;
}
}
return q;
}
// Edit person. Pass current person info to Add.class
@Override
public void editPerson(int position, Person person) {
Intent i = new Intent(MainActivity.this, Add.class);
Bundle extra = new Bundle();
extra.putString("first", person.getFirstName());
extra.putString("last", person.getLastName());
extra.putString("zip", person.getZip());
extra.putString("dob", person.getDob());
i.putExtras(extra);
startActivity(i);
}
private static void oldSchool(List<Person> people) {
int oldestSipe = 0;
for (Person person : people) {
if (person.getLastName().equals("Sipe")) {
int age = person.getAge();
oldestSipe = Math.max(age, oldestSipe);
}
}
System.out.println("oldest sipe is: " + oldestSipe);
}
@Test
@Sql(
statements = {
"INSERT INTO Person (id, firstName, lastName)" + " VALUES (42, 'John', 'Smith')"
})
public void testGenerateSchema() throws Exception {
entityManager.getMetamodel().entity(Person.class);
// When the above call does not throw an exception,
// the Person class is mapped as a persistent entity.
Person p = entityManager.find(Person.class, 42L);
assertEquals("John", p.getFirstName());
assertEquals("Smith", p.getLastName());
}
@Override
public Person process(final Person person) throws Exception {
final String firstName = person.getFirstName().toUpperCase();
final String lastName = person.getLastName().toUpperCase();
final Person transformedPerson = new Person(firstName, lastName);
System.out.printf("Original person name: %s \n", person.toString());
System.out.printf("Transformed person name: %s", transformedPerson.toString());
log.info("Converting (" + person + ") into (" + transformedPerson + ")");
return transformedPerson;
}
public List query(PhoneBookQuery query) {
List res = new ArrayList();
Iterator it = persons.iterator();
while (it.hasNext()) {
Person person = (Person) it.next();
if ((person.getFirstName().indexOf(query.getFirstName()) != -1)
&& (person.getLastName().indexOf(query.getLastName()) != -1)) {
res.add(person);
}
}
return res;
}
private void setEvent(String eventId) {
Event e = MainModel.getEvent(eventId);
Person p = MainModel.getPerson(e.getPersonId());
String eventText =
p.getFirstName()
+ " "
+ p.getLastName()
+ System.getProperty("line.separator")
+ e.fullDescription();
// Log.e(tag, "setting event text to " + eventText);
event_text.setText(eventText);
selPersonId = e.getPersonId();
selEventId = eventId;
updateLines();
showGenderImage(p.getGender());
}
public boolean delete(String searchName) // Shift down the elements. Argument should be lastname
{
boolean found = false;
int index = -1;
for (Person p : a) {
if (p.getLastName().equals(searchName)) {
found = true;
break;
}
index++;
}
// shift elements in the person array backwards starting from a,
if (found)
for (int i = index; i < this.nElems - 1; i++) {
a[i] = a[i + 1];
}
a[this.nElems - 1] = null;
this.nElems--;
return found;
}
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_edit_person);
mEditFirstName = (EditText) findViewById(R.id.edit_change_name);
mEditLastName = (EditText) findViewById(R.id.edit_change_surname);
person = (Person) getIntent().getExtras().getSerializable(MainActivity.EXTRA_EDIT);
Persons persons = Persons.get();
position = persons.findPosition(person);
mEditFirstName.setText(person.getFirstName());
mEditLastName.setText(person.getLastName());
mSave = (Button) findViewById(R.id.save_button);
mSave.setOnClickListener(
new View.OnClickListener() {
@Override
public void onClick(View v) {
saveChanges();
}
});
}
private void addteammemberActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_addteammemberActionPerformed
JTextField fname = new JTextField();
JTextField lname = new JTextField();
JTextField position = new JTextField();
Object[] message = {
"First Name:", fname,
"Last Name:", lname,
"Position:", position,
};
int option =
JOptionPane.showConfirmDialog(
this, message, "Enter Team Member Information", JOptionPane.OK_CANCEL_OPTION);
if (option == JOptionPane.OK_OPTION) {
Person tm = new Person();
tm.setFirstName(fname.getText());
tm.setLastName(lname.getText());
tm.setPosition(position.getText());
currentProject.getTeamMembers().add(tm);
teammodel.addElement(tm.getFirstName() + " " + tm.getLastName() + " " + tm.getPosition());
teamlist.setModel(teammodel);
}
} // GEN-LAST:event_addteammemberActionPerformed
public static PersonContainer createWithTestData() {
final String[] fnames = {
"Peter", "Alice", "Joshua", "Mike", "Olivia", "Nina", "Alex", "Rita", "Dan", "Umberto",
"Henrik", "Rene", "Lisa", "Marge"
};
final String[] lnames = {
"Smith",
"Gordon",
"Simpson",
"Brown",
"Clavel",
"Simons",
"Verne",
"Scott",
"Allison",
"Gates",
"Rowling",
"Barks",
"Ross",
"Schneider",
"Tate"
};
final String cities[] = {
"Amsterdam",
"Berlin",
"Helsinki",
"Hong Kong",
"London",
"Luxemburg",
"New York",
"Oslo",
"Paris",
"Rome",
"Stockholm",
"Tokyo",
"Turku"
};
final String streets[] = {
"4215 Blandit Av.",
"452-8121 Sem Ave",
"279-4475 Tellus Road",
"4062 Libero. Av.",
"7081 Pede. Ave",
"6800 Aliquet St.",
"P.O. Box 298, 9401 Mauris St.",
"161-7279 Augue Ave",
"P.O. Box 496, 1390 Sagittis. Rd.",
"448-8295 Mi Avenue",
"6419 Non Av.",
"659-2538 Elementum Street",
"2205 Quis St.",
"252-5213 Tincidunt St.",
"P.O. Box 175, 4049 Adipiscing Rd.",
"3217 Nam Ave",
"P.O. Box 859, 7661 Auctor St.",
"2873 Nonummy Av.",
"7342 Mi, Avenue",
"539-3914 Dignissim. Rd.",
"539-3675 Magna Avenue",
"Ap #357-5640 Pharetra Avenue",
"416-2983 Posuere Rd.",
"141-1287 Adipiscing Avenue",
"Ap #781-3145 Gravida St.",
"6897 Suscipit Rd.",
"8336 Purus Avenue",
"2603 Bibendum. Av.",
"2870 Vestibulum St.",
"Ap #722 Aenean Avenue",
"446-968 Augue Ave",
"1141 Ultricies Street",
"Ap #992-5769 Nunc Street",
"6690 Porttitor Avenue",
"Ap #105-1700 Risus Street",
"P.O. Box 532, 3225 Lacus. Avenue",
"736 Metus Street",
"414-1417 Fringilla Street",
"Ap #183-928 Scelerisque Road",
"561-9262 Iaculis Avenue"
};
PersonContainer c = null;
Random r = new Random(0);
try {
c = new PersonContainer();
for (int i = 0; i < 100; i++) {
Person p = new Person();
p.setFirstName(fnames[r.nextInt(fnames.length)]);
p.setLastName(lnames[r.nextInt(lnames.length)]);
p.setCity(cities[r.nextInt(cities.length)]);
p.setEmail(
p.getFirstName().toLowerCase() + "." + p.getLastName().toLowerCase() + "@vaadin.com");
p.setPhoneNumber(
"+358 02 555 " + r.nextInt(10) + r.nextInt(10) + r.nextInt(10) + r.nextInt(10));
int n = r.nextInt(100000);
if (n < 10000) {
n += 10000;
}
p.setPostalCode(n);
p.setStreetAddress(streets[r.nextInt(streets.length)]);
c.addItem(p);
}
} catch (InstantiationException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IllegalAccessException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return c;
}
public void testPersonApplication() throws Exception {
PersonApplication pa = (PersonApplication) lookup(PersonApplication.ROLE);
// ----------------------------------------------------------------------
//
// ----------------------------------------------------------------------
Action addAction = (Action) lookup(Action.ROLE, "addEntity");
assertNotNull(addAction);
Map m = new HashMap();
m.put("id", "1");
m.put("formId", "person");
m.put("firstName", "jason");
m.put("lastName", "van Zyl");
m.put("data", new DefaultRunData());
addAction.execute(m);
Person p = pa.getPerson("1");
assertNotNull(p);
assertEquals("jason", p.getFirstName());
assertEquals("van Zyl", p.getLastName());
// ----------------------------------------------------------------------
// Now update the entity
// ----------------------------------------------------------------------
Action updateAction = (Action) lookup(Action.ROLE, "updateEntity");
assertNotNull(updateAction);
m = new HashMap();
m.put("id", "1");
m.put("formId", "person");
m.put("firstName", "sarel");
m.put("lastName", "van Zyl");
m.put("data", new DefaultRunData());
updateAction.execute(m);
p = pa.getPerson("1");
assertNotNull(p);
assertEquals("sarel", p.getFirstName());
assertEquals("van Zyl", p.getLastName());
// ----------------------------------------------------------------------
// Delete the entity
// ----------------------------------------------------------------------
Action deleteAction = (Action) lookup(Action.ROLE, "deleteEntity");
assertNotNull(deleteAction);
m = new HashMap();
m.put("id", "1");
m.put("formId", "person");
m.put("data", new DefaultRunData());
deleteAction.execute(m);
p = pa.getPerson("1");
assertNull(p);
}
public ViewProject(int id) {
initComponents();
currentProject = new Project();
currentProject.setProjectID(id);
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con =
DriverManager.getConnection(
"jdbc:mysql://127.0.0.1:3306/projectmanagementsystem?zeroDateTimeBehavior=convertToNull",
"root",
"password");
String query2 = "select * from project where idproject = ?";
PreparedStatement pst2 = con.prepareStatement(query2);
int projectid = id + 1;
pst2.setInt(1, projectid);
ResultSet rs = pst2.executeQuery();
if (rs.next()) {
projectname.setText(rs.getString("projectname"));
projectdescription.setText(rs.getString("projectdesc"));
}
String query3 = "select * from teammember where teammember_FK = ?";
PreparedStatement pst3 = con.prepareStatement(query3);
pst3.setInt(1, projectid);
ResultSet rs2 = pst3.executeQuery();
while (rs2.next()) {
Person p = new Person();
p.setFirstName(rs2.getString("firstname"));
p.setLastName(rs2.getString("lastname"));
p.setPosition(rs2.getString("position"));
p.setPersonID(rs2.getInt("idteammember"));
teammembers.add(p);
teammodel.addElement(p.getFirstName() + " " + p.getLastName() + " " + p.getPosition());
}
teamlist.setModel(teammodel);
String query4 = "select * from goal where goal_FK = ?";
PreparedStatement pst4 = con.prepareStatement(query4);
pst4.setInt(1, projectid);
ResultSet rs3 = pst4.executeQuery();
while (rs3.next()) {
Goal g = new Goal();
g.setGoalID(rs3.getInt("idgoal"));
g.setGoalDesc(rs3.getString("goaldesc"));
g.setGoalType(rs3.getString("goaltype"));
goals.add(g);
goalmodel.addElement(g.getGoalType() + " " + g.getGoalDesc());
}
goallist.setModel(goalmodel);
String query5 = "select * from requirement where requirement_FK = ?";
PreparedStatement pst5 = con.prepareStatement(query5);
pst5.setInt(1, projectid);
ResultSet rs4 = pst5.executeQuery();
while (rs4.next()) {
Requirement r = new Requirement();
String type;
r.setRequirementID(rs4.getInt("idrequirement"));
r.setRequirementDescription(rs4.getString("requirementdesc"));
if (rs4.getInt("isFunctionalRequirement") == 0) {
r.setIsFunctionalRequirement(false);
type = "Non-functional";
} else type = "Functional";
requirements.add(r);
requirementmodel.addElement(type + " " + r.getRequirementDescription());
}
requirementlist.setModel(requirementmodel);
String query6 = "select * from risk where risk_FK = ?";
PreparedStatement pst6 = con.prepareStatement(query6);
pst6.setInt(1, projectid);
ResultSet rs5 = pst6.executeQuery();
while (rs5.next()) {
Risk r = new Risk();
r.setRiskID(rs5.getInt("idrisk"));
r.setRiskName(rs5.getString("riskname"));
r.setRiskStatus(rs5.getString("riskstatus"));
risks.add(r);
riskmodel.addElement(r.getRiskStatus() + " " + r.getRiskName());
}
risklist.setModel(riskmodel);
String query7 =
"select * from effort join requirement on effort.effort_FK = requirement.idrequirement"
+ " where requirement.requirement_FK = ?";
PreparedStatement pst7 = con.prepareStatement(query7);
pst7.setInt(1, projectid);
ResultSet rs6 = pst7.executeQuery();
while (rs6.next()) {
Effort e = new Effort();
e.setEffortID(rs6.getInt("ideffort"));
e.setEffortDate(rs6.getString("effortdate"));
e.setEffortDevPhase(rs6.getString("effortdevphase"));
e.setEffortHours(rs6.getInt("efforthours"));
e.setRequirementID(rs6.getInt("effort_FK"));
e.setRequirementDesc(rs6.getString("requirementdesc"));
efforts.add(e);
effortmodel.addElement(
"For req: "
+ e.getRequirementDesc()
+ " "
+ e.getEffortDevPhase()
+ " "
+ e.getEffortDate()
+ " "
+ e.getEffortHours());
}
effortlist.setModel(effortmodel);
} catch (Exception e) {
System.out.println(e.toString());
}
}
@Override
public String getLastName() {
return mPerson.getLastName();
}
/** Create the frame. */
public MultipleResultDisplay(final ScanPackage frame, final List<Person> results) {
this.results = (ArrayList<Person>) results;
setBackground(new Color(0, 128, 0));
setTitle("Multiple Results");
setResizable(false);
setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setBounds(100, 100, 412, 232);
contentPane = new JPanel();
contentPane.setForeground(new Color(255, 255, 255));
contentPane.setBackground(new Color(0, 128, 0));
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
contentPane.setLayout(null);
JLabel lblNewLabel = new JLabel("There were multiple results to your search.");
lblNewLabel.setForeground(new Color(255, 255, 255));
lblNewLabel.setBounds(73, 11, 434, 37);
contentPane.add(lblNewLabel);
JLabel lblrnPleaseSelect = new JLabel("Please select the person you would like to use.");
lblrnPleaseSelect.setForeground(new Color(255, 255, 255));
lblrnPleaseSelect.setBounds(73, 59, 361, 14);
contentPane.add(lblrnPleaseSelect);
JButton btnSelect = new JButton("OK");
btnSelect.setBounds(307, 175, 89, 23);
contentPane.add(btnSelect);
JPanel resultPanel = new JPanel();
JScrollPane scrollPane =
new JScrollPane(
resultPanel,
JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,
JScrollPane.HORIZONTAL_SCROLLBAR_NEVER);
scrollPane.setBounds(21, 84, 361, 80);
contentPane.add(scrollPane);
// scrollPane.setViewportView(resultPanel);
resultPanel.setForeground(Color.WHITE);
resultPanel.setBackground(new Color(51, 204, 0));
resultPanel.setLayout(new GridLayout(0, 2, 0, 0));
final ButtonGroup group = new ButtonGroup();
for (Person p : results) {
String s = p.getLastName() + " " + p.getFirstName() + " " + p.getBox();
JCheckBox c = new JCheckBox(s);
c.setBackground(new Color(51, 204, 0));
c.setForeground(Color.WHITE);
checkBoxes.add(c);
group.add(c);
resultPanel.add(c);
}
btnSelect.addActionListener(
new ActionListener() {
@Override
public void actionPerformed(ActionEvent arg0) {
JCheckBox ch = null;
for (JCheckBox c : checkBoxes) {
if (c.isSelected()) {
ch = c;
}
}
int i = checkBoxes.indexOf(ch);
Person selected = results.get(i);
frame.getBoxText().setText(selected.getBox());
frame.getComboBox().setSelectedItem(selected.getStop());
frame.getNameText().setText(selected.getFirstName());
frame.getLastNameText().setText(selected.getLastName());
frame.selectedPerson = selected;
dispose();
}
});
this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
setVisible(true);
}
public void setPerson(Person p) {
firstName = p.getFirstName();
lastName = p.getLastName();
email = p.getEmail();
}
public String toString() {
return "Emp: " + _person.getLastName();
}
