java JDBC连接SqlServer数据库

最新推荐文章于 2024-06-30 02:15:42 发布

浮生若梦01

最新推荐文章于 2024-06-30 02:15:42 发布

阅读量511

点赞数 8

分类专栏： java 文章标签：数据库 java sqlserver

本文链接：https://blog.csdn.net/qq_35004315/article/details/136379823

版权

java 专栏收录该内容

61 篇文章 1 订阅

订阅专栏

本文展示了如何使用Java的JDBCAPI连接到SQLServer2008数据库，执行查询并打印结果。代码实例包括加载驱动、建立连接和执行SQL命令。

摘要由CSDN通过智能技术生成

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

/**
 * connect sqlserver2008
 *
 */
public class ConnectSqlserver {

	private static Connection conn;
	private static PreparedStatement pt = null;
	private static ResultSet rs = null;
	private static String dbHost="127.0.0.1";
	private static String dbName="sssttest";
	private static String userName = "sa";
	private static String userPassword = "sa";
	private static String dbPort="1433";

	public static Connection getMySqlConnection() throws Exception {
		//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		conn = DriverManager.getConnection("jdbc:sqlserver://"+dbHost+":"+dbPort+";databaseName="+dbName, userName, userPassword);
		return conn;
	}

	public static void main(String[] args) throws Exception {
		Connection conn = ConnectSqlserver.getMySqlConnection();
		String sql = "select * from testtablea1 ";
		pt = conn.prepareStatement(sql);
		rs=pt.executeQuery();
		while(rs.next()){
			for(int i=1;i<=rs.getMetaData().getColumnCount();i++){
				System.out.print(rs.getString(i)+"\t");
			}
			System.out.println();
		}
	}

}