java里读出的字段内容的比较？

if(rs.getString("username")!=null && rs.getString("username").equals("Tom"))
System.out.println("hoho!It's Tom!");

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

老大，java里面比较字符串要用.equals。先去好好看几本java的书吧
if(rs.getString("username")!=null && rs.getString("username").equals("Tom"))
CHAR 字段注意先 trim() 再比较。
create table t_user_money
(
id int not null,
UserName varchar(21) not null,
money float(6,1) not null default 0.0
);谢谢！我是初学者，请多指教。
其实我最想知道的是怎么再读一个表的数据时，根据一些字段内容向呢外一个表如t_user_money写数据,用switch怎么操作，比如
特别是还要插入到t_user_money表，谁能给一个完整的例子妈？
      while (rs.next()) {
        System.out.println("" + rs.getInt("id") + " " + rs.getString("username") + " " + rs.getString("userinfor"));
switch(rs.getString("userinfor"))
{
case "Manager" :"insert into t_user_money values (" + rs.getInt("id") + ",'" + rs.getString("username") + "',1000":break;
case "业务主管" :"insert into t_user_money values (" + rs.getInt("id") + ",'" + rs.getString("username") + "',2000"::break;
case "财务主管" :"insert into t_user_money values (" + rs.getInt("id") + ",'" + rs.getString("username") + "',3000"::break;
default: ;
}
      }
这样规范吗？
import java.sql.*;class  MysqlUser
{
public static void main(String[] args) {
    try {
      //String driver="com.mysql.jdbc.Driver";
  String driver="org.gjt.mm.mysql.Driver";
      String url = "jdbc:mysql://localhost:3306/sunnywest?useUnicode=true&characterEncoding=gbk";
      String user = "root";
      String password = "sunnyday";
      Connection conn = null;
      ResultSet rs = null;
      Statement stmt = null;
      Statement stmt1 = null;
      Class.forName(driver).newInstance();
      conn = DriverManager.getConnection(url, user, password);
      stmt = conn.createStatement();
      stmt1 = conn.createStatement();
      rs = stmt.executeQuery("select * from T_user");
      while (rs.next()) {
        System.out.println("" + rs.getInt("id") + " " + rs.getString("username") + " " + rs.getString("userinfor"));
if (rs.getString("userinfor")!=null && rs.getString("userinfor").equals("Manager"))
{
stmt1.executeUpdate("insert into t_user_money values (" + rs.getInt("id") + ",'" + rs.getString("username") + "','1000')");
System.out.println("update now^^^!");
}
if (rs.getString("userinfor")!=null && rs.getString("userinfor").equals("业务主管"))
{
stmt1.executeUpdate("insert into t_user_money values (" + rs.getInt("id") + ",'" + rs.getString("username") + "','2000')");
System.out.println("update now^^^!");
}
      }
  stmt1.close();
      rs.close();
      conn.close();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }}
1.读数据
<%@ include file="common.jsp" %>
<%@ page import="java.sql.*"%>
<jsp:useBean id="conn" scope="page" class="gkgl.database.LinkSQL"/>
<jsp:useBean id="jsp" scope="page" class="gkgl.include.OutString"></jsp:useBean>
<HTML>
<HEAD>
<title>代码表维护</title>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="/include/css.css" REL="stylesheet" type="text/css">
</HEAD>
<BODY bottommargin=0 leftmargin=0 rightmargin=0 topmargin=0 oncontextmenu="return true;">
<script>function xg(hs,id){
var bgsj=new Array();
var obj=tabdsl;
var temp;
form1.ok.value="修改";
form1.id.value=id;//给隐藏的id表单副值
for (var i=0;i<=4;i++){
temp=obj.rows(hs).cells(i).innerText;
temp=temp.replace('　','');
bgsj[i]=temp;
}
form1.gkfdm.value=bgsj[0];
    form1.gkfmc.value=bgsj[1];
form1.swfdm.value=bgsj[2];
form1.swfmc.value=bgsj[3];
    form1.hsdwdm.value=bgsj[4];
}function bgdelete(id,dm){
if (confirm('真的要删除'+dm+'吗?')) framecssz.location.replace('gkbm_delete.jsp?dm='+dm+'&id='+id);
}function j(nr1,nr2,nr3,nr4,nr5,nr6)
{
var tbIndex=tabdsl.rows.length;
var objRow = tabdsl.insertRow(tbIndex);
objRow.style.background='#ffffff'; var objCel = objRow.insertCell(0);
objCel.style.textAlign='center';
objCel.innerText=nr1;

var objCel = objRow.insertCell(1);
//objCel.style.textAlign='center';
objCel.innerText=nr2;    var objCel = objRow.insertCell(2);
//objCel.style.textAlign='center';
objCel.innerText=nr3;
var objCel = objRow.insertCell(3);
objCel.innerText=nr4 + '　';    var objCel = objRow.insertCell(4);
objCel.innerText=nr5 + '　'; var objCel = objRow.insertCell(5);//修改 nr6=rowid
objCel.style.textAlign='center';
objCel.innerHTML='<p style="cursor: hand"><font color="#0000ff" onclick="xg(' + tbIndex + ',\'' + nr6 + '\');">修改</font></p>';
var objCel = objRow.insertCell(6);//删除  nr6=rowid
objCel.style.textAlign='center';
objCel.innerHTML='<p style="cursor: hand"><font color="#0000ff" onclick="bgdelete(\'' + nr6 + '\',\''+nr1+'\');">删除</font></p>';
}function q(bt)
{
var tbIndex=tabdsl.rows.length-1;
for (var i=tbIndex;i>=bt;i--)
{
tabdsl.deleteRow(i);
}
}function yz(obj){
var ts = new Array();
ts[1]='国库方代码';
    ts[2]='国库方名称';
ts[3]='税务方代码';
ts[4]='税务方名称';
ts[5]='核算单位代码';
//alert(obj.elements.length);
for (var i=1; i<=obj.elements.length-3;i++) {
if (obj.elements[i].value=='') {
alert(ts[i]+'不能为空!');
obj.elements[i].focus();
return false;
}
}     obj.ok.disabled=true;
obj.submit();
}
</script><h3 align="center">国库编码表维护</h3>
<div align="center">
  <center>
<form method="POST" action="gkbm_add.jsp" name="form1"  target="framecssz">
<table border="0" width="80%" cellspacing="0" cellpadding="0">
  <tr>
    <td align="right" nowrap>国库方代码：</td>
    <td>
<input type="hidden" name="id" value="" readonly>
        <p><input type="text" name="gkfdm" size="20" class="input1" ></p>
      </td>
    <td align="right" nowrap>国库方名称：</td>
    <td><input type="text" name="gkfmc" size="30" class="input1" ></td>
  </tr>
  <tr>
    <td align="right" nowrap>税务方代码：</td>
    <td><input type="text" name="swfdm" size="20" class="input1" value=""></td>
    <td align="right" nowrap>税务方名称：</td>
    <td><input type="text" name="swfmc" size="30" class="input1"></td>
  </tr>
    <tr>
    <td align="right" nowrap>核算单位代码：</td>
    <td><input type="text" name="hsdwdm" size="20" class="input1" value=""></td>
    <td align="right" nowrap></td>
    <td></td>
  </tr>
  <tr>
    <td colspan="4">
<BR>
      <p align="center"><input type="button" value="添加" name="ok" onclick="yz(this.form);"> <input type="button" value="重写" name="B2" onclick="window.form1.reset();window.form1.ok.value='添加';"></td>
  </tr>
  </form>
</table><p><b>现有编码清单</b></p>
<table border="1" width="100%" bgcolor="#000000" bordercolorlight="#000000" bordercolordark="#000000"  cellspacing="0" cellpadding="0" id="tabdsl">
  <tr class="tr1">
    <td align="center" rowspan="2">国库方代码</td>
<td align="center" rowspan="2">国库方名称</td>
    <td align="center" rowspan="2">税务方代码</td>
    <td align="center" rowspan="2">税务方名称</td>
    <td align="center" rowspan="2">核算单位代码</td>
    <td align="center" colspan="2">操作</td>
  </tr>
  <tr class="tr1">
<td align="center">修改</td>
    <td align="center">删除</td>
  </tr>
</table>
  </center>
</div>
<iframe name=framecssz width=300 height=300 style="display:none" border=1 frameborder=1 framespacing=1 marginheight=1 marginwidth=1 ></iframe>
<SCRIPT LANGUAGE="JavaScript">

</SCRIPT>
</body>
</html>
2.增加数据
<%@ include file="common.jsp" %>
<%@ page import="java.sql.*"%>
<jsp:useBean id="conn" scope="page" class="gkgl.database.LinkSQL"/>
<jsp:useBean id="jsp" scope="page" class="gkgl.include.OutString"></jsp:useBean>
<html><head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%
String strId = request.getParameter("id");
String strgkfdm = request.getParameter("gkfdm");
String strgkfmc = request.getParameter("gkfmc");
String strswfdm = request.getParameter("swfdm");
String strswfmc = request.getParameter("swfmc");
String strhsdwdm = request.getParameter("hsdwdm");
boolean bolZt=false;
String strSql[]= new String[2];if (strId.length()==0) {
    strSql[0]="insert into dm_gkbm (gkf_dm,gkf_mc,swf_dm,swf_mc,hsdw_dm) values('"+strgkfdm+"','"+jsp.reconvert(strgkfmc)+"','"+strswfdm+"','"+jsp.reconvert(strswfmc)+"','"+strhsdwdm+"')";
    strSql[1]="insert into dm_jg values('"+strgkfdm+"','"+jsp.reconvert(strgkfmc)+"','6','Y')";
}else{
strSql[0]="update dm_gkbm set gkf_dm='" + strgkfdm + "',gkf_mc='" + jsp.reconvert(strgkfmc) + "',swf_dm='" + strswfdm + "',swf_mc='" + jsp.reconvert(strswfmc) + "',hsdw_dm='" + strhsdwdm + "' where rowid='" + strId+"'";
    strSql[1]="update dm_jg set jg_mc='" + jsp.reconvert(strgkfmc) + "' where jg_dm='" + strgkfdm + "'";
}
bolZt=conn.executeQuery(strSql);
conn.close();
if (bolZt) {
%>
<SCRIPT LANGUAGE="JavaScript">

</SCRIPT>
<%
}else{
%>
<SCRIPT LANGUAGE="JavaScript">

</SCRIPT>
<%
}
%>
<SCRIPT LANGUAGE="JavaScript">

</SCRIPT>
</BODY>
</HTML>