java与数据库的连接

步骤一创建数据库
create table tbmusic(
id int primary key auto_increment,
name varchar(64) default ‘未知’,
artist varchar(20) default ‘匿名’,
ablum varchar(20) default ‘unknow’,
style varchar(30),
path varchar(1024),
size int,
uptime timestamp default CURRENT_TIMESTAMP);

用jdbc来与数据库连接

public class JDBCDemo2 {

public static void main(String[] args) throws ClassNotFoundException, SQLException {
	
	//1.加载驱动
	Class.forName("com.mysql.jdbc.Driver");
	//2.获取连接
	Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/music","root","root");
	
	String sql = "select * from tbmusic";
	//3.获取执行sql语句的命令对象
	PreparedStatement ps = conn.prepareStatement(sql);
	//4.执行(查询操作)
	ResultSet rs = ps.executeQuery();
	//5.处理结果
	while(rs.next()){
		//获取当前结果集的一行中的每一列数据
		int id = rs.getInt("id");
		String name = rs.getString("name");
		Timestamp uptime = rs.getTimestamp("uptime");
		String artist = rs.getString("artist");
		String ablum = rs.getString("ablum");
		String style = rs.getString("style");
		String path = rs.getString("path");
		int size = rs.getInt("size");
		//输出结果
		System.out.println(name+"--"+artist+"--"+ablum+"--"+style+"--"+path);
	}
	//6.关闭资源
	rs.close();
	ps.close();
	conn.close();
}
}

实现在java代码中对数据库的添加数据

ublic class JDBCDemo {

//代码提示快捷键:alt + /
public static void main(String[] args) throws ClassNotFoundException, SQLException {
	//1.加载驱动
	Class.forName("com.mysql.jdbc.Driver");
	//2.获取连接
	Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/music","root","root");
	//准备sql语句
	String sql = "insert into tbuser(username,password,phone) values('mrchai','123','1323214567')";
	
	//3.获取处理sql语句的命令对象
	PreparedStatement ps = conn.prepareStatement(sql);
	//4.执行(更新操作)
	int i = ps.executeUpdate();
	//5.处理结果
	if(i > 0){
		System.out.println("添加成功");
	}
	//6.关闭资源
	ps.close();
	conn.close();
}
}