import java.sql.*;
import java.util.*;
public class Employee {
private long id;
private String firstName;
private String lastName;
private String title;
private String address;
private String city; public static void main(String[] args) {
ResultSet rs;
try {
Employee employee, newEmployee;
List list;
//to test search mehtod
list = Employee.search("");
System.out.println("original---------------------------");
for (int i=0; i<list.size();i++) {
employee = (Employee) list.get(i);
System.out.printf("%s\n",employee);
} //to test add method
newEmployee = new Employee();
newEmployee.setFirstName("New");
newEmployee.add();
list = Employee.search("");
System.out.println("a new Employee added---------------------------");
for (int i=0; i<list.size();i++) {
employee = (Employee) list.get(i);
System.out.printf("%s\n",employee);
} //to test the load method
long employeeId;
employeeId = newEmployee.getId();
newEmployee = new Employee();
newEmployee.setId(employeeId);
newEmployee.load();
System.out.printf("%s\n",newEmployee); //to test update method
newEmployee.setFirstName("updated");
newEmployee.update();
//System.out.printf("%s\n",employee);
list = Employee.search("");
System.out.println("the new Employee updated---------------------------");
for (int i=0; i<list.size();i++) {
employee = (Employee) list.get(i);
System.out.printf("%s\n",employee);
} //to test delete method
newEmployee.delete();
list = Employee.search("");
System.out.println("the new Employee deleted---------------------------");
for (int i=0; i<list.size();i++) {
employee = (Employee) list.get(i);
System.out.printf("%s\n",employee);
} } catch (Exception ex) {
System.out.println("Exeption: " + ex.getMessage());
}
}
import java.util.*;
public class Employee {
private long id;
private String firstName;
private String lastName;
private String title;
private String address;
private String city; public static void main(String[] args) {
ResultSet rs;
try {
Employee employee, newEmployee;
List list;
//to test search mehtod
list = Employee.search("");
System.out.println("original---------------------------");
for (int i=0; i<list.size();i++) {
employee = (Employee) list.get(i);
System.out.printf("%s\n",employee);
} //to test add method
newEmployee = new Employee();
newEmployee.setFirstName("New");
newEmployee.add();
list = Employee.search("");
System.out.println("a new Employee added---------------------------");
for (int i=0; i<list.size();i++) {
employee = (Employee) list.get(i);
System.out.printf("%s\n",employee);
} //to test the load method
long employeeId;
employeeId = newEmployee.getId();
newEmployee = new Employee();
newEmployee.setId(employeeId);
newEmployee.load();
System.out.printf("%s\n",newEmployee); //to test update method
newEmployee.setFirstName("updated");
newEmployee.update();
//System.out.printf("%s\n",employee);
list = Employee.search("");
System.out.println("the new Employee updated---------------------------");
for (int i=0; i<list.size();i++) {
employee = (Employee) list.get(i);
System.out.printf("%s\n",employee);
} //to test delete method
newEmployee.delete();
list = Employee.search("");
System.out.println("the new Employee deleted---------------------------");
for (int i=0; i<list.size();i++) {
employee = (Employee) list.get(i);
System.out.printf("%s\n",employee);
} } catch (Exception ex) {
System.out.println("Exeption: " + ex.getMessage());
}
}
解决方案 »
- java连接SQL数据库时遇到问题:com.microsoft.sqlserver.jdbc.SQLServerException: 数据类型 text 和 v
- 关于JDBC的代码里的问题 大大们帮我解释下代码
- 由一个 超级连接 跳过去 执行一段 js
- eclipse的log问题
- 版上做java的用到1.5新特性的多吗?
- 一道java考试题
- 设计一个登陆界面时的疑惑....搜索ArrayList出现错误,请大家帮我看看,谢谢!
- jar文件??
- 面对JAVA,痛苦的选择……
- 爲何這樣?variable socket might not have been initialized --socket.close()
- js树形控件
- 新学JAVA,老师给了两道题,但每个问题都只解决了一半,请大家地点一下
search方法的返回值是一个List,传入的参数是一个String类型
没有属于Employee 的类方法