jdbc 访问 sql server 2008

来源：互联网发布：造字软件手机版编辑：程序博客网时间：2024/06/08 08:41

/** *  * jdbc 操作sql server数据库 */package com.ui1;import java.sql.*;public class jdbc_test {public static void main(String[] args) {// TODO Auto-generated method stubPreparedStatement ps=null;Connection ct=null;ResultSet rs=null;try {Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");ct=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433; databaseName=student","sa","root");ps=ct.prepareStatement("select * from stu");rs=ps.executeQuery();while (rs.next()) {   System.out.println(rs.getString(1));   System.out.println(rs.getString(2));   System.out.println(rs.getString(3));   System.out.println(rs.getInt(4));   System.out.println(rs.getString(5));   System.out.println(rs.getString(6));}} catch (Exception e) {// TODO: handle exceptione.printStackTrace();}finally{try {if(rs!=null){rs.close();}if(ps!=null){ps.close();}if (ct!=null) {ct.close();}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}

说明：要向java项目中导入一个jdbc驱动包：sqljdbc4.jar，这个包可以到网上下载

注意上面的驱动加载的字符串和连接sql server 2000是有区别的

jdbc 连接sql server 2000:

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433; databaseName=student","sa","root");

0 0