package text;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.mchange.v2.c3p0.ComboPooledDataSource;
public class c3p0_01 {
public static void main(String[] args) throws SQLException {
ComboPooledDataSource c3p0pool = new ComboPooledDataSource("dev");
Connection connection = c3p0pool.getConnection();
//增 删 改 查
//增
/*
String sql = "insert into users values(?,?,?,?)";
PreparedStatement prepareStatement = connection.prepareStatement(sql);
prepareStatement.setInt(1,2);
prepareStatement.setString(2,"guo");
prepareStatement.setString(3,"guo@qq.com");
prepareStatement.setString(4,"guoasdsad");
int i = prepareStatement.executeUpdate();
System.out.println("成功增加"+i+"条数据");
*/
//删
/*
String sql = "delete from users where id = ?";
PreparedStatement prepareStatement = connection.prepareStatement(sql);
prepareStatement.setInt(1,2);
int i = prepareStatement.executeUpdate();
System.out.println("成功删除"+i+"条数据");
*/
//改
/*
String sql = "update users set name = ? where id = ?";
PreparedStatement prepareStatement = connection.prepareStatement(sql);
prepareStatement.setString(1,"guo123");
prepareStatement.setInt(2,1);
int i = prepareStatement.executeUpdate();
System.out.println("成功修改"+i+"条数据");
*/
//查
String sql = "select * from users where id = ?";
PreparedStatement prepareStatement = connection.prepareStatement(sql);
prepareStatement.setInt(1,1);
ResultSet i = prepareStatement.executeQuery();
while(i.next()) {
System.out.println(i.getString("name"));
}
i.close();
prepareStatement.close();
connection.close();
c3p0pool.close();
}
}