package text;
import java.beans.PropertyVetoException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class c3p0 {
public static void main(String[] args) throws SQLException, PropertyVetoException {
ComboPooledDataSource c3p0 = new ComboPooledDataSource();
c3p0.setDriverClass("com.mysql.jdbc.Driver");
c3p0.setJdbcUrl("jdbc:mysql://localhost:3306/jdbc?useSSL=false");
Connection connection = c3p0.getConnection("root","root");
//增 删 改 查
//查询
Statement sqlquery = connection.createStatement();
String sql = "select * from users";
ResultSet resultSet = sqlquery.executeQuery(sql);
while(resultSet.next()) {
String id = resultSet.getString("id");
String name = resultSet.getString("name");
String email = resultSet.getString("email");
String password = resultSet.getString("password");
System.out.println("id--"+id+"name--"+name+"email--"+email+"password--"+password);
}
//增 删 改 查
/* 增
Statement sqlquery = connection.createStatement();
String sql = "insert into users values(1,'张三','zs@qq.com','zxzx')";
int i = sqlquery.executeUpdate(sql);
System.out.println("成功插入"+i+"条数据");
*/
/* 改
Statement sqlquery = connection.createStatement();
String sql = "update users set name=\"zxc\" where id=8";
int i = sqlquery.executeUpdate(sql);
System.out.println("成功修改"+i+"条数据");
*/
/* 查
Statement sqlquery = connection.createStatement();
String sql = "delete from users where id = 8";
int i = sqlquery.executeUpdate(sql);
System.out.println("成功删除"+i+"条数据");
*/
resultSet.close();
sqlquery.close();
connection.close();
c3p0.close();
}
}