会python真的可以为所欲为0(回)
331天前
这里还有人吗1(回)
516天前这里还有人吗0(回)
516天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
741天前到处都是羊，不想上班0(回)
821天前
鸽子
0(回)
825天前import java.sql.*; |
public class AddRecord { |
String datasourceName=""; //数据源名 |
String tableName=""; //表名 |
String number="", //雇员号 |
name="", //姓名 |
birthday; //出生日期 |
double salary; //薪水 |
public AddRecord() { |
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); |
} |
catch(ClassNotFoundException e) { |
System.out.print(e); |
} |
} |
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; |
} |
public String addRecord() |
{ String str=""; |
Connection con; |
PreparedStatement sql; |
try { String uri="jdbc:odbc:"+datasourceName; |
String id=""; |
String password=""; |
con=DriverManager.getConnection(uri,id,password); |
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(); |
} |
catch(SQLException e) { |
str="你还没有提供添加的数据或"+e; |
} |
return str; |
} |
} |
import java.sql.*; |
import java.util.*; |
public class Example14_10 { |
public static void main(String args[]) { |
AddRecord insertRecord=new AddRecord(); |
String datasorce="star"; |
String tableName="employee"; |
insertRecord.setDatasourceName(datasorce); |
insertRecord.setTableName(tableName); |
insertRecord.setNumber("110"); |
insertRecord.setName("里向扬"); |
insertRecord.setBirthday("1990-12-10"); |
insertRecord.setSalary(3000); |
String backMess=insertRecord.addRecord(); |
System.out.println(backMess); |
insertRecord.setNumber("111"); |
insertRecord.setName("卫里六"); |
insertRecord.setBirthday("1996-12-15"); |
insertRecord.setSalary(6000); |
backMess=insertRecord.addRecord(); |
System.out.println(backMess); |
} |
} |
