JDBC JAVA连接数据库

今天我们来看一看java是如何连接数据库的
1.在该项目下面新建一个文件夹lib，将驱动程序jar包拷贝到该文件夹下面
2.选中jar包，右键 build path -> Add to build path
这就将jar包导入了，接下来才可以写代码了
a.新增

   public class TestJDBC1 {
    	public static void main(String[] args) {
    		Connection con = null;
    	 	Statement sta = null;
    		//2 加载驱动程序
    		try {
    			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
    			//3 得到连接
    			String url = "jdbc:sqlserver://localhost:1433;databaseName=studentManager2";
    			con = DriverManager.getConnection(url, "sa", "sa");
    			//4 创建Statement对象
    			sta = con.createStatement();
    			//5 执行sql
    			String sql = "insert into lesson(lesName, context) values('bb','bb')";
    			//sql语句影响的行数
    			int rows = sta.executeUpdate(sql);
    			if (rows == 1) {
    				System.out.println("新增成功");
    			} else {
    				System.out.println("新增失败");
    			}
    		} catch (ClassNotFoundException e) {
    			e.printStackTrace();
    		} catch (SQLException e) {
    			e.printStackTrace();
    		} finally {
    			try {
    				if (sta != null) {
    					sta.close();
    					sta = null;
    				}
    				if (con != null) {
    					con.close();
    					con = null;
    				}
    	 		} catch (SQLException e) {
    				e.printStackTrace();
    			}
    		}
    	}
    }

修改，删除都是同样的写法
b.查询

public class TestJDBC3Select {
	public static void main(String[] args) {
		Connection con = null;
		Statement sta = null;
		ResultSet rs = null;
		//2 加载驱动程序
		try {
 			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			//3 得到连接
			String url = "jdbc:sqlserver://localhost:1433;databaseName=studentManager2";
			con = DriverManager.getConnection(url, "sa", "sa");
			//4 创建Statement对象
			sta = con.createStatement();
			//5 执行sql
			String sql = "select stuId, stuName, stuAddress as stuA, stuBtd, stuTel, stuSex from student";
			rs = sta.executeQuery(sql);
			//有下一行
			while(rs.next()) {
				int id = rs.getInt("stuId");
				String stuName = rs.getString("stuName");
				String stuAddress = rs.getString("stuA");
				Date stuBtd = rs.getDate("stuBtd");
				String stuTel = rs.getString("stuTel");
				boolean stuSex = rs.getBoolean("stuSex");
				/*
				int id = rs.getInt(1);
				String stuName = rs.getString(2);
				String stuAddress = rs.getString(3);
				Date stuBtd = rs.getDate(4);
				String stuTel = rs.getString(5);
				boolean stuSex = rs.getBoolean(6);
				*/
				System.out.println(id + ", " + stuName + ", " + stuAddress + ", " + stuBtd + ", " + stuTel + ", " + stuSex);
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				if (rs != null) {
					rs.close();
					rs = null;
				}
				if (sta != null) {
					sta.close();
					sta = null;
				}
				if (con != null) {
					con.close();
					con = null;
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}