java连接sqlserver数据库实例

package edu.test;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import com.microsoft.sqlserver.jdbc.SQLServerDriver;

public class TestDB {

public static void main(String[] args) {

try {

//加载驱动程序

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

//建立数据库连接

String url = "jdbc:sqlserver://127.0.0.1:1433;databaseName=Movie";

Connection conn = DriverManager.getConnection(url, "用户名", "密码");

//创建域对象，用于执行sql语句

Statement stmt = conn.createStatement();

//执行SQL语句

String sql = "SELECT movieId,movieName,director,"

+ " typeID,stardom,region,showtime,"

+ " description,image,price FROM movies" ;

ResultSet rs = stmt.executeQuery(sql);

//使用结果rs

while(rs.next()){

String mname = rs.getString("movieName");

double price = rs.getDouble("price");

System.out.println("名称："+mname+"\t价格："+price);

}

rs.close();

stmt.close();

conn.close();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

} }