java操作sql数据库_Java操作SQL Server数据库

package cn.edu.hactcm;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

/**

* @author 涂作泉  *  * @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();   stmt.close();   conn.close();   } }