import java.sql.*;
import java.util.Hashtable;import com.mysql.jdbc.ResultSet;public class conndb {
String url="jdbc:mysql://localhost:3306/test";
String name="root";
String pss="111";
Connection con;
Statement sta;
ResultSet rs;
try{Class.forName("org.gjt.mm.mysql.Driver");
con=DriverManager.getConnection(url,name,pss);
}catch(SQLException e)
{
e.getErrorCode();
}
public Hashtable getUsersByUserName(String userName)
{
String name=userName;
Hashtable userHashTable=new Hashtable();
String sqlstring=null;
if(userName==null||name.length()==0)
sqlstring="select * from usertable";
else
sqlstring="select * from usertable like'%"+name+"%'";
}
}
}程序没写完就出现问题,有两个,一个在ResultSet rs;提示分号(Syntax error on token ";", { expected after this token);另一个在public Hashtable getUsersByUserName(String userName)提示括号,(Syntax error on token ")", ; expected)
高人们帮忙看看,谢谢了
import java.sql.*;
import java.util.Hashtable;
import com.mysql.jdbc.ResultSet; public class conndb {
String url="jdbc:mysql://localhost:3306/test";
String name="root";
String pss="111";
Connection con;
Statement sta;
ResultSet rs;
public conndb(){
try{
Class.forName("org.gjt.mm.mysql.Driver");
con=DriverManager.getConnection(url,name,pss);
}catch(SQLException e)
{
e.getErrorCode();
}
}
public Hashtable getUsersByUserName(String userName)
{
String name=userName;
Hashtable userHashTable=new Hashtable();
String sqlstring=null;
if(userName==null||name.length()==0)
sqlstring="select * from usertable";
else
sqlstring="select * from usertable like'%"+name+"%'";
}
}
能否告告诉我为什么要加上个public conndb()就行了
期待中******
import java.util.Hashtable; import com.mysql.jdbc.ResultSet; public class conndb {
String url="jdbc:mysql://localhost:3306/test";
String name="root";
String pss="111"; Connection con;
Statement sta;
ResultSet rs;
public conndb ()
{
try{Class.forName("org.gjt.mm.mysql.Driver");
con=DriverManager.getConnection(url,name,pss);
}catch(SQLException e)
{
e.getErrorCode();
}
}
public Hashtable getUsersByUserName(String userName)
{ String name=userName;
Hashtable userHashTable=new Hashtable();
String sqlstring=null;
if( userName == null || name.length() == 0)
sqlstring="select * from usertable";
else
sqlstring="select * from usertable like'%"+name+"%'";
} }你的代码太多不合法的字符编码
問這個問題說名你要好好的去看下基礎了
那個是方法呀
你只有類
沒有方法,怎么調用程序