input.java

来自「JAVA写的一个机器人程序」· Java 代码 · 共 54 行

package rebot;

import java.sql.*;

public class input {
    public static boolean hello = false;

    public static boolean a;
    public static void input(String name, String select, String image,boolean lan) {
        try {
            String dburl =
                    "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=data/user.mdb"; //此为NO-DSN方式
            Connection conn = DriverManager.getConnection(dburl);
            PreparedStatement ps = conn.prepareStatement(
                    "select username from userdb where username=?");
            ps.setString(1, name);
            ResultSet rs = ps.executeQuery();
            if (rs.next()) {
                try {
                    PreparedStatement pss = conn.prepareStatement(
                            "update userdb set selected=?,num=?,image=?,language=? where username=?");
                    pss.setString(1, select);
                    pss.setString(2, Application.fulltime);
                    pss.setString(3, name);
                    pss.setString(4, image);
                    pss.setBoolean(5,lan);
                    pss.executeUpdate();
                } catch (SQLException ce) {
                    ce.printStackTrace();
                }

            } else {
                try {
                    PreparedStatement pss = conn.prepareStatement(
                            "insert into userdb(username,selected,num,image,language)values(?,?,?,?,?)");
                    pss.setString(1, name);
                    pss.setString(2, select);
                    pss.setString(3, Application.fulltime);
                    pss.setString(4, image);
                    pss.setBoolean(5,lan);
                    pss.executeUpdate();
                } catch (SQLException ce) {
                    ce.printStackTrace();
                }

            }

        } catch (SQLException ce) {
            ce.printStackTrace();
        }

    }
}