第2个回答 2013-09-08
不知道你用什么语言写的程序,我就说一下java 中的, 不过大致差不多,
class DBConnection//创建连接{
String url;
Connection conn;
Statement stmt;
DBConnection()//建立连接
{
{
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e1)
{
JOptionPane.showMessageDialog(null,e1);
}
try
{
url= "jdbc:odbc:Student";
conn= DriverManager.getConnection(url, "Student", "123456");
stmt= conn.createStatement();
}
catch (Exception ex)
{
JOptionPane.showMessageDialog(null,ex);
}
}
}
}
以下是删除和修改的
String StringSQL="update TeacherData set TeacherNumber='"+TeacherNumberTextField.getText()+"',TeacherName='"+TeacherNameTextField.getText()+"',TeacherSex='"+TeacherSex0+"',TeacherCalled='"+TeacherCalledTextField.getText()+"' where TeacherNumber='"+WantedChooseNum+"'" ;
String StringSQL="insert into TeacherData(TeacherNumber,TeacherName,TeacherSex,TeacherCalled) values('"+TeacherNumberTextField.getText()+"',"+"'"+TeacherNameTextField.getText()+"',"+"'"+TeacherSex0+"',"+"'"+TeacherCalledTextField.getText()+"')";
如有疑问,请加QQ:815188262本回答被网友采纳