privateConnectioncon;publicConnectiongetConnection(){Stringurl="jdbc:mysql://localhost:3306/mydatabase";StringuserName="root";StringpassWord="";try{Class.forName("com.mys...
private Connection con;
public Connection getConnection()
{
String url="jdbc:mysql://localhost:3306/mydatabase";
String userName="root";
String passWord="";
try
{
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection(url,userName,passWord);
System.out.println("connect is ok");
}
catch (SQLException e)
{
System.out.print("can't connect database");
}
catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return con;
}
public List findAllModel()
{
List list=new ArrayList();
getConnection();
PreparedStatement pstmt=null;
ResultSet rs=null;
if(con!=null)
{
try
{
pstmt=con.prepareStatement("select * from selectmodel");
rs=pstmt.executeQuery();
System.out.println(rs.findColumn("modelname"));
System.out.println(rs.getRow());
SelectModel mb;
while(rs.next());
{
mb=new SelectModel();
mb.setModelId(rs.getInt(1));
mb.setModelName(rs.getString(2));
list.add(mb);
System.out.println(mb.getModelId());
}
}
catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally
{
closeAll(con,pstmt,rs);
}
}
return list;
}
private void closeAll(Connection con,PreparedStatement pstmt,ResultSet rs)
{
try {
if(con!=null)
{
con.close();
}
if(pstmt!=null)
{
pstmt.close();
}
if(rs!=null)
{
rs.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
运行结果~~
connect is ok
2
0
java.sql.SQLException: After end of result set
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:693)
at com.mysql.jdbc.ResultSet.getNativeInt(ResultSet.java:3688)
at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2386)
at com.ge.dao.SelectModelDao.findAllModel(SelectModelDao.java:59)
at com.ge.dao.SelectModelDao.main(SelectModelDao.java:103)
展开