jdbc连接Sqlserver数据库

DBC（Java Data Base Connectivity,java数据库连接）是一种用于执行SQL语句的Java API，可以为多种关系数据库提供统一访问，它由一组用Java语言编写的类和接口组成。以jdbc的方式连接SqlServer数据库，需要下载一个sqljdbc的驱动，下载后需要将sqljdbc.jar添加到classpath路径中，然后在java工程中引入该jar。右键工程->Build Path->Configure Buile Path...->Java Build Path->Libraries->Add external jars，找到sqljdbc.jar,将其引入即可。

具体实现代码如下：

package JavaBean; import java.sql.*; import javax.swing.*; public class ConnectDB { public Connection conn = null;//Connection接口 public Statement stmt = null; public PreparedStatement ps=null; public static ResultSet rs = null;//Statement接口 public ConnectDB() throws SQLException,ClassNotFoundException { try{ String DatabaseDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; String strcon = "jdbc:sqlserver://localhost:1433; DatabaseName=ChatRoom"; String user="sa"; String pwd="sasa"; Class.forName(DatabaseDriver); conn=DriverManager.getConnection(strcon, user,pwd); stmt=conn.createStatement(); } catch(SQLException e){ System.out.println("Error occured when Connect Database:"+e); } catch(ClassNotFoundException e){ System.out.println("Error occured when Connect Database:"+e); } } /** * 初始化预编译的SQL语句的对象 * @param sql * @return * @throws SQLException */ public PreparedStatement preparedStatement(String sql)throws SQLException{ try{ ps=conn.prepareStatement(sql); return ps; } catch(SQLException e){ System.out.println("Error occured when create preparedStatemnet:"+e); throw e; } } public int executeInsert(String sql){//新增函数 int num = 0; try{ num = stmt.executeUpdate(sql); }catch(SQLException ex){ // JOptionPane.showMessageDialog(null, "执行插入有误！"+ex.getMessage()); System.out.println(ex.getMessage()); } CloseDataBase(); return num; } public ResultSet executeQuery(String sql)throws SQLException{//查询函数 rs = null; try { rs=stmt.executeQuery(sql); } catch (SQLException e) { System.out.println("Error occured when query database:"+e); } return rs; } public ResultSet executeQuery()throws SQLException{//预编译的查询函数 try { return ps.executeQuery(); } catch (SQLException e) { System.out.println("Error occured when query database:"+e); throw e; } } /** * 预编译更新函数 */ public int executeUpdate() throws SQLException{ try{ conn.setAutoCommit(false); int r=ps.executeUpdate(); conn.commit(); return r; } catch(SQLException e){ conn.rollback(); System.out.println("Error occured when query database:"+e); throw e; } } public int executeDelete(String sql){//删除函数 int num = 0; try { num = stmt.executeUpdate(sql); } catch (SQLException e) { JOptionPane.showMessageDialog(null, "删除不成功！"+e.getMessage()); } CloseDataBase(); return num; } public int executeUpdate(String sql){//更新函数 int num=0; try{ num=stmt.executeUpdate(sql); }catch(SQLException e){ JOptionPane.showMessageDialog(null,"更新不成功！"+e.getMessage()); } CloseDataBase(); return num; } public void CloseDataBase(){ try{ if(rs!=null){ rs.close(); } if(stmt!=null){ stmt.close(); } if(conn!=null){ conn.close(); } if(ps!=null) conn.close(); }catch(Exception end){ JOptionPane.showMessageDialog(null, "关闭连接不成功"+end.getMessage()); } } }