import java.awt.*;
import java.awt.event.*;
import java.util.*;
import java.sql.*;
public class testdb {Connection con;Statement sql;ResultSet rs;
testdb(String s)
{
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){}
try
{con=DriverManager.getConnection("jdbc:odbc:user");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM userid where userid='"+s+"'");
while(rs.next())//如有此用户先不处理
{
}
//没有就把此用户名加入到userid表
rs=sql.executeUpdate("INSERT INTO userid VALUES ('"+s+"')");
//修改后,就剩这句有毛病了
con.close();
}
catch(SQLException e1){}
}
}
错误提示为:
D:\testdb.java:23: incompatible types
found : int
required: java.sql.ResultSet
rs=sql.executeUpdate("INSERT INTO userid VALUES ('"+s+"')");
^
1 error高手哪去了,帮帮忙好不好,调了一天,烦死了!
import java.awt.event.*;
import java.util.*;
import java.sql.*;
public class testdb {Connection con;Statement sql;ResultSet rs;
testdb(String s)
{
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){}
try
{con=DriverManager.getConnection("jdbc:odbc:user");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM userid where userid='"+s+"'");
while(rs.next())//如有此用户先不处理
{
}
//没有就把此用户名加入到userid表
rs=sql.executeUpdate("INSERT INTO userid VALUES ('"+s+"')");
//修改后,就剩这句有毛病了
con.close();
}
catch(SQLException e1){}
}
}
错误提示为:
D:\testdb.java:23: incompatible types
found : int
required: java.sql.ResultSet
rs=sql.executeUpdate("INSERT INTO userid VALUES ('"+s+"')");
^
1 error高手哪去了,帮帮忙好不好,调了一天,烦死了!
===
返回操作成功的记录数,不是返回结果集