class.forName();
创建数据库的连接
C = driverManager.getConnection( ip地址 , 数据库名称 ,密码);
建立命令语句
statement s = con.createStatement();
准备SQL语句
执行SQL语句
resultset rs = stmt.executrquery(sql);
处理结果通过迭代器
关闭流桥
package newpackage; import java.sql.*; import javax.sql.*; public class JdbcSql { public static void main(String[] args) { try{ //1.加载SQL驱动 Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); //2.创建与数据库服务器的连接 Connection con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName =adventureworksdw", "sa","123" ); //创建SQL语句命令 Statement state = con.createStatement(); //准备SQL语句 String sql = "select Phone from DimReseller"; //执行语句 ResultSet rs =state.executeQuery(sql); //处理结果,显示查询到的记录 while(rs.next()){ String r= ""; r =rs.getString("Phone"); System.out.println(r); } rs.close(); state.close(); con.close(); }catch(SQLException e){ e.printStackTrace(); } catch (ClassNotFoundException ex) { ex.printStackTrace(); } } }