/***********************************************
/*testdb.java
/******************************************* */
import java.sql.*;
public
class testdb
{
Connection con;
Statement sta;
ResultSet rs;
String driver;
String URL;
String user;
String pwd;
public testdb()
{
driver = "sun.jdbc.odbc.JdbcOdbcDriver";
URL ="jdbc:odbc:ticket";
user = "share";
pwd ="";
init();
}
public void init()
{
try{
Class.forName(driver);
System.out.println("driver is ok");
con =DriverManager.getConnection(URL,user,pwd);
System.out.println("conection is ok");
sta =con.createStatement();
String ls_1="INSERT INTO testdb (testnum) values('11')";
sta.execute(ls_1);
rs = sta.executeQuery("select *from testdb");
while(rs.next())
System.out.println(rs.getString("testnum"));
}
catch(Exception e)
{
e.printStackTrace();
}
}
public static void main(String []args)
{
new testdb();
}
}
driver is ok
conection is ok
//testdb中的数据
连接没有问题.
下面打开以下程序 (操作数据库的部分)
<%
String url="jdbc:microsoft:sqlserver://locahost:1433;DataBaseName=ticket";
String ls_1="INSERT INTO Reg_Book (姓名,电话,手机,发车日期,车次,数量,发站,到站,席别,票种,有效证件,证件类别,取票地点)"+
"VALUES('"+name+"','"+telephone+"','"+mobile+"','"+dt+"','"+sequence+"','"+count+"','"+start+"','"+end+"','"+s_kind+"','"+t_kind+"','"+idcard+"','"+id_kind+"','"+get_address+"')";
%>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
stmt.executeUpdate(ls_1);//将订票信息存入数据库
%>
我认为也没有错误,但是运行后老是提示[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket
sp3补丁,JDBC驱动也升级了,还是不行.
后将URL改为:URL ="jdbc:odbc:ticket"; 后问题解决,但是服务器Tomcat上出现莫名其妙的警告提示.不知道原因
请高手指点.