本文共 1607 字，大约阅读时间需要 5 分钟。
使用jdbc创建一张员工表
员工表字段：编号，姓名，性别，年龄，职位，邮箱，电话使用jdbc对员工表执行以下操作：
1）插入一条数据 2）修改一条数据 3）删除一条数据 4）查询并打印所有员工数据import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;import org.junit.Test;public class WorkerTable { private String url = "jdbc:mysql://localhost:3306/tablename"; private String user = "****"; private String password = "****"; @Test public void test() { Statement stmt = null; Connection conn = null; try { // 1.驱动注册程序 Class.forName("com.mysql.jdbc.Driver"); // 2.获取连接对象 conn = DriverManager.getConnection(url, user, password); // 3.创建Statement stmt = conn.createStatement(); // 4.准备sql// String sql = "CREATE TABLE worker(id INT PRIMARY KEY AUTO_INCREMENT,name VARCHAR(20),gender VARCHAR(8))";// String sql = "INSERT INTO `day01`.`worker` (`id`, `name`, `gender`) VALUES (2, 'zhangsan', 20)";// String sql = "UPDATE `day01`.`worker` SET `id`='2', `name`='lisi', `gender`='女' WHERE (`id`='2')"; String sql = "DELETE FROM worker WHERE id = 2"; // 5.发送sql语句，执行sql语句,得到返回结果 int count = stmt.executeUpdate(sql); // 6.输出 System.out.println("影响了" + count + "行！"); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); // throw new RuntimeException(e); } finally { // 7.关闭连接(顺序:后打开的先关闭) if (stmt != null) try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); // throw new RuntimeException(e); } if (conn != null) try { conn.close(); } catch (SQLException e) { e.printStackTrace(); // throw new RuntimeException(e); } } }} 转载地址：http://wpnmb.baihongyu.com/