package jdbc_package;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
public class ConnMysqlTest1 {
public static void main(String[] args) throws ClassNotFoundException, SQLException, IOException {
//获取配置
ArrayList<String> listProper = PropertiesGet.getProperties();
//注册jdbc驱动
Class.forName(listProper.get(0));
//连接
String url = listProper.get(1);
String usename = listProper.get(2);
String password = listProper.get(3);
Connection conn = DriverManager.getConnection(url, usename, password);
//获取语句执行平台,通过数据库连接对象,获取到SQL语句的执行者对象
Statement stat = conn.createStatement();
// //执行sql语句,插入
// String sql1 = "insert into sort(sname, sprice, sdesc) values('汽车用品', 50000, '疯狂涨价')";
// int a1 = stat.executeUpdate(sql1);
// System.out.println("插入了"+a1+"条数据");
// //执行sql语句,删除
// String sql1 = "delete from sort where sid>7";
// int a1 = stat.executeUpdate(sql1);
// System.out.println("删除了"+a1+"条数据");
//执行sql语句,修改
String sql1 = "update sort set sprice=20 where sid=6";
int a1 = stat.executeUpdate(sql1);
System.out.println("修改了"+a1+"条数据");
a0.close();
stat.close();
conn.close();
}
}