jsp查询mysql数据_Jsp mysql 中查询数据

数据库名为user有useridusernameuserpassword一条记录username为chizian输出他的userpassword我自己写的代码有问题输出为找不到数据求修改数据库中有该记录找不到

数据库名为user有 userid username userpassword 一条记录username为chizian 输出他的userpassword 我自己写的代码有问题 输出为 找不到数据 求修改 数据库中有该记录

找不到

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

String user = "root";

String password = "admin";

Connection conn = null;

try{

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection(url,user,password);

} catch (ClassNotFoundException e){

out.println(" 找不到");

} catch (SQLException e) {

out.println("连不上");

}

try{

Statement stmt = conn.createStatement();

String sql = "SELECT*FROM user WHERE username='chizian' ";

ResultSet rs = stmt.executeQuery(sql);

String name =rs.getString("userpassword");

out.print(name);

}

catch (SQLException e){

out.print("找不到数据");

}

%>

展开