java - 创建一个测试应用程序将名字、姓氏、用户名和密码存储到数据库中得到奇怪的结果

Question

运行应用程序时出现以下错误:

错误:

com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'password' at row 1

我将表从 varchar (50) 更改为 longText，这已修复列中的数据太长。

结果(存储在数据库中):

javax.swing.JPasswordField[,150,137,239x28,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=0.0,alignmentY=0.0,border=javax.swing.plaf.synth.SynthBorder@171f498,flags=288,maximumSize=,minimumSize=,preferredSize=,caretColor=,disabledTextColor=DerivedColor(color=142,143,145 parent=nimbusDisabledText offsets=0.0,0.0,0.0,0 pColor=142,143,145,editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=DerivedColor(color=255,255,255 parent=nimbusSelectedText offsets=0.0,0.0,0.0,0 pColor=255,255,255,selectionColor=DerivedColor(color=57,105,138 parent=nimbusSelectionBackground offsets=0.0,0.0,0.0,0 pColor=57,105,138,columns=0,columnWidth=0,command=,horizontalAlignment=LEADING,echoChar=*]

结果存储在数据库中，而不是密码

Answer 1

已解决:所犯的错误是在我的代码中。我最初把 ps.setString(4, newAccPass.toString());而不是 ps.setString(4, String.valueOf(newAccPass.getPassword()));