//import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import com.mysql.jdbc.Statement;
import com.mysql.jdbc.ResultSet;;
public class DBDemo { /**
 * @param args
 */

public static void main(String[] args) {
// TODO Auto-generated method stub
try
{
Class.forName("org.gjt.mm.mysql.Driver");
}
catch(java.lang.ClassNotFoundException e)
{
System.out.print("Class not found exception occur.Message is:");
System.out.print(e.getMessage());
}
try
{
Statement stmt;
ResultSet rs;
String url="jdbc:mysql://localhost:3306/test";
String user="root";
String passwordOFDB="55191204";
Connection conn=null;
try{
conn=DriverManager.getConnection(url,user,passwordOFDB);
}
catch(Exception ex)
{
ex.printStackTrace();
}
System.out.println(conn.createStatement());
stmt=(Statement)conn.createStatement();
rs=(ResultSet)stmt.executeQuery("select * from userinfo1");
System.out.println(rs); while(rs.next());
{
//System.out.println("test1.....");
int id=rs.getInt(1);
//System.out.println("test2.....");
String name=rs.getString(2);
String password=rs.getString(3);
int age=rs.getInt(4);
String gender=rs.getString(5);
String email=rs.getString(6);

System.out.println("id:"+id);
System.out.println("username:"+name);
System.out.println("password:"+password);
System.out.println("age:"+age);
System.out.println("gender:"+gender);
System.out.println("email:"+email+"\n");
}
rs.close();
stmt.close();
conn.close();
}
catch(SQLException e)
{
System.out.println("SQL Exception occur Message is:");
System.out.println(e.getMessage());
}
}}
怎么总抛出异常〉结果显示是SQL Exception occur Message is:
After end of result set!