Myeclipse如何连接sql server2012数据库

缺乏、安全感 2022-01-10 05:41 383阅读 0赞

第一步、下载连接的jar包[https://download.csdn.net/download/qq\_37591637/11251667][https_download.csdn.net_download_qq_37591637_11251667]

第二步、把jar包放在项目的lib下面

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NTkxNjM3_size_16_color_FFFFFF_t_70][]

第三步、查看sqlserver的ip地址和端口号

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NTkxNjM3_size_16_color_FFFFFF_t_70 1][]

Sql server网络配置--MSSQLSERVER的协议

1、启用所有的协议

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NTkxNjM3_size_16_color_FFFFFF_t_70 2][]

2、点击TCP/IP，查看端口号和ip地址

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NTkxNjM3_size_16_color_FFFFFF_t_70 3][]

Java代码如下

package cn.com.jdbc;
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import cn.com.bean.User;
    public class ConnectJdbc {
    	public static void main(String[] args) {
    		Conn();
    	}
    public static void Conn(){
    	Connection ct = null; 
    	PreparedStatement ps = null;
    	ResultSet rs = null; try {
    		//1.加载驱动
    		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); 
    		//2.得到连接
    		ct = DriverManager.getConnection("jdbc:sqlserver://192.168.1.152:1433;databaseName = lay", "sa", "123456");
    		//3.发送sql语句 
    		ps =ct.prepareStatement("select * from [user]"); 
    		//4.执行
    		rs = ps.executeQuery();
    		//循环取出雇员的名字，薪水，部门的编号
    		while(rs.next()) {
    			User u=new User(rs.getInt(1), rs.getString(2), rs.getString(3));
    			System.out.println(u); 
    			}
    		} catch (Exception e) { 
    			e.printStackTrace(); 
    			// TODO: handle exception 
    			}finally {
    				try {
    					rs.close(); 
    					ps.close();
    					ct.close();
    					} catch (SQLException e) {
    						// TODO Auto-generated catch block 
    						e.printStackTrace(); }
    				}
    			}
    
    }

代码的运行结果如下

![20190621081554539.png][]

Sql server如下

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NTkxNjM3_size_16_color_FFFFFF_t_70 4][]

[https_download.csdn.net_download_qq_37591637_11251667]: https://download.csdn.net/download/qq_37591637/11251667
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NTkxNjM3_size_16_color_FFFFFF_t_70]: /images/20220109/a861d789b91d43eaacf0b933566c50e6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NTkxNjM3_size_16_color_FFFFFF_t_70 1]: /images/20220109/207d33fe8b5843f1beea6d88ab292e23.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NTkxNjM3_size_16_color_FFFFFF_t_70 2]: /images/20220109/769aec2f97864437a8324b6062f2eff4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NTkxNjM3_size_16_color_FFFFFF_t_70 3]: /images/20220109/78c7c76dc4db4874ad4e895e4d48a099.png
[20190621081554539.png]: /images/20220109/39a85958d07c495b960e6c2dde3005c8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3NTkxNjM3_size_16_color_FFFFFF_t_70 4]: /images/20220109/7d949f83c03c423da116a090c5371bf4.png