[大数据]作业3 学习中。。

题1、

create databases phone_book;。
create table info(id char(2),name char(3),tel char(11),sex char(1));
insert into info values(“1”,“陈一”,“13948375828”,“男”);
Query OK, 1 row affected (0.07 sec)

mysql> insert into info values(“2”,“舒肤佳”,“18248375928”,“女”);
Query OK, 1 row affected (0.06 sec)

mysql> insert into info values(“3”,“张三”,“18268300928”,“男”);
Query OK, 1 row affected (0.13 sec)

mysql> insert into info values(“4”,“李四”,“18168900928”,“男”);
Query OK, 1 row affected (0.10 sec)

mysql> insert into info values(“5”,“王五”,“18268900928”,“男”);
Query OK, 1 row affected (0.15 sec)

mysql> insert into info values(“6”,“甘语”,“18264900923”,“女”);
Query OK, 1 row affected (0.06 sec)

mysql> insert into info values(“7”,“花语”,“18364900923”,“女”);
Query OK, 1 row affected (0.06 sec)

mysql> insert into info values(“8”,“和健”,“18364990923”,“男”);
Query OK, 1 row affected (0.11 sec)

mysql> insert into info values(“9”,“温捷克”,“17364990923”,“男”);
Query OK, 1 row affected (0.07 sec)

mysql> insert into info values(“10”,“文利”,“18264350923”,“男”);

题2、

try {
sql=con.prepareStatement(“select*from info;”);
System.out.println(“通讯录信息：”);
while(res.next()) {
String id=res.getString(1);
String name=res.getString(“name”);
String tel=res.getString(“tel”);
String sex=res.getString(“sex”);
System.out.println(“id是:”+id);
System.out.println(“姓名是:”+name);
System.out.println(“电话是:”+tel);
System.out.println(“性别是:”+sex);

}sql=con.prepareStatement("insert into info" + "values(?,?,?,?)");
sql.setString(1, "11");
sql.setString(2, "独居");
sql.setString(3, "16478327483");
sql.setString(4, "男");
sql=con.prepareStatement("insert into info" + "values(?,?,?,?)");
sql.setString(1, "12");
sql.setString(2, "独顾");
sql.setString(3, "18478327483");
sql.setString(4, "男");
sql=con.prepareStatement("insert into info" + "values(?,?,?,?)");
sql.setString(1, "13");
sql.setString(2, "独萨克斯");
sql.setString(3, "18278447483");
sql.setString(4, "男");
sql=con.prepareStatement("select*from info"+"where tel like '?%'");
sql.setString(1, "182");
sql=con.prepareStatement("update info set tel"+"=? where id=?");
sql.setString(1, "12345678901");
sql.setString(2, "5");
sql=con.prepareStatement("select*from info"+"where sex=?");
sql.setString(1, "男");
sql=con.prepareStatement("update info set sex"+"=? where id=?");
sql.setString(1, "大帅哥");
sql.setString(2, "10");
sql=con.prepareStatement("select*from info"+"where tel like '?%'");
sql.setString(1, "139");
sql=con.prepareStatement("delete from info where id=?");
sql.setString(1, "3");
sql=con.prepareStatement("select*from info"+"where sex=?");
sql.setString(1, "女");

}catch(Exception e) {
e.printStackTrace();
}
}

电脑之前装了个office2016 ，电脑c盘内存不足4g，卡到其它软件用不了，闪退等问题频频出现，本身电脑是3年前二手陶的（我表哥帮忙购买），所以有想办法重装电脑，各种问题磕磕碰碰，时间是其一，上课是没有实践，下课又在弄电脑问题，学习稀里糊涂，正在补习。。。，只能做出个大概（真正实力）。因为学过MySQL，所以一些查询还是会，主要是那些连数据库之类的不太清楚。