我出现一个问题,就是我原来的密码是123456,如果要修改555aaa,方法如下
:
//更改用户的密码
public boolean updatePaw(String name,String pw2){
boolean result = false;
Connection conn = null;
conn = this.getConnection();
String sql ="update mailUser set passWord ="+pw2+" where loginName = '"+name+"'";
try
{
PreparedStatement ps = conn.prepareStatement(sql);
int rs = ps.executeUpdate();
if(rs ==1){
result = true;
}else {
result = false;
}
ps.close();
conn.close();
} catch (SQLException e)
{
e.printStackTrace();
}
return result;
}
public static void main(String[] args)
{
// TODO Auto-generated method stub
ChangeDao chDao = new ChangeDao();
chDao.updatePaw("pengzhongyan", "12345y"); //改成“123fhf”,就会包如下的错误
}进行单元测试出现错误:
java.sql.SQLException: 'y' 附近有语法错误。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
:
//更改用户的密码
public boolean updatePaw(String name,String pw2){
boolean result = false;
Connection conn = null;
conn = this.getConnection();
String sql ="update mailUser set passWord ="+pw2+" where loginName = '"+name+"'";
try
{
PreparedStatement ps = conn.prepareStatement(sql);
int rs = ps.executeUpdate();
if(rs ==1){
result = true;
}else {
result = false;
}
ps.close();
conn.close();
} catch (SQLException e)
{
e.printStackTrace();
}
return result;
}
public static void main(String[] args)
{
// TODO Auto-generated method stub
ChangeDao chDao = new ChangeDao();
chDao.updatePaw("pengzhongyan", "12345y"); //改成“123fhf”,就会包如下的错误
}进行单元测试出现错误:
java.sql.SQLException: 'y' 附近有语法错误。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
解决方案 »
- struts2程序报错ognl-2.7.3jar has no source attachment
- jpa注解时java.lang.NoClassDefFoundError: org/hibernate/MappingNotFoundException
- jsp页面参数如何获取?
- 数据库上的数据怎么样显示到页面上???
- java jpa注解
- 求hibernate映射文件的写法
- 请大家给我介绍一些不错的好用的任务调用框架(用于网银系统)
- Clob对象的存取
- j2ee 安装失败后 怎么也安装不上了,~~~!!!!!!!!!选者目录后 按next 就不行了,不知道什么问题~~
- 急急急,JavaMail问题,请高手帮忙!!!
- 大家帮帮忙..急..appfuse 配置环境时发现的错误..
- 计算机底层知识学习的疑惑?
String sql ="update mailUser set passWord ="+pw2+" where loginName = '"+name+"'";
应修改为:
String sql ="update mailUser set passWord ='"+pw2+"' where loginName = '"+name+"'";