我在bean里写了一段访问数据库的程序如下:
import java.io.*;
import java.beans.*;
import java.util.*;
import java.sql.*;public class insertuserinfo {Connection conn;
Statement stmt;
ResultSet rs;public int searchinfo()
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=erip";
String user="dataprovider";
String password="123456";
conn=DriverManager.getConnection(url,user,password);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
sql="select loginname from sys_userinfo where loginname='" + this.loginname +"'";
rs=stmt.executeQuery(sql);
int recordcount=0;
recordcount=rs.getRow();
if(recordcount==0)
return 0;
else
return 1;
}错误提示出在Statement stmt 以及后面和stmt有关的所有语句.
错误内容是:The type Statement is ambiguous
请问这是怎么回事.直接在jsp页面写就没有问题!
谢谢!
import java.io.*;
import java.beans.*;
import java.util.*;
import java.sql.*;public class insertuserinfo {Connection conn;
Statement stmt;
ResultSet rs;public int searchinfo()
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=erip";
String user="dataprovider";
String password="123456";
conn=DriverManager.getConnection(url,user,password);
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
sql="select loginname from sys_userinfo where loginname='" + this.loginname +"'";
rs=stmt.executeQuery(sql);
int recordcount=0;
recordcount=rs.getRow();
if(recordcount==0)
return 0;
else
return 1;
}错误提示出在Statement stmt 以及后面和stmt有关的所有语句.
错误内容是:The type Statement is ambiguous
请问这是怎么回事.直接在jsp页面写就没有问题!
谢谢!
or
import java.sql.Statement;两个包里面都又Statement这个类,系统当然就不知道你到底是需要哪一个了。
try{ }
catch{ }
2.引包有问题!java.beans.Statement != java.sql.Statement