您的位置：程序门 -> java -> j2se / 基础类

帮忙看个简单代码

[收藏此页] [打印本页]选择字色：背景色：字体：[大][中][小]

帮忙看个简单代码

发表于：2007-03-21 15:37:13 楼主

package getlogin;

import java.io.*;
import java.sql.*;
import java.util.*;

public class gologin
{
public string gotologin（string id,string pass)
{
class.forname（ "com.microsoft.jdbc.sqlserver.sqlserverdriver ").newinstance（);
string url= "jdbc:microsoft:sqlserver://10.4.234.87:1433;databasename=dcmsmod ";
string user= "sa ";
string password= "518518 ";
connection conn= drivermanager.getconnection（url,user,password);
statement stmt=conn.createstatement（resultset.type_scroll_sensitive,resultset.concur_updatable);
string sql = " select * from dcmsmod..dscma where ma001= ' " + id + " ' " + " and ma003= ' " + pass + " ' ";
resultset rs=stmt.ＥＸＥＣutequery（sql);

rs.first（);
if （rs.getstring（ "ma001 ") == " ")
return "login_ok ";
else
return "login_error ";

}

}

可报错呀，麻烦大家看看！

发表于：2007-03-21 15:52:121楼得分:0

把错误帖出来啊，而且你那个rs没有循环，光在头上了

发表于：2007-03-21 15:58:382楼得分:0

动态加载类，获取数据库连接等操作很容易发生异常，系统规定必须要为这些操作捕捉异常：

修改后的代码如下：

import java.io.*;
import java.sql.*;
import java.util.*;

public class gotologin
{
public string gotologin（string id, string pass)
{
try
{
class.forname（ "com.microsoft.jdbc.sqlserver.sqlserverdriver ").
newinstance（);
string url =
"jdbc:microsoft:sqlserver://10.4.234.87:1433;databasename=dcmsmod ";
string user = "sa ";
string password = "518518 ";
connection conn = drivermanager.getconnection（url, user, password);
statement stmt = conn.createstatement（resultset.
type_scroll_sensitive,
resultset.concur_updatable);
string sql = " select * from dcmsmod..dscma where ma001= ' " + id +
" ' " + " and ma003= ' " + pass + " ' ";
resultset rs = stmt.ＥＸＥＣutequery（sql);

rs.first（);
if （rs.getstring（ "ma001 ") == " ")
{
return "login_ok ";
}
else
{
return "login_error ";
}
}
catch （exception e)
{return null;}
}
}

我现在没分了，快给分吧！

其他资讯