JDBC访问SQL Server2008

程序如下

package FirstPractise;import java.sql.Statement;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class Test1 {public static void main(String[] args) throws SQLException {Connection con = null;try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");}catch(Exception e){e.printStackTrace();}con = DriverManager.getConnection("jdbc:sqlserver://YangJing\\YangJing:1433;DatabaseName=TestData","sa","123456");Statement stmt = con.createStatement();String sql = "insert into dbo.ProDucts values(201,'keybord',134,null)";if(stmt.executeUpdate(sql) > 0)System.out.println("新增数据成功");else System.out.println("新增数据失败！");stmt.close();con.close();}}