<%@ page language="java" contentType="text/html; charset=GB2312"
pageEncoding="GB2312"%>
<%@ page import="java.io.*,java.util.*,java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Connect Mysql</title>
</head>
<body>
<%
try {
// 设置驱动器名
String driver = "com.mysql.jdbc.Driver";
// MySQL配置时的用户名
String user = "root";
// Java连接MySQL配置时的密码
String password = "Donghao@123";
// 所要连接的MySQL库名
String database = "donghao";
// URL指向要访问的数据库名
String url = "jdbc:mysql://localhost:3306/" + database + "?user=" + user + "&password=" + password + "&useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC";
// 0 连接数据库
out.print("正在连接数据库……</br>");
// 1 加载驱动程序
Class.forName(driver);
// 2 连接数据库
Connection conn = DriverManager.getConnection(url);
if(!conn.isClosed()){
out.print("数据库连接成功!!!</br></br>");
}else{
out.print("数据库连接失败!!!</br></br>");
}
//增
/*
// 3 要执行的sql语句--插入语句
String sqla="Insert into dh(dh_tilte, dh_author, submission_data) values(?,?,?)";
PreparedStatement pstmt=conn.prepareStatement(sqla);
// 4 设置插入内容
pstmt.setString(1, "测试3");
pstmt.setString(2, "董浩3");
pstmt.setString(3, "2018-10-07");
// 5 执行插入语句
int n = pstmt.executeUpdate();
if (n == 3) {
out.println("插入成功!</br>");
} else {
out.println("插入失败!</br>");
}
pstmt.close();
*/
//删
/*
// 删除数据
out.print("正在删除数据库中的某些内容……</br>");
// 要执行的SQL语句--删除语句
String sqlb = "delete from dh where dh_author=?";
PreparedStatement pst=conn.prepareStatement(sqlb);
// 设置删除内容
pst.setString(1,"??");
// 执行删除语句
int flag= pst.executeUpdate();
if(flag > 0){
out.println("删除成功!</br></br>");
} else {
out.println("删除失败!</br></br>");
}
pst.close();
*/
//改
//修改数据
out.print("正在修改数据库中的某些内容……</br>");
// 要执行的SQL语句--删除语句
String sqlc = "update dh set dh_tilte=? where dh_author=?";
PreparedStatement pst=conn.prepareStatement(sqlc);
// 设置删除内容
pst.setString(1,"测试");
pst.setString(2,"董浩2");
// 执行删除语句
int flag= pst.executeUpdate();
if(flag > 0){
out.println("修改成功!</br></br>");
} else {
out.println("修改失败!</br></br>");
}
pst.close();
//查
// 查询数据
out.print("正在查询数据库中的内容……</br>");
// 要执行的SQL语句--查询语句
String sql = "select * from dh";
Statement statement = conn.createStatement();
ResultSet rs = statement.executeQuery(sql);
int id = 0;
String name = null;
String mima = null;
String date = null;
while (rs.next()) {
id = rs.getInt("dh_id");
name = rs.getString("dh_tilte");
mima = rs.getString("dh_author");
date = rs.getString("submission_data");
out.println(id+"\t"+name+"\t\t"+mima+"\t\t"+date+"</br>");
}
rs.close();
conn.close();
} catch (ClassNotFoundException e) {
out.println("Sorry,can`t find the Driver!</br>");
e.printStackTrace();
} catch (SQLException e) {
out.println("Sorry,SQLException!</br>");
e.printStackTrace();
} catch (Exception e) {
out.println("Sorry,Exception!</br>");
e.printStackTrace();
}
%>
</body>
</html>