有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

从Android插入数据库的java不同图像显示相同的值?

我正在尝试将图像插入SQL Server,这是我的代码,它工作得很好(它将图像插入数据库)。我的问题始于插入之后,以及在数据库中看到图像列时

protected String doInBackground(String... strings) {
    try {
        con = connectionClass(ConnectionClass.un, ConnectionClass.pass, ConnectionClass.db, ConnectionClass.ip);
        if (con == null) {
            z = "No Internet Connection";
        } else {

            String sql = "INSERT INTO [dbo].[tblComplaint] (customerName,type,image) VALUES ('" + name.getText() + "','" + complain.getText() + "','" +encodedImage+"')";
            //PreparedStatement stmt = con.prepareStatement(sql);
            //stmt.executeUpdate();
            Statement stmt = con.createStatement();
            stmt.executeUpdate(sql);
        }
    } catch (Exception e) {
        isSuccess = false;
        z = e.getMessage();
    }

    return z;
}

@SuppressLint("NewApi")
public Connection connectionClass(String user, String password, String database, String server) {
    StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
    StrictMode.setThreadPolicy(policy);
    Connection connection = null;
    String connectionURL = null;
    try {
        Class.forName("net.sourceforge.jtds.jdbc.Driver");
        connectionURL = "jdbc:jtds:sqlserver://" + server + "/" + database + ";user=" + user + ";password=" + password + ";";
        connection = DriverManager.getConnection(connectionURL);
    } catch (Exception e) {
        Log.e("SQL Connection Error : ", e.getMessage());
    }

    return connection;
}

问题:无论我将什么图像发送到数据库中,它都只插入相同的字符串集,以:0x2F396A2F34414151536B5A4A5267414241514141415141424141442F3467496F53554E44583142开头,然后继续插入100行,我猜这是不对的。我已经尝试发送4-5个不同的图像,但这并没有改变。我做错了什么?image列的数据类型是image,我也尝试过varbinary(max)等等


共 (0) 个答案