JDBC连接SQLserver

下载SQL Server的JDBC的那个Jar包

• https://www.microsoft.com/zh-cn/download/details.aspx?id&＃61;11774

建立java工程

• 贴入代码


import java.sql.*;
import java.util.Properties;public class class1
{public static void main(String[] args) {Connection connect &＃61; null;Statement statement &＃61; null;ResultSet resultSet &＃61; null;try {Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");System.out.println(3423);connect &＃61; DriverManager.getConnection("jdbc:sqlserver://localhost:2433;DatabaseName&＃61;mydatabase", "sa", "123");System.out.println(connect);statement &＃61; connect.createStatement();statement.execute("create table student (ID int )");statement.executeUpdate("insert into student values(2012)");statement.executeUpdate("insert into student values(20118)");resultSet&＃61;statement.executeQuery("select * from student");//第五步&＃xff1a;处理结果集while (resultSet.next()){int id &＃61; resultSet.getInt("id");System.out.println(id); //打印输出结果集}statement.execute("drop table student");} catch (Exception e) {e.printStackTrace();}finally {//第六步&＃xff1a;关闭资源try {if (resultSet!&＃61;null) resultSet.close();if (statement!&＃61;null) statement.close();if (connect!&＃61;null) connect.close();} catch (SQLException e) {e.printStackTrace();}}}
}
端口咋确定

• 打开SQL Server Confiquration Manager

• 对着TCP/IP一顿操作
  

咋重启服务呢&＃xff1f;

• 好啦&＃xff01;