sqlserver连接数据库

package com.hkd.test;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;


public class testSqlserver {
public static void main(String[] args) {

try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("创建失败");
e.printStackTrace();
}
try {
Connection conn =DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DataBaseName=school", "sa", "m123");
java.sql.Statement sta =conn.createStatement();
int a =sta.executeUpdate("insert into school values('大侠',16,null)");
if(a>0){
System.out.println("成功");
}else{
System.out.println("失败");
}
sta.close();
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}


}