Home Database Mysql Tutorial 关于sqlserver2005安装问题,以及与JDBC进行直连

关于sqlserver2005安装问题,以及与JDBC进行直连

Jun 07, 2016 pm 03:45 PM
jdbc about Install question

总结了一下关于sqlserver2005的安装中出现的无法卸载干净的问题,以及如何进行jdbc直连的问题,其中部分内容参考自互联网。希望对大家有用。 强烈建议大家还是安装个mysql数据库,卸载安装方便,耗费资源

总结了一下关于sqlserver2005的安装中出现的无法卸载干净的问题,以及如何进行jdbc直连的问题,其中部分内容参考自互联网。希望对大家有用。

强烈建议大家还是安装个mysql数据库,卸载安装方便,耗费资源小。

 

之前安装过sqlserver2005的:

首先要卸载掉所有sqlserver有关的软件,删除之后到注册表中进行清理

开始——运行:输入regedit进入注册表编辑器,进入之后执行下列操作:

1.彻底删除SQL Server
hkey_local_machine\software\Microsoft\MSSQLServer hkey_local_machine\software\Microsoft\MicrosoftSQL Server hkey_current_user\software\Microsoft\Microsoft SQL Serverhkey_current_user\software\Microsoft\MSSQLServerhkey_local_machine\system\currentcontrolset\control\sessionmanager\pendingfileren      ameoperations

2。注册表中的相关信息删除:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MSDTC

3
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SessionManager中找到PendingFileRenameOperations项目,并删除它。这样就可以清除安装暂挂项目
4
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\setup
删除ExceptionComponents


3
、运行注册表,删除如下项:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

然后,再将原来的安装路径里面的所有相关内容删除。

 

1.准备工作:准备相关的软件(Eclipse除外,开源软件可以从官网下载)

 

.MicrosoftSQL server 2005 Express Edition

 

下载地址:http://download.microsoft.com/download/0/9/0/09020fab-d2c3-4a8c-b9e0-db53a7a30ae8/SQLEXPR_CHS.EXE

 

.SQLServer Management Studio

 

下载地址:http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796#filelist

 

.SQLServer 2005 driver for JDBC

 

下载地址:http://download.microsoft.com/download/8/B/D/8BDABAE2-B6EA-41D4-B903-7916EF3690EF/sqljdbc_1.2.2323.101_enu.exe

 

2.都下载完之后开始进行安装 ,前两个是属于数据库软件,正常安装即可(注意数据库登陆不要使用windows验证)

 

数据库安装完成后,压缩包中附带的JDBC解压缩到任意位置,比如解压到C盘programfiles下面,并在安装目录里找到sqljdbc.jar文件,得到其路径开始配置环境变量

 

在环境变量classpath 后面追加 C:\Program Files\MicrosoftSQL Server2005 JDBC Driver\sqljdbc_1.2\enu\sqljdbc.jar

设置SQLEXPRESS服务器:

 

   a.打开SQL Server Configuration Manager -> SQLEXPRESS的协议 -> TCP/IP

 

   b.右键单击启动TCP/IP

 

   c.双击进入属性,把IP地址中的IP all中的TCP端口设置为1433

 

   d.重新启动SQL Server 2005服务中的SQLEXPRESS服务器

 

   e.关闭SQL Server Configuration Manager

 

外围应用配置:Microsoft SQL Server 2005->配置工具->SQLServer外围应用配置器->服务和连接的外围应用配置器->     ①选SQLEXPRESS->Database Engine->远程连接->本地连接和远程连接->同时使用TCP/IP和named pipes;   ②选SQL Server Browser->服务->启动类型改为“自动”->应用->启动->确定。

sqljdbc_1.2 \chs\auth\x86/(x64)\sqljdbc_auth.dll的文件拷贝到c:\windows\system32

打开Eclipse

 

   a.新建工程-> java -> java project,起名为Test

 

   b.选择eclipse->窗口->首选项->java->installed JRE  编辑已经安装好的jdk,查找目录添加sqljdbc.jar

 

   c.右键单击目录窗口中的Test, 选择Build Path ->Configure BuildPath..., 添加扩展jar文件,即把sqljdbc.jar添加到其中

 

创建JDBC类编写java代码来测试连接数据库

 

   

import java.sql.*;

 

    publicclass JDBC {

       public static Connectionconn=null;

       privatestaticfinal StringDRIVERCLASS ="com.microsoft.sqlserver.jdbc.SQLServerDriver";//注意不同的数据库的DRIVERCLASS内容格式并不完全相同,请自行参考网络。特别说明sqlserver2000中的格式为:"com.microsoft.jdbc.sqlserver.SQLServerDriver"

       privatestaticfinal StringURL = "jdbc:sqlserver://localhost:1433;DatabaseName=*";//*处填写自己创建的数据库名

       privatestaticfinal StringUSERNAME ="*";//*处填写自己数据库混合模式下的账号名

 

       privatestaticfinal StringPASSWORD =" ";//*处填写自己数据库名混合模式下的密码

 

       static {//通过静态方法加载数据库驱动

           try {

              Class.forName(DRIVERCLASS);//加载数据库驱动

           } catch (Exception e){

              e.printStackTrace();

           }

       }

 

       publicstaticvoidgetConnection() {//创建数据库连接的方法

           if (conn ==null) {//没有可用的数据库连接

              try {

                  conn =DriverManager.getConnection(URL,USERNAME,PASSWORD);//创建数据库连接

System.out.println("连接成功~~");

              } catch (SQLExceptione) {

                  e.printStackTrace();

              }

           }

       }

 

       publicstaticbooleancloseConnection() {//关闭数据库连接的方法

           boolean isClosed =true;

           if (conn !=null) {//数据库连接可用

              try {

                  conn.close();//关闭数据库连接

              } catch (SQLExceptione) {

                  isClosed= false;

                  e.printStackTrace();

              }

           }

           return isClosed;

       }

       publicstaticvoid main(String[]srg){

           getConnection();

           Statementsm=conn.getConnection();

           Stringsql=”select * from表名”

Resultset rs=rs=sm.executeQuery(sql);

While(rs.next()){

rs.getString(1);
}

       }

 

    }

 

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Solution to the problem that Win11 system cannot install Chinese language pack Solution to the problem that Win11 system cannot install Chinese language pack Mar 09, 2024 am 09:48 AM

Solution to the problem that Win11 system cannot install Chinese language pack With the launch of Windows 11 system, many users began to upgrade their operating system to experience new functions and interfaces. However, some users found that they were unable to install the Chinese language pack after upgrading, which troubled their experience. In this article, we will discuss the reasons why Win11 system cannot install the Chinese language pack and provide some solutions to help users solve this problem. Cause Analysis First, let us analyze the inability of Win11 system to

Unable to install guest additions in VirtualBox Unable to install guest additions in VirtualBox Mar 10, 2024 am 09:34 AM

You may not be able to install guest additions to a virtual machine in OracleVirtualBox. When we click on Devices>InstallGuestAdditionsCDImage, it just throws an error as shown below: VirtualBox - Error: Unable to insert virtual disc C: Programming FilesOracleVirtualBoxVBoxGuestAdditions.iso into ubuntu machine In this post we will understand what happens when you What to do when you can't install guest additions in VirtualBox. Unable to install guest additions in VirtualBox If you can't install it in Virtua

What should I do if Baidu Netdisk is downloaded successfully but cannot be installed? What should I do if Baidu Netdisk is downloaded successfully but cannot be installed? Mar 13, 2024 pm 10:22 PM

If you have successfully downloaded the installation file of Baidu Netdisk, but cannot install it normally, it may be that there is an error in the integrity of the software file or there is a problem with the residual files and registry entries. Let this site take care of it for users. Let’s introduce the analysis of the problem that Baidu Netdisk is successfully downloaded but cannot be installed. Analysis of the problem that Baidu Netdisk downloaded successfully but could not be installed 1. Check the integrity of the installation file: Make sure that the downloaded installation file is complete and not damaged. You can download it again, or try to download the installation file from another trusted source. 2. Turn off anti-virus software and firewall: Some anti-virus software or firewall programs may prevent the installation program from running properly. Try disabling or exiting the anti-virus software and firewall, then re-run the installation

How to install Android apps on Linux? How to install Android apps on Linux? Mar 19, 2024 am 11:15 AM

Installing Android applications on Linux has always been a concern for many users. Especially for Linux users who like to use Android applications, it is very important to master how to install Android applications on Linux systems. Although running Android applications directly on Linux is not as simple as on the Android platform, by using emulators or third-party tools, we can still happily enjoy Android applications on Linux. The following will introduce how to install Android applications on Linux systems.

How to Install and Run the Ubuntu Notes App on Ubuntu 24.04 How to Install and Run the Ubuntu Notes App on Ubuntu 24.04 Mar 22, 2024 pm 04:40 PM

While studying in high school, some students take very clear and accurate notes, taking more notes than others in the same class. For some, note-taking is a hobby, while for others, it is a necessity when they easily forget small information about anything important. Microsoft's NTFS application is particularly useful for students who wish to save important notes beyond regular lectures. In this article, we will describe the installation of Ubuntu applications on Ubuntu24. Updating the Ubuntu System Before installing the Ubuntu installer, on Ubuntu24 we need to ensure that the newly configured system has been updated. We can use the most famous "a" in Ubuntu system

How to install Podman on Ubuntu 24.04 How to install Podman on Ubuntu 24.04 Mar 22, 2024 am 11:26 AM

If you have used Docker, you must understand daemons, containers, and their functions. A daemon is a service that runs in the background when a container is already in use in any system. Podman is a free management tool for managing and creating containers without relying on any daemon such as Docker. Therefore, it has advantages in managing containers without the need for long-term backend services. Additionally, Podman does not require root-level permissions to be used. This guide discusses in detail how to install Podman on Ubuntu24. To update the system, we first need to update the system and open the Terminal shell of Ubuntu24. During both installation and upgrade processes, we need to use the command line. a simple

How to install creo-creo installation tutorial How to install creo-creo installation tutorial Mar 04, 2024 pm 10:30 PM

Many novice friends still don’t know how to install creo, so the editor below brings relevant tutorials on creo installation. Friends in need should take a look at it. I hope it can help you. 1. Open the downloaded installation package and find the License folder, as shown in the figure below: 2. Then copy it to the directory on the C drive, as shown in the figure below: 3. Double-click to enter and see if there is a license file, as shown below As shown in the picture: 4. Then copy the license file to this file, as shown in the following picture: 5. In the PROGRAMFILES file of the C drive, create a new PLC folder, as shown in the following picture: 6. Copy the license file as well Click in, as shown in the figure below: 7. Double-click the installation file of the main program. To install, check the box to install new software.

Detailed steps to install Go language on Win7 computer Detailed steps to install Go language on Win7 computer Mar 27, 2024 pm 02:00 PM

Detailed steps to install Go language on Win7 computer Go (also known as Golang) is an open source programming language developed by Google. It is simple, efficient and has excellent concurrency performance. It is suitable for the development of cloud services, network applications and back-end systems. . Installing the Go language on a Win7 computer allows you to quickly get started with the language and start writing Go programs. The following will introduce in detail the steps to install the Go language on a Win7 computer, and attach specific code examples. Step 1: Download the Go language installation package and visit the Go official website

See all articles