Eclipse(myeclipse)连接SQL Server 2008数据库
在连接数据库之前必须保证SQL Server 2008是采用SQL Server身份验证方式而不是windows身份验证方式。如果在安装时选用了后者,则重新设置如下: http://blog.163.com/jackie_howe/blog/static/19949134720122261121214/ SQL Server 2008装好后,默认协议是没
在连接数据库之前必须保证SQL Server 2008是采用SQL Server身份验证方式而不是windows身份验证方式。如果在安装时选用了后者,则重新设置如下:
http://blog.163.com/jackie_howe/blog/static/19949134720122261121214/
SQL Server 2008装好后,默认协议是没有开启的,可打开配置工具下的 SQL Server配置管理器中开启,如下2图:
保证SQL Server 2008是采用SQL Server身份验证方式下开始配置:
一、SQL Server 2008的配置:
1、安装好SQL Server 2008后,运行 开始 → 所有程序 → Microsoft SQL Server 2008 → 配置工具 → SQL Server配置管理器,在打开的窗口的左边找到 MSSQLSERVER的协议,在右边右单击 TCP/IP,选择 已启用。如果Named Pipes 未启用也设为启用。如图5所示:
图5
图6
4、然后重启数据库,重启完毕后,接下来使用命令测试1433端口是否打开。
5、开始菜单 → 运行cmd → 在命令提示符下输入:telnet 127.0.0.1 1433,(注意telnet与127之间有空格,1与1433之间有空格)若提示“不能打开到主机的连接,在端口 1433: 连接失败”,则说明1433端口没有打开,需要重新进行以上配置。若连接成功,显示如图8所示:
图8
注:Windows7如何开启telnet服务http://blog.163.com/jackie_howe/blog/static/199491347201251723939691/
二、环境变量CLASSPATH配置:
1、下载Microsoft JDBC Driver for SQL Server
http://www.microsoft.com/zh-cn/download/details.aspx?id=11774 (最新版4.0)
http://www.microsoft.com/zh-cn/download/details.aspx?id=21599 (3.0版)
http://www.microsoft.com/zh-cn/download/details.aspx?id=2505 (2.0版)
下载JDBC的驱动文件,例如下载得到的文件是sqljdbc_4.0.2206.100_chs.exe,解压文件。设将其解压到C:\Microsoft JDBC Driver 4.0 for SQL Server目录下。
2、在桌面上右击 我的电脑,依次选择 属性 → 高级 → 环境变量,在 系统变量中双击 CLASSPATH变量,追加“;C:\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\chs\sqljdbc4.jar”若不存在应当新建CLASSPATH变量,并且将其值设为“C:\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\chs\sqljdbc4.jar”。如图9示:
图9
3、连续点击 确定 以退出环境变量配置。
三、使用Eclipse测试连接SQL Server2008数据库:
1、打开SQL Server 2008,在其中新建数据库 Test,然后退出SQL Server 2008。
2、运行Eclipse,新建一个Java Project 名为 Test。
图10
提示:也可以把sqljdbc4jar类 放到jre/lib/ext下,并放到tomcat/lib下
这样就可以应用到所有jsp文件,减少对每个项目进行sqljdbc4jar的加载;
4、在Test中新建包pkg,在pkg中新建一个类Main,在其中输入代码如下:
<p><span><span>package</span><span> pkg</span><span>;</span> <span>import</span><span> java</span><span>.</span><span>sql</span><span>.*;</span> <span>public</span><span>class</span><span>Main</span><span>{</span> <span>public</span><span>static</span><span>void</span><span> main</span><span>(</span><span>String</span><span>[]</span><span> args</span><span>)</span> <span>{</span> <span>String</span><span> driverName</span><span>=</span><span>"com.microsoft.sqlserver.jdbc.SQLServerDriver"</span><span>;</span> <span>String</span><span> dbURL</span><span>=</span><span>"jdbc:sqlserver://localhost:1433;DatabaseName=填写你的数据库名"</span><span>;</span> <span>String</span><span> userName</span><span>=</span><span>"填写你的用户名,我的是sa"</span><span>;</span> <span>String</span><span> userPwd</span><span>=</span><span>"填写你的密码"</span><span>;</span> <span><span>try</span> <span>{</span> <span>Class</span><span>.</span><span>forName</span><span>(</span><span>driverName</span><span>);</span> <span>System</span><span>.</span><span>out</span><span>.</span><span>println</span><span>(</span><span>"加载驱动成功!"</span><span>);</span> <span>}</span><span>catch</span><span>(</span><span>Exception</span><span> e</span><span>){</span> <span> e</span><span>.</span><span>printStackTrace</span><span>();</span> <span>System</span><span>.</span><span>out</span><span>.</span><span>println</span><span>(</span><span>"加载驱动失败!"</span><span>);</span> <span>}</span> <span>try</span><span>{</span> <span>Connection</span><span> dbConn</span><span>=</span><span>DriverManager</span><span>.</span><span>getConnection</span><span>(</span><span>dbURL</span><span>,</span><span>userName</span><span>,</span><span>userPwd</span><span>);</span> <span>System</span><span>.</span><span>out</span><span>.</span><span>println</span><span>(</span><span>"连接数据库成功!"</span><span>);</span> <span>}</span><span>catch</span><span>(</span><span>Exception</span><span> e</span><span>)</span> <span>{</span> <span> e</span><span>.</span><span>printStackTrace</span><span>();</span> <span>System</span><span>.</span><span>out</span><span>.</span><span>print</span><span>(</span><span>"SQL Server连接失败!"</span><span>);</span> <span>}</span></span> <span>}</span> </span></p><p><span><span><span>}</span></span></span></p>
5、点击右键,选择run as——>Java Application,出现下图11则连接成功!
图11

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

HQL and SQL are compared in the Hibernate framework: HQL (1. Object-oriented syntax, 2. Database-independent queries, 3. Type safety), while SQL directly operates the database (1. Database-independent standards, 2. Complex executable queries and data manipulation).

How to connect the keep body fat scale? Keep has a specially designed body fat scale, but most users do not know how to connect the keep body fat scale. Next is the graphic tutorial on the connection method of the keep body fat scale that the editor brings to users. , interested users come and take a look! How to connect the keep body fat scale 1. First open the keep software, go to the main page, click [My] in the lower right corner, and select [Smart Hardware]; 2. Then on the My Smart Devices page, click the [Add Device] button in the middle; 3 , then select the device you want to add interface, select [Smart Body Fat/Weight Scale]; 4. Then on the device model selection page, click the [keep body fat scale] option; 5. Finally, in the interface shown below, finally [Add Now] at the bottom

"Usage of Division Operation in OracleSQL" In OracleSQL, division operation is one of the common mathematical operations. During data query and processing, division operations can help us calculate the ratio between fields or derive the logical relationship between specific values. This article will introduce the usage of division operation in OracleSQL and provide specific code examples. 1. Two ways of division operations in OracleSQL In OracleSQL, division operations can be performed in two different ways.

What is Identity in SQL? Specific code examples are needed. In SQL, Identity is a special data type used to generate auto-incrementing numbers. It is often used to uniquely identify each row of data in a table. The Identity column is often used in conjunction with the primary key column to ensure that each record has a unique identifier. This article will detail how to use Identity and some practical code examples. The basic way to use Identity is to use Identit when creating a table.

Oracle and DB2 are two commonly used relational database management systems, each of which has its own unique SQL syntax and characteristics. This article will compare and differ between the SQL syntax of Oracle and DB2, and provide specific code examples. Database connection In Oracle, use the following statement to connect to the database: CONNECTusername/password@database. In DB2, the statement to connect to the database is as follows: CONNECTTOdataba

Interpretation of MyBatis dynamic SQL tags: Detailed explanation of Set tag usage MyBatis is an excellent persistence layer framework. It provides a wealth of dynamic SQL tags and can flexibly construct database operation statements. Among them, the Set tag is used to generate the SET clause in the UPDATE statement, which is very commonly used in update operations. This article will explain in detail the usage of the Set tag in MyBatis and demonstrate its functionality through specific code examples. What is Set tag Set tag is used in MyBati

What does 0x0000011b mean when connecting to a printer? Users often encounter various error codes when using computers, laptops or other devices. Among them, 0x0000011b is a common printer connection error code. So, what does connecting printer 0x0000011b mean? First, we need to understand the basic principles of printer connection. When we need to print files from the computer, we usually need to connect the printer to the computer for data transfer between the two. This connection can be made via

With the development of the digital era, shared printers have become an indispensable part of the modern office environment. However, sometimes we may encounter the problem that the shared printer cannot be connected to the printer, which will not only affect work efficiency, but also cause a series of troubles. This article aims to explore the reasons and solutions for why a shared printer cannot connect to the printer. There are many reasons why a shared printer cannot connect to the printer, the most common of which is network issues. If the network connection between the shared printer and the printer is unstable or interrupted, normal operation will not be possible.
