小知识：idea连接SQL Server数据库的详细图文教程

package com.exit.jdbc; import java.sql.*; import static java.lang.Class.forName; import static java.sql.DriverManager.*; public class JDBCDemo { public static void main(String args[]) throws Exception { //1.加载驱动 Class.forName(“com.microsoft.sqlserver.jdbc.SQLServerDriver”); System.out.println(“加载驱动成功！”); //2.连接 String dbURL = “jdbc:sqlserver://localhost;DatabaseName=db1”;//DatabaseName=跟上要连接的数据库名称，我要连接db1数据库，所以DatabaseName=db1 String user = “sa”; String password = “123456”;//在引号中修改为自己设置的登陆密码 Connection conn = getConnection(dbURL, user, password); System.out.println(“连接数据库成功！”); //3.定义SQL语句 String sql = “select * from account”; //4.获取执行SQL对象并执行 PreparedStatement stmt = conn.prepareStatement(sql); //5.处理结果 ResultSet res = stmt.executeQuery(); while (res.next()) { String System.out.println(title); } //6.释放资源 stmt.close(); conn.close(); } }

package com.exit.jdbc; import java.sql.*; import static java.lang.Class.forName; import static java.sql.DriverManager.*; public class JDBCDemo { public static void main(String args[]) throws Exception { //1.加载驱动 Class.forName(“com.microsoft.sqlserver.jdbc.SQLServerDriver”); System.out.println(“加载驱动成功！”); //2.获取连接 String dbURL = “jdbc:sqlserver://localhost;DatabaseName=db1”;//DatabaseName=跟上要连接的数据库名称，我要连接db1数据库，所以DatabaseName=db1 String user = “sa”; String password = “123456”;//在引号中修改为自己设置的密码 Connection conn = getConnection(dbURL, user, password); System.out.println(“连接数据库成功！”); //3.定义SQL语句 String sql = “update account set money=2000 where id=”1″”; //4.获取执行SQL的对象 Statement stmt = conn.createStatement(); //5.执行SQL语句 int count = stmt.executeUpdate(sql); //6.处理结果，打印出受影响的行数 System.out.println(count); //7.释放资源 stmt.close(); conn.close(); } }