Myeclipse10.7 connected to SQL Server database technology, myeclipse10.7 download

Myeclipse10.7 connected to SQL Server database technology, myeclipse10.7 download

(1) When learning databases, the most annoying thing is that we don't want to know how to connect. Instead, we don't want to use functions in WPF to call the database, but we need to use JDBC technology in java,

Therefore, our method must be more complex! After reading a lot of blog texts, I tried many methods but still failed. Finally, I suddenly realized that I would like to share it with you!

(2) First, let's take a look at my project organization:

The jar package is downloaded online under the lib directory, and the test program compiled by ManageUsers is required!

(3) If you have prepared the four jar packages in the lib directory, configure them:

Right-click the project -- properies --- Java Bulid Path ----- Libraries --- Add JARs --- the pop-up box, click your project -- find the lib directory, select four jar packages, and click OK!

(4) Configure your SQL server;

Find SQL server configurationmanager and find 1. If the TCP/IP address is "disabled", enable it as shown below!

(5) Demo code ManageUsers (xml configuration of servlet has been configured)

Package com. lc. view; import java. io. IOException; import java. io. printWriter; import java. SQL. connection; import java. SQL. driverManager; import java. SQL. preparedStatement; import java. SQL. resultSet; import javax. servlet. servletException; import javax. servlet. http. httpServlet; import javax. servlet. http. httpServletRequest; import javax. servlet. http. httpServletResponse; public class ManageUsers extends HttpServle T {public void doGet (HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {response. setContentType ("text/html; charset = UTF-8"); PrintWriter out = response. getWriter (); out. println ("(6) run the following command:





(7) This is successful! If you have any questions in this regard, please join us!
In addition, if you encounter a problem connecting to the database, please visit some of my troubleshooting methods: http://blog.csdn.net/xlgen157387/article/details/39055085.


Finally, I wish you success!





Who will help me tell me how myeclipse connects to the SQL server database?
Window-show view-> other-> myeclipse database-> db browser

1. Right-click new in db browser
2. Select microsoft SQL server2005 as the driver template.
Driver name: Enter one
Url: jdbc: sqlserver: // localhost: port number; databaseName = XX
Username and password can be used to access the database.
3. Click add jars to select the SQL server Driver.
4. select save password.
5. Click next until you can only click finish.
6. Return to the db browser and you will see the SQL server you created. Right-click it and select open to connect it.

How does myeclipse75 connect to the SQL server2008 database?
1. Download the SQL Server 2008 driver for JDBC driver: sqljdbc4.jar
Copy backup files
Find the sqljdbc_auth.dll file in the sqljdbc driver you downloaded. For example, the decompressed directory is C: \ Program Files, so I

The sqljdbc_auth.dll file in

C: \ Program Files \ Microsoft SQL Server 2005 JDBC Driver \ sqljdbc_1.2 \ enu \ auth \ x86 \ sqljdbc_auth.dll

Put the found file in the C: \ WINDOWS \ system32 directory. This is a dynamic Runtime Library, which must not be less.
2. Put sqljdbc_auth.dll under c:/window/system32
3. Make sure that your SQL Server service has been configured
4. Modify the default logon authentication mode. Because SAS is installed in the "Windows Authentication Mode" mode by default during installation, SAS logon is disabled.
If you change the Authentication Mode to "SQL Server and Windows Authentication Mode", SAS logon is still disabled.
 
Enable sa Logon account ):

① In the object Resource Manager of SQL Server Management Studio, choose security> Logon Name> sa> Properties> General>

Set sa password and Confirm Password as strong password-> Status-> logon-> enable-> OK;

② In the object Resource Manager of SQL Server Management Studio, right-click the Server and choose Properties> Security> Server Authentication.

Select "SQL Server and Windows Authentication Mode"-> OK-> OK.
Disable the firewall either.