try
{
String insertSQL = "insert into test (name,age,qq,mail,tele,addr) values (addName,addAge,addOicq,addEmail,addTel,addAddr)";
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
//晕就一个字!openConnection();
theStatement.executeUpdate(insertSQL);
// 用 execute 准确一些
execSQLCommand("Select * from test");
theConnection.close();
}
catch (Exception g)
{
handleException(g);
}
{
String insertSQL = "insert into test (name,age,qq,mail,tele,addr) values (addName,addAge,addOicq,addEmail,addTel,addAddr)";
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
//晕就一个字!openConnection();
theStatement.executeUpdate(insertSQL);
// 用 execute 准确一些
execSQLCommand("Select * from test");
theConnection.close();
}
catch (Exception g)
{
handleException(g);
}
解决方案 »
- 关于read方法的一点小问题。。。求大虾!
- 急求用户注册判断是否有重名用户的代码,我的不能做判断,只会添加,根本不会判断!!!
- 请问:编写一个登陆注册的功能,怎样把用户的登录名或注册名保存在一个XML文件中,也就是在XML中存入数据
- 关于synchronized的4个判断,望指教
- java的向下转型是怎么回事,请教一下
- 如何在java中直接解析文本文件中的文字?
- static {}块里如果有try-catch,有什么特别的地方吗?我好象在哪里看过,但记不清楚了!谢谢!
- 关于WSAD建立CMP的findBy...方法后在建立查询描述语句时的问题!急!!!
- 帮我把这两段代码整合到一起好吗?
- 简单的改错
- 超级新手问题:JAVA怎么用?我一点头绪也没有
- 【烦躁】!!!
(addName,addAge,addOicq,addEmail,addTel,addAddr)";
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
//晕就一个字! SQL 不认识这些变量的
String insertSQL = "insert into test (name,age,qq,mail,tele,addr) values ("+addName+","+addAge+","+addOicq+","+addEmail+","+addTel+","+addAddr+")";
String insertSQL = "insert into test (name,age,qq,mail,tele,addr) values ('"+addName+"',"+addAge+",'"+addOicq+"','"+addEmail+"','"+addTel+"','"+addAddr+"')";
你最好用
String insertSQL = "insert into test (name,age,qq,mail,tele,addr) values (?,?,?,?,?,?)";
java.sql.PrepareStatement pStmt=theConnection.createStatement(insertSQL );
pStmt.setString(1, addName);
pStmt.setInt(2, addAge);
pStmt.setString(3, addOicq);
pStmt.setString(4, addEmail);
pStmt.setString(5, addTel);
pStmt.setString(6, addAddr);
pStmt.execute();