数据库的基本操作
CWQ__xz__
菩提树下的百世轮回......
展开
-
对数据库的添加操作
public int insert(Master master) { int row = 0; try { conn = getConnection(); String sql = "insert into master values(?,?,?)"; stmt = conn.prepareStatement(sql); stmt.setString(1,m...原创 2019-02-09 15:56:27 · 208 阅读 · 0 评论 -
对数据库的信息的更新操作
public int update(Master master) { int row = 0; try { conn = getConnection(); String sql = "update master set name = ? , password = ? , " + " money = ? where id = ?"; stmt = conn.p...原创 2019-02-09 15:58:07 · 386 阅读 · 0 评论 -
对数据库信息的删除
public int delete(int id) { int row = 0; try { conn = getConnection(); String sql = "delete from master where id = ?"; stmt = conn.prepareStatement(sql); //索引值>0 stmt.setInt(1,i...原创 2019-02-09 15:59:39 · 356 阅读 · 0 评论 -
对数据库信息的查寻
public List<Master> select(){ int row = 0; String sql = "select *from master"; List<Master> list = new ArrayList<Master>(); try { conn = getConnection(); stmt = conn.p...原创 2019-02-09 16:02:42 · 131 阅读 · 0 评论