testsql2005.java

ibatis + sqlserver 学生成绩管理

package util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestSQL2005 {
	public static void main(String[] args) throws SQLException {
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}

		Connection connection = DriverManager.getConnection(
				"jdbc:sqlserver://localhost:1433;DatabaseName=student", "sa",
				"a");
		Statement statement = connection.createStatement();
		ResultSet resultSet = statement.executeQuery("select * from user1");

		while (resultSet.next()) {
			System.out.println(resultSet.getString(1) + "\t");
//					+ resultSet.getString(2) + "\t" + resultSet.getString(3)
//					+ "\t" + resultSet.getString(4) + "\t"
//					+ resultSet.getString(5));
		}
	}
}