使用JTDS连接SQLServer数据库
public class DBHelp {
private static Connection getSQLConnection(){
Connection con = null;
try {
Class.forName("net.sourceforge.jtds.jdbc.Driver");
con =DriverManager.getConnection("jdbc:jtds:sqlserver://192.168.1.5;DatabaseName=S1", "sa", "123456");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}
public static String QuerySpinner(String SQL){
String result ="";
try {
Connection conn = getSQLConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(SQL);
while (rs.next())
{
String s1 = rs.getString("name");
result += s1+"-";
}
rs.close();
stmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
result += "查询数据异常!" + e.getMessage();
}
return result;
}
解决方案:
1、打开SQL Server Configuration Manager -> Protocols for SQLEXPRESS -> TCP/IP
2、右键单击启动TCP/IP
3、双击进入属性,把IP地址中的IP all中的TCP端口设置为1433
4、重新启动SQL Server 2014服务
参考资料:https://blog.csdn.net/hymcn/article/details/7993109