Test.java

package test;

import java.sql.*;   

public class Test {  
  
public static void main(String[] srg) {  
  
   String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";   //加载JDBC驱动  

   String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=YCZMJK"; //连接服务器和数据库YCZMJK  

   String userName = "sa";   //默认用户名  
  
   String userPwd = "123456";   //密码  

   Connection dbConn;  

   try {  
  
   Class.forName(driverName);  
  
   dbConn = DriverManager.getConnection(dbURL, userName, userPwd);  
   Statement stat = dbConn.createStatement();
   System.out.println("Connection Successful!");   //如果连接成功 控制台输出Connection Successful!  
	String sql = "insert into localuser(username,passwd)VALUES('hhhh','123456')";  //SQL查询语言
	int i= stat.executeUpdate(sql);
	System.out.println("成功添加"+i+"行");
   } catch (Exception e) {  

   e.printStackTrace();  
  
   }  
   
  
}  
  
}