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(); } }