eclipse-sql server 2008连接

注：方法一中ps.close()不可注掉；
jar包加入：Java Build Path-libraries-add

package aa;
import java.sql.*;
public class gold1{
    static Connection con = null;
    static PreparedStatement ps = null;
    static ResultSet rs = null;
    public static void main(String[] args) {
        try{
            con = getConnection();                 
            Statement stmt=con.createStatement();//创建SQL命令对象      
            //创建表
            String query="create table TABLE1(ID NCHAR(2),NAME NCHAR(10))";//创建表SQL语句
            stmt.executeUpdate(query);//执行SQL命令对象
            System.out.println("表创建成功");
             
            //输入数据
            System.out.println("开始插入数据");
            String a1="INSERT INTO TABLE1 VALUES('1','旭哥')";//插入数据SQL语句
            String a2="INSERT INTO TABLE1 VALUES('2','伟哥')";
            String a3="INSERT INTO TABLE1 VALUES('3','张哥')";
            stmt.executeUpdate(a1);//执行SQL命令对象
            stmt.executeUpdate(a2);   
            stmt.executeUpdate(a3);
            System.out.println("插入数据成功");          
          
            /*//方法一：读取数据
            System.out.println("开始读取数据");
            String sql = "select * from TABLE1";        
            ps = con.prepareStatement(sql);            
            rs = ps.executeQuery();
            while (rs.next()) {                
                System.out.println(rs.getString(1)+rs.getString(2));                
            }
            System.out.println("读取完毕"); */          
          
          
            // 方法二：读取数据
            System.out.println("开始读取数据");
            String sql = "select * from TABLE1";
            rs=stmt.executeQuery(sql);//返回SQL语句查询结果集(集合)
           //循环输出每一条记录
            while(rs.next()) {
                System.out.println(rs.getString("ID")+"\t"+rs.getString("NAME"));//输出每个字段           
            }
            System.out.println("读取完毕");        
          
            } catch (SQLException e) {            
            e.printStackTrace();
            System.out.println("数据库连接错误");
            System.exit(0);
            } finally {
            try {
                rs.close();
                //ps.close();
                con.close();
                System.out.println("ok");
            } catch (SQLException e) {            
                e.printStackTrace();
            }
        }
    }
    

    static final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
    static final String URL = "jdbc:sqlserver://localhost:1433;databaseName=JXGL";
    static final String USER = "sa";
    static final String PWD = "123456";

    public static Connection getConnection() {
        try {
            Class.forName(DRIVER);
            con = DriverManager.getConnection(URL, USER, PWD);
            System.out.println("连接数据库成功");
        } catch(ClassNotFoundException e) {
            //e.printStackTrace();
            System.out.println("加载数据库引擎失败");
            System.exit(0);   
        } catch (SQLException e) {
            e.printStackTrace();
        }
        System.out.println("数据库驱动成功");
        return con;
    }
}