67,535
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
Dave 2008-07-21
- 打赏
- 举报
<%
String name = request.getParameter("username");
name = db.ex_chinese(name);
String password = request.getParameter("psw");
password = db.ex_chinese(password);
ResultSet rs = null;
try {
String sql1 = "select name from usr";
rs = db.executeQuery(sql1);
while (rs.next()) {
if (rs.getString("name").equals(name)) {
%>
<script language="javascript">
alert("该用户名已经存在，请重新输入！");
self.location.href="add_user.jsp";
</script>
<%
}
}
password = db1.md5crypt(password);
String sql = "insert into usr values('" + name
+ "','" + password + "')";
%>
可以参考一下
String name = request.getParameter("username");
name = db.ex_chinese(name);
String password = request.getParameter("psw");
password = db.ex_chinese(password);
ResultSet rs = null;
try {
String sql1 = "select name from usr";
rs = db.executeQuery(sql1);
while (rs.next()) {
if (rs.getString("name").equals(name)) {
%>
<script language="javascript">
alert("该用户名已经存在，请重新输入！");
self.location.href="add_user.jsp";
</script>
<%
}
}
password = db1.md5crypt(password);
String sql = "insert into usr values('" + name
+ "','" + password + "')";
%>
可以参考一下
reality 2008-07-21
- 打赏
- 举报
按字符串处理
天外流星 2008-07-21
- 打赏
- 举报
resultSet.getString("name")
youjianbo_han_87 2008-07-21
- 打赏
- 举报
直接String接收即可
wz436392521 2008-07-21
- 打赏
- 举报
就是字符串啊 String 类型啊，没什么问题，直接使用String就行了！
sunickzuo 2008-07-21
- 打赏
- 举报
Connection conn=new DataSource().getConnection();
PreparedStatement ps= conn.prepareStatement("select * from table");
ResultSet rs=ps.executeQuery();
while(rs.next())
{
String something=rs.getString("tableColumn"); //tableColumn：代表你需要查的表中的varchar字段列
}
//use something
PreparedStatement ps= conn.prepareStatement("select * from table");
ResultSet rs=ps.executeQuery();
while(rs.next())
{
String something=rs.getString("tableColumn"); //tableColumn：代表你需要查的表中的varchar字段列
}
//use something
