mysql登录跳转不了_在myeclipse中连接MySQL数据库没有连接错误，但是登入时总是跳转登陆失败的页面，无法访问数据库表？...

跪求`这是loginDB的内容publicstaticStringteacherLogin(Stringuid,Stringpwd){Stringurl="jdbc:mysql://localhost:3306/test";Stringusername="root";Stringpassword="1111";Stringr...

跪求`

这是loginDB的内容

public static String teacherLogin(String uid,String pwd){

String url = "jdbc:mysql://localhost:3306/test";

String username = "root";

String password = "1111";

String result="fail";

Connection conn=null;Statement stmt=null;

String sql=null;ResultSet rs=null;

try{

conn=getConnection();

if(conn!=null){

sql="select col_no from teacheruser where uid='"+uid+"'"+

" and pwd='"+pwd+"'";

stmt=conn.createStatement();

rs=stmt.executeQuery(sql);

if(rs.next()){result=rs.getString(1);}

}}

catch(SQLException e){e.printStackTrace();}

finally{

try{

if(rs!=null){rs.close();rs=null;}

if(stmt!=null){stmt.close();stmt=null;}

if(conn!=null){conn.close();conn=null;}

}

catch(SQLException e){e.printStackTrace();}

}

return result;

}

public static Connection getConnection(){

Connection conn=null;

try{

Context initial=new InitialContext();

DataSource ds=(DataSource)initial.lookup("java:comp/env/xsglxt");

conn=ds.getConnection();

}

catch(NamingException e){e.printStackTrace();}

catch(SQLException e){e.printStackTrace();}

return conn;

}}

展开