从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) 个答案