mysql查询某用户名是否存在_如何判断用户名是否在数据库中已经存在呢JSP

String ID = request.getParameter("ID");

String password = request.getParameter("password");

String rpassword = request.getParameter("rpassword");

String name = request.getParameter("name");

String sex = request.getParameter("sex");

String year = request.getParameter("year");

if(year.length() ==1) year = "0"+year;

String mouth = request.getParameter("mouth");

if(mouth.length() == 1) mouth = "0"+mouth;

String day = request.getParameter("day");

if(day.length() == 1) day = "0"+day;

String date = year+"-"+mouth+"-"+day;

String description = request.getParameter("description");

Connection con = null;

PrepareStatement psm = null;

ResultSet rs = null;

try

{

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

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

con = DriverManager.getConnection(url,"root","000000");

psm = con.prepareStatement("insert into users values(?,?,?,?,?,?)");

psm.setString(1,ID);

psm.setString(2,password);

psm.setString(3,name);

psm.setString(4,sex);

psm.setLong(5,getDate(date));

psm.setString(6,description);

psm.executeUpdate();

session.setAttribute("user",ID);

response.sendRedirect("index.jsp");

}

catch(Exception e){

response.sendRedirect("register.jsp");

}

finally

{

if(rs!=null){

try{ rs.close();}catch(Exception e){e.printStackTrace();}

}

if(psm!=null){

try{ psm.close();}catch(Exception e){e.printStackTrace();}

}

if(con!=null){

try{ con.close();}catch(Exception e){e.printStackTrace();}

}

}

%>

我想在插入操作之前先判断要插入记录的用户名是否在数据库中已经存在了,怎么写呢,我是新手,还请高手多帮忙啊~

展开