数据库与JAVA连接的问题 这个软件的功能就是扫描单词,然后存入库中,现在是ACCESS做的数据库,我的电脑不能装SQL 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 SQL查询语言和你的数据库不搭配,列数上出了问题,你认真改一下吧。 你多加了列的话,那么这地方也要改:sqlInsert="INSERT INTO WORDS VALUES("+"\'"+tempr.toLowerCase()+"\')"; 因为库里有多个字段了,而这里只加入一个字段的内容. 这是我得一个数据库连接的代码你照着修改一下吧import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class Test { public Test(){ } public ResultSet executeQuery(final String strSQL) { Connection conn = null; Statement stmt = null; ResultSet rs = null; try { String url="jdbc:oracle:thin:@192.168.1.11:1521:oracle8"; String user="pdm"; String password="pdm"; Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); conn= DriverManager.getConnection(url,user,password); } catch (Exception ex) { ex.printStackTrace(); return null; } try { stmt = conn.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); } catch (SQLException e) { e.printStackTrace(); return null; } try { rs = stmt.executeQuery(strSQL); } catch (SQLException es) { es.printStackTrace(); return null; } return rs; } public static void main(String[] args) { Test db = new Test(); ResultSet st = db.executeQuery("select * from supplier"); String str = null; try { while (st.next()) { System.out.print("<tr><td>" + st.getInt("id") + "</td>"); System.out.print("<td>" + st.getString("name") + "</td></tr>"); //COF_NAME //out.print( "<td>" + lRs.getInt(2)); //SUP_ID //out.print( "<td>" + lRs.getFloat(3)); //PRICE //out.print( "<td>" + lRs.getInt(4)); //SALES //out.println( "<td>" + lRs.getInt(5)); //TOTAL } System.out.println("</table>"); //if (st.next()) { //st.beforeFirst(); //st.next(); //str = st.getString(2); //} } catch (SQLException e) { e.printStackTrace(); } //System.out.println(str); }} sqlInsert="insert into words";这里的语法是什么啊,老说我insert into 语法错误 String sqlInsert="INSERT INTO WORDS(col1,col2,...) VALUES(?,?,...)";//这里....表示可以有多个列。stmt.preparedStatement(sqlInsert);stmt.setInt(1,value1);stmt.setString(2,value2);if(stmt.executeUpdate()>0){ System.out.println("successful");}else { System.out.println("failed");}不提倡直接stmt.executeQuery(sql); sorry!写错了。PreparedStatement pst=con.prepareStatement(sqlInsert);pst.setInt(1,value1);pst.setString(2,value2);if(pst.executeUpdate()>0){}else{}好久没写过这种数据库了,sorry!! pst.setInt(1,value1);,这里的value1 指什么??String sqlInsert="INSERT INTO WORDS(col1,col2,...) VALUES(?,?,...)";//VALUES(?,?,...)又指什么?不好意思,麻烦说明白点 JDBC问题 java中的浮点类型?? 面试题提问了,基础 计算器功能的实现?怎样在循环监听中实现加减乘除... java中如何显示模态对话框和非模态对话框? 请教大虾! 请教 applet的archieve问题 高分求资料。 Java如何访问word文档的属性? ie浏览器,警告:大家帮忙解决一下吧,分数又都是 insert date 型字段 并且为 null,如何解决 请帮我看看这个10行程序里的语法错误 关于数据库操作的,显示错误17行,可我看不出来
sqlInsert="INSERT INTO WORDS VALUES("+"\'"+tempr.toLowerCase()+"\')";
因为库里有多个字段了,而这里只加入一个字段的内容.
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class Test {
public Test(){
}
public ResultSet executeQuery(final String strSQL) { Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
String url="jdbc:oracle:thin:@192.168.1.11:1521:oracle8";
String user="pdm";
String password="pdm"; Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
conn= DriverManager.getConnection(url,user,password);
} catch (Exception ex) {
ex.printStackTrace();
return null;
} try {
stmt =
conn.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
} catch (SQLException e) {
e.printStackTrace();
return null;
}
try {
rs = stmt.executeQuery(strSQL);
} catch (SQLException es) {
es.printStackTrace();
return null;
}
return rs;
}
public static void main(String[] args) {
Test db = new Test();
ResultSet st = db.executeQuery("select * from supplier");
String str = null;
try {
while (st.next()) {
System.out.print("<tr><td>" + st.getInt("id") + "</td>");
System.out.print("<td>" + st.getString("name") + "</td></tr>");
//COF_NAME
//out.print( "<td>" + lRs.getInt(2));
//SUP_ID
//out.print( "<td>" + lRs.getFloat(3));
//PRICE
//out.print( "<td>" + lRs.getInt(4));
//SALES
//out.println( "<td>" + lRs.getInt(5));
//TOTAL
}
System.out.println("</table>");
//if (st.next()) {
//st.beforeFirst();
//st.next();
//str = st.getString(2);
//}
} catch (SQLException e) {
e.printStackTrace();
}
//System.out.println(str);
}
}
stmt.preparedStatement(sqlInsert);
stmt.setInt(1,value1);
stmt.setString(2,value2);
if(stmt.executeUpdate()>0){
System.out.println("successful");
}else {
System.out.println("failed");
}
不提倡直接stmt.executeQuery(sql);
PreparedStatement pst=con.prepareStatement(sqlInsert);
pst.setInt(1,value1);
pst.setString(2,value2);
if(pst.executeUpdate()>0){
}else{
}好久没写过这种数据库了,sorry!!