JDBC连接sqlserver2008
示例如下:
- import java.sql.*;
- public class test1 {
- public static void main(String []args){
- PreparedStatement ps=null;
- Connection ct=null;
- ResultSet rs=null;
- try {
- //初始化我们的对象
- //1.加载驱动
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- //2.得到连接
- ct=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databaseName=a","gkp","123");
- //3.创建
- ps=ct.prepareStatement("select * from Emp");
- //4.执行(如果是增加,删除,修改使用executeUpdate(),如果是查询用executeQuery())
- rs=ps.executeQuery();
- while(rs.next()){
- int a=rs.getInt(1);
- String b=rs.getString(2);
- System.out.println("专业号"+a+" 专业名称"+b);
- }
- } catch (Exception e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- }