public class DBNameTest {
/**
* 验证登陆的用户名密码
* @param args
* @return
* @throws ClassNotFoundException
* @throws SQLException
*/
public static void main(String[] args) throws ClassNotFoundException, SQLException{
//定义数据库驱动器
String DRIVER = "com.mysql.jdbc.Driver";
//加载数据库驱动器
Class.forName(DRIVER);
//定义数据库的链接
String URL = "jdbc:mysql://192.168.1.18:3306/cuihao?useUnicode=true&characterEncoding=UTF-8";
String Users = "root";
String Passw = "root";
Connection con = null;
try {
con = DriverManager.getConnection(URL, Users, Passw);
con.setAutoCommit(false);
} catch (SQLException e) {
e.printStackTrace();
}
//PrepareStatement执行动态的SQL语句,并返回他所生成结果的对象
Statement st = null;
//ResultSet数据库结果集的数据表
ResultSet rs = null;
//输入
Scanner scanner = new Scanner(System.in);
//构造ArrayList用来存储从数据库中取出的数据
ArrayList<NameTest> list = new ArrayList<NameTest>();
try {
System.out.println("请以“用户名:密码”格式输入:");
String upString = scanner.next();
//分割
**StringTokenizer stoString = new StringTokenizer(upString, ":");
String uString = stoString.nextToken();
String pString = stoString.nextToken();**
//判断输入是否为空
if((null != uString)&&(null != pString)){
//查询
String selectString = "select * from logins";
st = con.createStatement();
rs = st.executeQuery(selectString);
while(rs.next()){
String name = rs.getString("username");
String pass = rs.getString("passwords");
NameTest nt = new NameTest(name, pass);
list.add(nt);
}
for(Iterator<NameTest> iterator = list.iterator(); iterator.hasNext();){
NameTest n = iterator.next();
if(uString.equals(n.getUsernameString())){
System.out.println("用户名正确!");
}else {
System.out.println("用户名错误!");
}
if(pString.equals(n.getPasswordString())){
System.out.println("密码正确!");
}else {
System.out.println("密码错误!");
}
}
}else {
System.out.println("用户名或密码不能为空!");
}
} catch (SQLException e) {
con.rollback();
e.printStackTrace();
}
//关闭
con.commit();
rs.close();
st.close();
con.close();
}
}
数据库中用户名密码为 :"hao""123",当输入“hao:”时程序抛异常。
Exception in thread "main" java.util.NoSuchElementException
at java.util.StringTokenizer.nextToken(StringTokenizer.java:349)
at com.ch.test15.DBNameTest.main(DBNameTest.java:53)
我该怎样处理才能避免此异常,求解答!