java链接SQL server 2005相关操作程序-优快云博客

本文演示了如何使用Java连接SQL Server数据库并执行查询来获取数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


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

public class JDBTest {

	public static void main(String[] args) {
		Connection conn;
		Statement st;
		ResultSet rs;
		String userName="sa";
		String userPassword="a123456";
		String url="jdbc:sqlserver://localhost:1433; DatabaseName=lihongchao";
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			conn=DriverManager.getConnection(url,userName,userPassword);
			st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
			String sql="select * from Table2";
			rs=st.executeQuery(sql);
			while(rs.next()){
				String classid=rs.getString(1);
				String classname=rs.getString(2);
				String classgrade=rs.getString(3);
				System.out.println("classid:"+classid);
				System.out.println("classname:"+classname);
				System.out.println("classgrade:"+classgrade);
			}
		} catch (ClassNotFoundException e) {
			System.out.println("创建失败");
		} catch (SQLException e) {
			System.out.println("出错:"+e.getMessage());
		}
	}
}