链接数据库的几种方法

1、JDBC

可以对数据库操作

dbSendUpdate(codb,"delete from dbo.a_gas_alarm where  End_DT = '2018-01-15 09:00:33';")

#

details：
Methods for the class ‘JDBCConnection’ in Package ‘RJDBC’.

dbSendQuery and dbSendUpdate submit a SQL query to the database. The difference between the two is only that dbSendUpdate is used with DBML queries and thus doesn’t return any result set.
dbGetTables and dbGetFields are similar to dbListTables and dbListFields but the result is a data frame with all available details (whereas the latter return only a character vector of the names).

#

2、RODBC