java连接sql server 2008数据库

1.安装sl server 2008 数据库

2.点击 开始-所有程序-sql server 2008-配置工具-sql server配置管理器-sql server 网络配置-双击MSSQLSERVER的协议-右击TCP/IP协议

3.右击计算机-管理-服务-开启sql server相关服务

4.开始连接数据库:在这里以登录界面功能为例

1)在开始-点击sql server studio

2)打开java或相关java开发的软件 netbeans等,

3)在sqlserver中新建个login表,列项有username和怕ssword

4)在java中新建一个接口

package cn.hp.db; /** * * @author HP-Developer */ public interface JdbcConfig { String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; String URL = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=Asignsystem"; String USERNAME = "sa"; String PASSWORD = "123456"; }

5)建立一个类，写这个接口的实现类

public class Jdbc implements JdbcConfig{ public static Connection getConnection() { Connection conn = null; try { Class.forName(DRIVER);// 加载数据库驱动 //System.out.println("ddd"); conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);// 获得数据库连接 System.out.println("w"); return conn; } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return null; } }

6）建立个登录类，Login

public class Login extends javax.swing.JFrame { /** * Creates new form DLCK */ public Login() { initComponents(); } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jTextField1 = new javax.swing.JTextField(); jLabel1 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jPanel1 = new javax.swing.JPanel(); jLabel3 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); username = new javax.swi