Java 1203 JDBC

package com.lovo;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * 数据库
 * @author Dean
 *
 */

public class Test01 {
	public static void main(String[] args) {
		Connection con = null;
		// 1.加载驱动程序
		try {
			Class.forName("com.mysql.jdbc.Driver");
			// 2.创建连接;
			con = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/company", 
					"root", "123456");
			System.out.println(con + "：连接成功");
			// 3.创建语句对象
			Statement stmt = con.createStatement();
			// 4.发出SQL语句得到结果集（游标）
			ResultSet rs = stmt.executeQuery("select * from emp");
			// 5.循环遍历结果集
			while(rs.next()){  //先判断游标是否可以取到下一条记录
				System.out.println("姓名:" + rs.getString("ename"));
				System.out.println("工资:" + rs.getInt("sal"));
				System.out.println("=====分割线=====");
			}
			
			//更新一条数据
			int temp = stmt.executeUpdate("Update emp set ename ='曾雯' where eno=4466");
			System.out.println(temp);
		    //删除一条数据	
			int temp1 = stmt.executeUpdate("Delete from emp  where eno=4466");
			System.out.println(temp1);
			//添加一条数据
			int temp2 = stmt.executeUpdate("insert into emp (eno,ename,job,mgr,sal,comm,dno) "
					+ "values(4466,'黄佳梦','会计',5566,4000,300,10)");
			System.out.println(temp2);
			
			//批量加入数据
			stmt.addBatch("insert into emp values(4411,'龙哥','会计',5566,3000,300,10)");
			stmt.addBatch("insert into emp values(4422,'梦姐','会计',5566,3100,400,10)");
			stmt.addBatch("insert into emp values(4433,'炮娘','会计',5566,3200,100,10)");
			int[] count = stmt.executeBatch();
			for(int i=0; i<count.length; i++){
				System.out.println("第" + (i+1) + "条语句影响的行数为：" + count[i] );
			}
			
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{
			if(con != null){
				try {
					con.close();  // 6.关闭连接
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		}
	}

}