1:连接JDBC
a.导入jar包
在模块下创建一个lib文件夹 --> 将jar文件复制到lib下 -->选中lib 邮件 add as library;
b.注册驱动
Class.forName("com.mysql.jdbc.Driver");
c.获取连接
Connection conn = DriverManager.getConnection(url,username,password);
url:连接路径
jdbc:mysql://loclhost:port/库名?characterEncoding=utf8&useSSL=false
username:账号 root
password:密码 root
d.编写sql
e.获取执行对象
Statement stat = conn.createStatment();
f.执行sql
stat.update(sql)
g.关闭连接
conn.close();
stat.close();
2:例
以course表为例,在使用查时需另建一个名为course的javaclass(类),里面写号course表的结构如
private Integer id;等都用private修饰,并创建有参无参构造方法,getset,tostring。
//查:查询表中所有数据 Class.forName("com.mysql.jdbc.Driver"); Connection conn = DriverManager.getConnection("jdbc:mysql:///db01", "root", "123456"); Statement statement = conn.createStatement(); String sql="select * from course"; ResultSet resultSet = statement.executeQuery(sql); while (resultSet.next()){ course a1=new course(); a1.setId(resultSet.getInt("id")); a1.setName(resultSet.getNString("name")); System.out.println(a1); } conn.close(); statement.close(); //改:将id为17的字段的id改为5 Class.forName("com.mysql.jdbc.Driver"); Connection conn = DriverManager.getConnection("jdbc:mysql:///db01", "root", "123456"); Statement statement = conn.createStatement(); String sql="update course set id=5 where id=17"; int i = statement.executeUpdate(sql); System.out.println(i); conn.close(); statement.close(); //增:表中新增一个id为6,name为sxsx的字段 Class.forName("com.mysql.jdbc.Driver"); Connection conn = DriverManager.getConnection("jdbc:mysql:///db01", "root", "123456"); String sql="insert into course values(?,?)"; PreparedStatement ps = conn.prepareStatement(sql); ps.setInt(1,6); ps.setString(2,"sxsx"); int i = ps.executeUpdate(); System.out.println(i); conn.close(); ps.close(); //删:删除表中id为6的字段 Class.forName("com.mysql.jdbc.Driver"); Connection conn = DriverManager.getConnection("jdbc:mysql:///db01", "root", "123456"); String sql="delete from course where id=6"; Statement statement = conn.createStatement(); int i = statement.executeUpdate(sql); System.out.println(i); conn.close(); statement.close();