使用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);
}
}
}
}