Java操作SQL Server数据库

package cn.edu.hactcm;

import java.sql.connection;

import java.sql.drivermanager;

import java.sql.sqlexception;

import java.sql.statement;

/**

 *

 * @version 1.2 2012-5-20

 * @sqlserverjdbc

 */

public class insertdemo {

 public static final string dbdriver = "com.microsoft.sqlserver.jdbc.sqlserverdriver";

 //定义sql server数据库的连接地址

 public static final string dburl = "jdbc:sqlserver://localhost:1433;databasename=mobileshop;";

 public static final string dbuser = "sa";

 public static final string dbpass = "123456";

 public static void main(string[] args) throws classnotfoundexception, sqlexception {

  connection conn = null; //数据库连接

  statement stmt = null;  //数据库操作

  string sql = "insert into mobileshop_brand(id,brandname) values(1,'诺基亚')";

  class.forname(dbdriver);   //加载数据库驱动

  conn = drivermanager.getconnection(dburl,dbuser,dbpass);

  stmt = conn.createstatement();    //实例化statement对象

  stmt.executeupdate(sql);//执行数据库操作

  stmt.close();

  conn.close(); 

 }

}