如何将netbeans 6.8连接到sql server 2008？ [英] How to connect netbeans 6.8 to sql server 2008?

问题描述

我想在netbeans中使用在sql server中创建的数据库，我在这个过程中有点混淆他们在网站上找到了很多程序和存储过程，但是我找不到一步一步设置连接的程序。我想在每个步骤编写连接的代码和程序，任何人都请帮助我。

I want to use databases created in sql server in netbeans , i am bit confuse in the process their are many programs and stored procedures found on sites but i could not found step by step procedure for set connection. i want every step where to write code and procedures for connection , anyone please help me .

推荐答案

我认为你不想把它连接到netbeans。但是您可能希望将其连接到Java程序。请查看 http://docs.oracle.com/javase/tutorial/jdbc/index.html [ ^ ]。

I don't think you want to connect it to netbeans. But you may want to connect it to your Java program. Take a look at http://docs.oracle.com/javase/tutorial/jdbc/index.html[^].

请尝试

Please try

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
String name=jTextField1.getText();
String password=jTextField2.getText();
jLabel3.setText(name+" "+password);
 
    try {
            
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            
            
            Connection conn = DriverManager.getConnection("jdbc:sqlserver://DBASE\\SQLEXPRESS;DatabaseName=StackHolder", "sa", "dbase");

            Statement statement = conn.createStatement();

            PreparedStatement prep = conn.prepareStatement("INSERT INTO Users(name, pass) VALUES(?, ?)");

            prep.setString(1, name);
            prep.setString(2, password);
            prep.executeUpdate();

            ResultSet resultSet = statement.executeQuery("SELECT name FROM Users");

            while(resultSet.next()){

            System.out.println("name: " + resultSet.getString("name"));
        
            }

            conn.close();
         
}

    catch (Exception ex) {
                            
                    System.out.println(ex);       
}

// TODO add your handling code here:
    }    

这篇关于如何将netbeans 6.8连接到sql server 2008？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！