java操作sqlserver

import java.sql.*;

public class Demo8 {

public static void main(String[] srg) {

String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动

String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=wyc"; //连接服务器和数据库sample

String userName = "sa"; //默认用户名

String userPwd = "wyc"; //密码

Connection dbConn;

PreparedStatement ps = null;

ResultSet rs = null;

try {

Class.forName(driverName);

dbConn = DriverManager.getConnection(dbURL, userName, userPwd);

//Statement sm = dbConn.createStatement();

String sql = "select name,age from wo";

ps=dbConn.prepareStatement(sql);

rs = ps.executeQuery();// 执行查询

while(rs.next()){

String name=rs.getString("name");//使用字段名也可以取出数据

int age=rs.getInt("age");

System.out.println(name+"\t"+age);

}

System.out.println( "Connection Successful! "); //如果连接成功 控制台输出Connection Successful!

} catch (Exception e) {

e.printStackTrace();

}

}

}