package jspstudy.test;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.sql.*;
import java.util.*;
public class JDBCTest
{
private java.sql.Connection con;
public JDBCTest() throws ClassNotFoundException {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=lxw"; String user="sa"; String password="sa";
try
{
con = java.sql.DriverManager.getConnection(url, user, password);
}
catch (SQLException ex)
{
ex.printStackTrace();
} } public void addMessage() throws Exception
{
java.sql.PreparedStatement stm = con.prepareStatement("insert into jdbcTest values(?,?)");
stm.setString(1,"lxw");
stm.setDate(2,new java.sql.Date(new java.util.Date().getTime()));
con.close(); }
public static void main(String arg[]) throws Exception {
try {
JDBCTest jd = new JDBCTest();
jd.addMessage();
}
catch (ClassNotFoundException ex)
{
ex.printStackTrace();
} }
}报错信息如下
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at jspstudy.test.JDBCTest.<init>(JDBCTest.java:24)
at jspstudy.test.JDBCTest.main(JDBCTest.java:45)
java.lang.NullPointerException
at jspstudy.test.JDBCTest.addMessage(JDBCTest.java:37)
at jspstudy.test.JDBCTest.main(JDBCTest.java:46)
Exception in thread "main" 菜鸟请求大家帮忙!
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.sql.*;
import java.util.*;
public class JDBCTest
{
private java.sql.Connection con;
public JDBCTest() throws ClassNotFoundException {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=lxw"; String user="sa"; String password="sa";
try
{
con = java.sql.DriverManager.getConnection(url, user, password);
}
catch (SQLException ex)
{
ex.printStackTrace();
} } public void addMessage() throws Exception
{
java.sql.PreparedStatement stm = con.prepareStatement("insert into jdbcTest values(?,?)");
stm.setString(1,"lxw");
stm.setDate(2,new java.sql.Date(new java.util.Date().getTime()));
con.close(); }
public static void main(String arg[]) throws Exception {
try {
JDBCTest jd = new JDBCTest();
jd.addMessage();
}
catch (ClassNotFoundException ex)
{
ex.printStackTrace();
} }
}报错信息如下
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at jspstudy.test.JDBCTest.<init>(JDBCTest.java:24)
at jspstudy.test.JDBCTest.main(JDBCTest.java:45)
java.lang.NullPointerException
at jspstudy.test.JDBCTest.addMessage(JDBCTest.java:37)
at jspstudy.test.JDBCTest.main(JDBCTest.java:46)
Exception in thread "main" 菜鸟请求大家帮忙!
SP4补丁