日期:2014-05-20 浏览次数:21089 次
import java.sql.*;
public class Jxc {
public static void main(String args[]) {
try {
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=hy";
String user = "hy";
String password = "sa";
Class.forName(driver);
Connection conn = DriverManager
.getConnection(url,user,password);
Statement stmt = conn.createStatement();
String sql = "SELECT ID,Name FROM hy";
ResultSet resultSet = stmt.executeQuery(sql);
String ID;
String Name;
while (resultSet.next()) {
ID = resultSet.getString(1).trim();
Name = resultSet.getString(2).trim();
System.out.println(ID +"\t"+ Name);
}
resultSet.close();
stmt.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}