我用的是jtds连接的数据库,在本地好使,但是放到数据库上咋就不好使了呢?
下面的是我在本地的连接字符串.
"jdbc:jtds:sqlserver://127.0.0.1:1433/airin_b2b;user=sa;password=tytymnty110110"传到服务器上以后我也改数据库连接了,但是还是不好使, 换用jdbc-odbc桥就没问题.
谁能给解决一下???? 多谢了!!!
下面的是我在本地的连接字符串.
"jdbc:jtds:sqlserver://127.0.0.1:1433/airin_b2b;user=sa;password=tytymnty110110"传到服务器上以后我也改数据库连接了,但是还是不好使, 换用jdbc-odbc桥就没问题.
谁能给解决一下???? 多谢了!!!
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.NullPointerException
org.apache.jsp.xinhuoshangjia_jsp._jspService(xinhuoshangjia_jsp.java:72)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
空指针异常
org.apache.jsp.xinhuoshangjia_jsp._jspService(xinhuoshangjia_jsp.java:72)
72行有什么没有完全加载
import java.sql.*;
public class SqlServerBean
{
String url="jdbc:microsoft:sqlserver://192.168.90.52:1433;DatabaseName=NewMoldDB";(你只需要更改這個參數 把127.0.0.1:1433 變更成你服務器的ip地址就行了。數據庫和驗證你也要改一下)
Connection conn;
Statement stmt;
ResultSet rs;
public SqlServerBean()
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch (Exception ex)
{
ex.printStackTrace();
}
}
public ResultSet query(String sql)
{
try
{
conn=DriverManager.getConnection(url,"sa","wkl");
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch (Exception ex)
{
ex.printStackTrace();
}
return rs;
}
public void update(String sql)
{
try
{
conn=DriverManager.getConnection(url,"sa","wkl");
stmt=conn.createStatement();
stmt.executeUpdate(sql);
}
catch (Exception ex)
{
ex.printStackTrace();
}
}
}
樓主你參考一下我的javabean
import java.sql.*;
import java.io.*;
import java.util.*;
public class conn //定义类名
{
java.sql.Connection con;
Statement st;
ResultSet rs;
public conn()
{
try{ //容错
Class.forName("net.sourceforge.jtds.jdbc.Driver");
DriverManager.registerDriver(new net.sourceforge.jtds.jdbc.Driver());
con = java.sql.DriverManager.getConnection("jdbc:jtds:sqlserver://127.0.0.1:1433/airin_b2b;user=sa;password=tytymnty110110");
st = con.createStatement();
}
catch(Exception e){}
}
/**查询记录的方法*/
public ResultSet Query(String biao,String table,String tiaojian)
{
try{//必要的容错
String select = "select "+biao+" from "+table+" where 1=1"+tiaojian;
rs = st.executeQuery(select);//查询结果的显示
}
catch(Exception e)
{
System.out.print(e.toString());//容错语句
}
return rs;
}
然後在jsp中調用
有可能是端口的問題﹗﹗
org.apache.jasper.JasperException
这个错误是什么意思啊?
今天写的时候也遇到了这样的问题