dbexc.m

matlab和数据库的连接,本实例用ODBC连接,使用时要在本机上建立数据源,程序提供对Access操作的简单功能

% Set preferences with setdbprefs.
s.DataReturnFormat = 'cellarray';
s.ErrorHandling = 'store';
s.NullNumberRead = '0';
s.NullNumberWrite = 'NaN';
s.NullStringRead = 'null';
s.NullStringWrite = 'null';
s.JDBCDataSourceFile = '';
s.UseRegistryForSources = 'yes';
s.TempDirForRegistryOutput = 'D:\DOCUME~1\ADMINI~1\LOCALS~1\Temp';
setdbprefs(s)

% Make connection to database.  Note that the password has been omitted.
% Using ODBC driver.
conn = database('stu','','password');

% Read data from database.
e = exec(conn,'SELECT ALL sid,sn,grade FROM stu WHERE grade < 80  ');
e = fetch(e);
A=e.data;
close(e)
rowl=rows(e);  %行数
mean=sum([A{:,3}])/rowl;
cc=cell(1,3);   %定义单元数组
cc={0006,'XX',mean};
insert(conn,'stu',{'sid','sn','grade'},cc);
close(e)
% Close database connection.
close(conn)