在Java中访问MS SQL Server数据库研究

Research of Accessing MS SQL Server Database in Java Programs

MS SQL Server数据库在应用系统开发中被广泛采用,而Java语言具有一次编写到处运行及安全稳定等优点被广泛应用,对在Java程序中访问MS SQL Server数据库进行了较详细的讨论。针对应用JDBC-ODBC、JDBC type4驱动程序访问MS SQL Server的特点及存在的问题进行了详细讨论。同时讨论了在Windows环境下,应用Jacob通过ADO访问数据库的方法。

MS SQL Server database is extensively used in develop about database application system, and java program is extensive application because it can run everywhere after develop. This paper discussed detail that accessing a MS SQL Server database through Java programs and accessing MS SQL Server using JDBC-ODBC and JDBC type 4 driving programs. Meanwhile, we searched method of accessing database using Jacob in Windows environment.