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

总结了一下关于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
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
Explain the InnoDB Buffer Pool and its importance for performance.Explain the InnoDB Buffer Pool and its importance for performance.Apr 19, 2025 am 12:24 AM

InnoDBBufferPool reduces disk I/O by caching data and indexing pages, improving database performance. Its working principle includes: 1. Data reading: Read data from BufferPool; 2. Data writing: After modifying the data, write to BufferPool and refresh it to disk regularly; 3. Cache management: Use the LRU algorithm to manage cache pages; 4. Reading mechanism: Load adjacent data pages in advance. By sizing the BufferPool and using multiple instances, database performance can be optimized.

MySQL vs. Other Programming Languages: A ComparisonMySQL vs. Other Programming Languages: A ComparisonApr 19, 2025 am 12:22 AM

Compared with other programming languages, MySQL is mainly used to store and manage data, while other languages ​​such as Python, Java, and C are used for logical processing and application development. MySQL is known for its high performance, scalability and cross-platform support, suitable for data management needs, while other languages ​​have advantages in their respective fields such as data analytics, enterprise applications, and system programming.

Learning MySQL: A Step-by-Step Guide for New UsersLearning MySQL: A Step-by-Step Guide for New UsersApr 19, 2025 am 12:19 AM

MySQL is worth learning because it is a powerful open source database management system suitable for data storage, management and analysis. 1) MySQL is a relational database that uses SQL to operate data and is suitable for structured data management. 2) The SQL language is the key to interacting with MySQL and supports CRUD operations. 3) The working principle of MySQL includes client/server architecture, storage engine and query optimizer. 4) Basic usage includes creating databases and tables, and advanced usage involves joining tables using JOIN. 5) Common errors include syntax errors and permission issues, and debugging skills include checking syntax and using EXPLAIN commands. 6) Performance optimization involves the use of indexes, optimization of SQL statements and regular maintenance of databases.

MySQL: Essential Skills for Beginners to MasterMySQL: Essential Skills for Beginners to MasterApr 18, 2025 am 12:24 AM

MySQL is suitable for beginners to learn database skills. 1. Install MySQL server and client tools. 2. Understand basic SQL queries, such as SELECT. 3. Master data operations: create tables, insert, update, and delete data. 4. Learn advanced skills: subquery and window functions. 5. Debugging and optimization: Check syntax, use indexes, avoid SELECT*, and use LIMIT.

MySQL: Structured Data and Relational DatabasesMySQL: Structured Data and Relational DatabasesApr 18, 2025 am 12:22 AM

MySQL efficiently manages structured data through table structure and SQL query, and implements inter-table relationships through foreign keys. 1. Define the data format and type when creating a table. 2. Use foreign keys to establish relationships between tables. 3. Improve performance through indexing and query optimization. 4. Regularly backup and monitor databases to ensure data security and performance optimization.

MySQL: Key Features and Capabilities ExplainedMySQL: Key Features and Capabilities ExplainedApr 18, 2025 am 12:17 AM

MySQL is an open source relational database management system that is widely used in Web development. Its key features include: 1. Supports multiple storage engines, such as InnoDB and MyISAM, suitable for different scenarios; 2. Provides master-slave replication functions to facilitate load balancing and data backup; 3. Improve query efficiency through query optimization and index use.

The Purpose of SQL: Interacting with MySQL DatabasesThe Purpose of SQL: Interacting with MySQL DatabasesApr 18, 2025 am 12:12 AM

SQL is used to interact with MySQL database to realize data addition, deletion, modification, inspection and database design. 1) SQL performs data operations through SELECT, INSERT, UPDATE, DELETE statements; 2) Use CREATE, ALTER, DROP statements for database design and management; 3) Complex queries and data analysis are implemented through SQL to improve business decision-making efficiency.

MySQL for Beginners: Getting Started with Database ManagementMySQL for Beginners: Getting Started with Database ManagementApr 18, 2025 am 12:10 AM

The basic operations of MySQL include creating databases, tables, and using SQL to perform CRUD operations on data. 1. Create a database: CREATEDATABASEmy_first_db; 2. Create a table: CREATETABLEbooks(idINTAUTO_INCREMENTPRIMARYKEY, titleVARCHAR(100)NOTNULL, authorVARCHAR(100)NOTNULL, published_yearINT); 3. Insert data: INSERTINTObooks(title, author, published_year)VA

See all articles

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

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

MantisBT

MantisBT

Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool

VSCode Windows 64-bit Download

VSCode Windows 64-bit Download

A free and powerful IDE editor launched by Microsoft