/*增*/
/*String sql="insert into tb_user(id,username,password) value(4,'发发发','104')";
stmt.execute(sql);*/
/*修改*/
String sql="update tb_user set username='范潇潇' where id=4";
stmt.execute(sql);
/*删除*/
/*String sql="delete from tb_user where id=4";
stmt.execute(sql);*/
/*数据库查询操作*/
ResultSet rs = stmt.executeQuery("select * from tb_user");
while(rs.next()) {
System.out.print("id:"+rs.getInt("id"));
System.out.print(" username:"+rs.getString("username"));
System.out.println(" password:"+rs.getString("password"));
/*System.out.println(" address:"+rs.getString("address"));*/
}
package com.runoob.text;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class MySQLDemo {
public static void main(String[] args) {
String driver="com.mysql.jdbc.Driver";//数据库驱动类所对应的字符串
String URL="jdbc:mysql://localhost:3306/db_shop?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8";
//URL语法格式如下
//db_shop为数据库名
//jdbc:mysql:是固定的写法,后面跟主机名localhost,3306是默认的MySQL端口号
//serverTimezone=UTC是指定时区时间为世界统一时间
//useUnicode=true是指是否使用Unicode字符集,赋值为true
//characterEncoding=utf-8是指定字符编码格式为UTF8
Connection conn=null;
//Connection接口代表Java程序和数据库的连接对象,只有获得该连接对象后,才能访问数据库,并操作数据表
try {
Class.forName(driver);//加载MySQL数据库驱动
}catch(java.lang.ClassNotFoundException e) {//如果找不到这个类,执行下面的异常处理
System.out.println("驱动程序配置未配置成功!!!");
}
try {
conn=DriverManager.getConnection(URL,"root","root");//建立和数据库的连接,并返回表示连接的Connection对象
System.out.println("数据库连接成功!!!");
Statement stmt = conn.createStatement();
/*增*/
/*String sql="insert into tb_user(id,username,password) value(4,'发发发','104')";
stmt.execute(sql);*/
/*修改*/
String sql="update tb_user set username='范潇潇' where id=4";
stmt.execute(sql);
/*删除*/
/*String sql="delete from tb_user where id=4";
stmt.execute(sql);*/
/*数据库查询操作*/
ResultSet rs = stmt.executeQuery("select * from tb_user");
while(rs.next()) {
System.out.print("id:"+rs.getInt("id"));
System.out.print(" username:"+rs.getString("username"));
System.out.println(" password:"+rs.getString("password"));
/*System.out.println(" address:"+rs.getString("address"));*/
}
}catch(Exception e) {//未连接成功,执行下面的异常处理
System.out.println("数据库连接失败!!!");
}
}
}