JAVA中串連mysql資料庫，javamysql資料庫

JAVA中串連mysql資料庫，javamysql資料庫

上周做了資料庫的課程設計，用的是java語言和mysql資料庫，其中就涉及java串連資料庫的相關知識。

package entity;public class user {    private int id;    private String user;    private String pwd;    private String mark;    public int getId() {        return id;    }    public void setId(int id) {        this.id = id;    }    public String getUser() {        return user;    }    public void setUser(String user) {        this.user = user;    }    public String getPwd() {        return pwd;    }    public void setPwd(String pwd) {        this.pwd = pwd;    }    public String getMark() {        return mark;    }    public void setMark(String mark) {        this.mark = mark;    }}

public int addUser(user u) {        List<user> list = new ArrayList<user>();        Connection ct = null;        PreparedStatement ps = null;        ResultSet rs = null;        int result = 0;        try {            Statement sta = null;            Class.forName("com.mysql.jdbc.Driver");            ct = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/whj","root", "");//串連資料庫            String sql = "insert into user(user,pwd,mark) values('"+u.getUser()+"','"+u.getPwd()+"','"+u.getMark()+"')";//插入新使用者            sta = ct.createStatement();            result = sta.executeUpdate(sql);        } catch (Exception e) {            e.printStackTrace();        }        return result;    }

查詢：

public int getUser(user u) {        List<user> list = new ArrayList<user>();        Connection ct = null;        PreparedStatement ps = null;        ResultSet rs = null;        try {            Statement sta = null;            Class.forName("com.mysql.jdbc.Driver");//載入驅動            ct = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/whj",                    "root", "");//串連資料庫            String sql = "select * from user";//查詢所有的使用者            ps = (PreparedStatement) ct.prepareStatement(sql);            rs = ps.executeQuery();            while (rs.next()) {                user use = new user();                use.setId(rs.getInt("id"));                use.setUser(rs.getString("user"));                use.setPwd(rs.getString("pwd"));                use.setMark(rs.getString("mark"));                list.add(use);            }            for (int i = 0; i < list.size(); i++) {                user use = list.get(i);                if (use.getUser().equals(u.getUser())//進行驗證判斷                        && use.getPwd().equals(u.getPwd())) {                    return 0;                }                if (i == list.size() - 1) {                    return -1;                }            }            ct.close();        } catch (Exception e) {            e.printStackTrace();        }        return -1;    }

然後這就是java中的串連資料庫的一些基本操作。