accountdao.java~20~

来自「一个JDBC的程序。帮助入门理解JDBC的原理。。」· JAVA~20~ 代码 · 共 45 行

package com.lx.test;

import java.sql.Connection;
import java.sql.PreparedStatement;

public class AccountDao {
    public boolean inserAccount(String name, Integer age, String sex) {
        boolean flag = false;
        Connection conn = null;
        PreparedStatement ps = null;
        try {
            conn = MyConnection.getConnection();
            ps = conn.prepareStatement("insert into student values(?,?,?)");
            ps.setString(1, name);
            ps.setInt(2, age);
            ps.setString(3, sex);
            if (ps.executeUpdate() == 1) {
                flag = true;
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            try {
                ps.close();
                conn.close();
            } catch (Exception ex) {
                ex.printStackTrace();
            }
        }
        return flag;
    }
    
    public boolean genxin()
    {   
        boolean flag = false;
        Connection conn = null;
        conn = MyConnection.getConnection();
        PreparedStatement ps = null;
        ps = conn.prepareStatement("update from Mydata value id=?");
        
        if(ps.executeUpdate() == 1){
          flag = true;
        }
    }
}