1.Java与sqlserver连接跟Mysql不同的地方:
DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQLServerDriver());
jdbc:sqlserver://localhost:1433;DatabaseName=students1
2.关闭rs.close()之前要判空if(rs!=null),以防出现空指针
3.可以对释放资源新建一个类
4.Java与sqlserver连接步骤(以数据库查询为例):
//注册驱动
DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQLServerDriver());
//建立连接
conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=students1","Test" , "123456");
//创建statment,跟数据库打交道的对象
st = conn.createStatement();
//执行查询,得到结果集
String sql="select * from C";
rs = st.executeQuery(sql);
//遍历查询每条记录
while(rs.next()) {
String cno=rs.getString("cno");
String cname=rs.getString("cname");
String cpno=rs.getString("cpno");
String teacher=rs.getString("teacher");
String credit=rs.getString("credit");
System.out.println("cno="+cno+"--cname="+cname+"--cpno="+cpno+"--teacher="+teacher+"--credit="+credit);
}
//释放资源
try {
if(rs!=null) {
rs.close();
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
rs=null;
}
5.组织结构
6.运行截图
7.实验源代码
Jdbc.java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import Util.JDBCUtil;
public class Jdbc {
public static void main(String[] args) {
Connection conn=null;
Statement st=null;
ResultSet rs=null;
try {
//注册驱动
DriverManager.registerDriver(new com.microsoft.sqlserver.jdbc.SQLServerDriver());
//建立连接
conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=students1","Test" , "123456");
//创建statment,跟数据库打交道的对象
st = conn.createStatement();
//执行查询,得到结果集
String sql="select * from C";
rs = st.executeQuery(sql);
//遍历查询每条记录
while(rs.next()) {
String cno=rs.getString("cno");
String cname=rs.getString("cname");
String cpno=rs.getString("cpno");
String teacher=rs.getString("teacher");
String credit=rs.getString("credit");
System.out.println("cno="+cno+"--cname="+cname+"--cpno="+cpno+"--teacher="+teacher+"--credit="+credit);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
JDBCUtil.release(conn, st, rs);
}
}
}
JDBCUTil.java
package Util;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCUtil {
/*
*
* 释放资源
*
*
*/
public static void release(Connection conn,Statement st,ResultSet rs) {
closeRs(rs);
closeSt(st);
closeConn(conn);
}
private static void closeRs(ResultSet rs) {
try {
if(rs!=null) {
rs.close();
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
rs=null;
}
}
private static void closeSt(Statement st) {
try {
if(st!=null) {
st.close();
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
st=null;
}
}
private static void closeConn(Connection conn) {
try {
if(conn!=null) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
conn=null;
}
}
}