import java.sql.*;
public class AddRecord {
String datasourceName
=""; //数据源名 name="", //姓名
birthday; //出生日期
double salary; //薪水
public AddRecord() {
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
}
}
public void setDatasourceName
(String s
) { datasourceName=s.trim();
}
public void setTableName
(String s
) { tableName=s.trim();
}
public void setNumber
(String s
) { number=s.trim();
}
public void setName
(String s
) { name=s.trim();
}
public void setSalary(double n) {
salary=n;
}
public void setBirthday
(String b
) { birthday=b;
}
try { String uri
="jdbc:odbc:"+datasourceName
; String insertCondition
="INSERT INTO employee VALUES (?,?,?,?)"; sql=con.prepareStatement(insertCondition);
if(number.length()>0) {
sql.setString(1,number);
sql.setString(2,name);
sql.setString(3,birthday);
sql.setDouble(4,salary);
int m=sql.executeUpdate();
if(m!=0)
str="对表中添加"+m+"条记录成功";
else
str="添加记录失败";
}
else {
str="必须要有雇员号";
}
con.close();
}
str="你还没有提供添加的数据或"+e;
}
return str;
}
}
import java.sql.*;
import java.util.*;
public class Example14_10 {
public static void main
(String args
[]) { AddRecord insertRecord=new AddRecord();
insertRecord.setDatasourceName(datasorce);
insertRecord.setTableName(tableName);
insertRecord.setNumber("110");
insertRecord.setName("里向扬");
insertRecord.setBirthday("1990-12-10");
insertRecord.setSalary(3000);
String backMess
=insertRecord.
addRecord(); insertRecord.setNumber("111");
insertRecord.setName("卫里六");
insertRecord.setBirthday("1996-12-15");
insertRecord.setSalary(6000);
backMess=insertRecord.addRecord();
}
}