赞
踩
File new module 然后勾选 路径要并列
package cn.tedu.api;
import java.util.ArrayList;
import java.util.Iterator;
/**
* ArrayList
* 迭代
*/
public class Demo01 {
public static void main(String[] args) {
//创建集合
ArrayList<String> List = new ArrayList<String>();
List.add("孟凡");
List.add("刘斌");
List.add("高文强");
System.out.println(List);
//方法一:利用for循环
for (int i=0;i<List.size();i++){
System.out.println(List.get(i));
}
//方法二:增强性for循环
for (String name : List){
System.out.println(name);
}
//方法三:迭代器
Iterator<String> it = List.iterator();
while (it.hasNext()){
String name = it.next();
System.out.println(name);
}
}
}
package cn.tedu.api;
import java.util.HashSet;
import java.util.Iterator;
/**
* HashSet:也可以存储元素,但是存进与取出的顺序不同
*
*/
public class Demo02 {
public static void main(String[] args) {
HashSet<String> set = new HashSet<String>();
set.add("aaa");
set.add("bbb");
set.add("ccc");
System.out.println(set);//[aaa, ccc, bbb]
//不添加重复的元素
set.add("ccc");
System.out.println(set);//[aaa, ccc, bbb]
//使用迭代器————HashSet只能用迭代器输出
for (Iterator<String> it = set.iterator();it.hasNext();){
String name = it.next();
System.out.println(name);/*aaa
ccc
bbb*/
}
}
}
package cn.tedu.api;
import com.sun.org.apache.xml.internal.serializer.utils.SerializerMessages;
import java.util.HashMap;
import java.util.Iterator;
import java.util.Map;
import java.util.Set;
/**
* Map
* HashMap:键值对存储的,key-value
*/
public class Demo03 {
public static void main(String[] args) {
Map<String,String> map = new HashMap<String,String>();
//添加元素
map.put("l","刘星星");
map.put("d","刁雨露");
map.put("j","贾一凡");
System.out.println(map);//{d=刁雨露, j=贾一凡, l=刘星星}
//获取元素,格式:json xml txt(json使用较多,体积小)
String name = map.get("d");
System.out.println(name);//刁雨露
//将j再次输入,则会被替代——使用HashMap尽量一一对应
map.put("j","贾静雯");
String name2 = map.get("j");
System.out.println(name2);//贾静雯
//迭代map集合
Set<String> set = map.keySet();//获取所以的key
Iterator it = set.iterator();
while (it.hasNext()){
String key = (String) it.next();//此处要导包
String value = map.get(key);
System.out.println("key:"+key+" "+"value:"+value);/*key:d value:刁雨露
key:j value:贾静雯
key:l value:刘星星*/
}
}
}
//练习:独立实现,迭代List集合,map集合,set集合
数据库的产品:Oracle/MySql/db2/SQLServer
软件运行期间,Java程序调用的是数据库厂商提供的具体的API,数据库厂商提供的具体的驱动程序,也就实现了JDBC的标准。
package cn.tedu.jdbc;
import javax.swing.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
* 使用JDBC创建连接
*/
public class Demo05 {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
String className = "com.mysql.jdbc.Driver";
/**
* jdbc:mysql:设置驱动程序类
* localhost:3306/tedu_store 作为数据库的地址
* 端口号:3306
* useSSL=true 高版本的mysql安全性数据交互的选项
* user:数据库的用户名
* password:数据库的密码
*/
String url = "jdbc:mysql://localhost:3306/tedu_store?useUnicode=true&characterEncoding=utf-8";
String user = "root";
String password = "123456";
//1、加载驱动程序
Class.forName(className);
System.out.println("加载成功!!!");
// DriverManager.getConnection();
//2、创建连接(要求数据表必须能连通)
Connection conn = DriverManager.getConnection(url,user,password);
System.out.println(conn);
System.out.println("已经与数据库成功建立连接!");
}
}
package cn.tedu.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
/**
* 向tedu_user表中插入数据,添加一条数据
*/
public class Demo06 {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
String className = "com.mysql.jdbc.Driver";
//1、加载驱动
Class.forName(className);//加异常
System.out.println("加载成功!");
//2、建立连接
String url = "jdbc:mysql://localhost:3306/tedu_store?useUnicode=true&characterEncoding=utf-8";
String user = "root";
String password = "123456";
Connection conn = DriverManager.getConnection(url,user,password);//加异常
System.out.println(conn);
System.out.println("已经与数据库成功建立连接!");
//3、发送sql语句
Statement st = conn.createStatement();//Statement对象,用来发送并执行sql语句
String sql = "INSERT INTO tedu_user(username,password,email,phone,image,gender,created_user,created_time,modified_user,modified_time)" +
"VALUES ('明明子','123456','12345678','12345678910','123',1,'1',NOW(),'1',NOW());";
int row = st.executeUpdate(sql);//executeUpdate:更新sql语句,中间要放入sql语句
if(row>0){
System.out.println("数据注册成功!");
}
/* /* String sql3 = "UPDATE tedu_user SET id=1 where id=2027";
int row3 = st.executeUpdate(sql3);//executeUpdate:更新sql语句,中间要放入sql语句
if(row3>0){
System.out.println("数据更新成功!");
}*/
//4、关闭
if(conn != null){
conn.close();
}
}
}
//删除 改 就改变sql语句
package cn.tedu.jdbc;
import java.sql.*;
public class Demo09 {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
String className = "com.mysql.jdbc.Driver";
//1、加载驱动
Class.forName(className);//加异常
System.out.println("加载成功!");
//2、建立连接
String url = "jdbc:mysql://localhost:3306/tedu_store?useUnicode=true&characterEncoding=utf-8";
String user = "root";
String password = "123456";
Connection conn = DriverManager.getConnection(url,user,password);//加异常
System.out.println(conn);
System.out.println("已经与数据库成功建立连接!");
//3、发送sql语句
Statement st = conn.createStatement();
String sql = "SELECT *FROM tedu_user";
//ResultSet——结果集对象
ResultSet rs = st.executeQuery(sql);
//4、处理结果集对象
//移动结果集指针查看每一条数据
while (rs.next()){
int id = rs.getInt("id");
String username = rs.getString("username");
Timestamp created_time = rs.getTimestamp("created_time");
System.out.println(id+"\t"+username+"\t"+created_time);
}
//关闭
if(conn != null){
conn.close();
}
}
}
//建一张学生表
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。