JDBC访问SQLServer出现:java.lang.NullPointerException问题???
我是一个菜鸟,刚写了一个用JDBC访问SQLServer的小程序,出现如下错误:
CreatCnSuc!
java.lang.NullPointerException
at JDBCOBJ.JDBCOBJ.RsQuery(JDBCOBJ.java:50)
at JDBCOBJ.TestDB.main(TestDB.java:24)
QueryErr!
java.lang.NullPointerException
at JDBCOBJ.TestDB.main(TestDB.java:25)
我的源代码:
package JDBCOBJ;
import java.sql.*;
public class TestDB {
public static void main(String args[])
{
String sqlStr = "select * From M_Oper";
ResultSet mRs;
boolean rtn = false;
String ServerNa = "w";
String DBNa = "HospitalDB";
String UserNa = "sa";
String PWD = "";
JDBCOBJ jdbc = new JDBCOBJ();
if(jdbc.CreatCN(ServerNa,DBNa,UserNa,PWD)==false)
{
System.out.println("CreatCnErr!");
}
else
{
System.out.println("CreatCnSuc!");
try
{
mRs = jdbc.RsQuery(sqlStr);
while(mRs.next())
{
System.out.print(mRs.getString("OperID") + " ");
System.out.print(mRs.getString("OperNa") + " ");
System.out.println(mRs.getString("OperCNa"));
}
}
catch(Exception err)
{
err.printStackTrace(System.out);
}
}
}
}
这是调用它的代码:
package JDBCOBJ;
import java.sql.*;
public class TestDB {
public static void main(String args[])
{
String sqlStr = "select * From M_Oper";
ResultSet mRs;
boolean rtn = false;
String ServerNa = "w";
String DBNa = "HospitalDB";
String UserNa = "sa";
String PWD = "";
JDBCOBJ jdbc = new JDBCOBJ();
if(jdbc.CreatCN(ServerNa,DBNa,UserNa,PWD)==false)
{
System.out.println("CreatCnErr!");
}
else
{
System.out.println("CreatCnSuc!");
try
{
mRs = jdbc.RsQuery(sqlStr);
while(mRs.next())
{
System.out.print(mRs.getString("OperID") + " ");
System.out.print(mRs.getString("OperNa") + " ");
System.out.println(mRs.getString("OperCNa"));
}
}
catch(Exception err)
{
err.printStackTrace(System.out);
}
}
}
}
请教各位高手,请帮我看一下是什么地方出问题了??谢谢了先!
还有,能不能帮我把这个类优化一下?由于我是初学Java这个类有好多地方写的有问题,比如RsQuery里,如果出现异常怎么办?还是返回Rs么?那么我怎么判断RsQuery是成功了还是失败了呢??
谢谢!!!