我是初学者,请高手指教:我写的操作SQL server的了bean编译出错,我该怎么办?
bean内容如下:
/**************************************************************/
package SQLserver;
import java.sql.*;
public class sqlserver{
public String sconn;
public String strDatabase;
public String strUID;
public String strPass;
private Connection conn=null;
private Statement stmt=null;
private ResultSet rs=null;
public void sqlserver(){
try
{
sconn="com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(sconn);
strDatabase="9skyca";
strUID="9skyca";
strPass="senty";
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("Create SQLServer Object Error:"+e.getMessage());
}
}
public void sqlserver(String m_Database,String m_UID,String m_Pass){
try
{
sconn="com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(sconn);
strDatabase=m_Database;
strUID=m_UID;
strPass=m_Pass;
conntent();
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("Create SQLServer Object Error:"+e.getMessage());
}
}
public void conntent()
{
try
{
String sconnstr="jdbc.microsoft.sqlserver://localhost:1433;Database=" + strDatabase;
conn=DriverManager.getConnection(sconnstr,strUID,strPass);
stmt=conn.CreateStatement();
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("Content to SQLServer Error:"+e.getMessage());
}
}
public Resultset executequery(String sql)
{
rs=null;
try
{
rs=stmt.executeQuery(sql);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("executequery():"+e.getMessage());
}
return rs;
}
public void executeupdate(String sql)
{
try
{
stmt.executeUpdate(sql);
}
catch(SQLException e)
{
System.err.println("executeupdate Error:"+e.getMessage());
}
}
public void close()
{
try
{
stmt.close();
conn.close();
stmt=null;
conn=null;
}
catch(SQLException e)
{
System.err.println("Cannot Close SQLServer Object:"+e.getMessage());
}
}
}
/********************************************************************/
用javac编译时出错:
C:\>javac H:\jsp\sqlserver.java
H:\jsp\sqlserver.java:57: cannot resolve symbol
symbol : class Resultset
location: class SQLserver.sqlserver
public Resultset executequery(String sql)
^
H:\jsp\sqlserver.java:49: cannot resolve symbol
symbol : method CreateStatement ()
location: interface java.sql.Connection
stmt=conn.CreateStatement();
^
2 errors
/*******************************************************************/
我已经搞了两天,可就是不行,请高手帮忙!我的CLASSPATH是这样的:
H:\j2sdk1.4.2_01\lib;C:\Program Files\Apache Software Foundation\Tomcat 5.0\webapps\ROOT\WEB-INF\lib\msbase.jar;C:\Program Files\Apache Software Foundation\Tomcat 5.0\webapps\ROOT\WEB-INF\lib\msutil.jar;C:\Program Files\Apache Software Foundation\Tomcat 5.0\webapps\ROOT\WEB-INF\lib\mssqlserver.jar;.;