java连接mysql抛异常_java连接数据库抛出异常

importjava.sql.*;importcom.inet.tds.*;publicclassJ_Jdbc{publicstaticvoidmain(Stringargv[]){try{PDataSourcedataSource=newPDataSource();dataSource.setServerName("127.0.0.1"...

import java.sql.*;

import com.inet.tds.*;

public class J_Jdbc

{

public static void main(String argv[])

{

try

{

PDataSource dataSource=new PDataSource();

dataSource.setServerName("127.0.0.1");

dataSource.setInstanceName("HCWSDIY");

dataSource.setDatabaseName("tempdb");

dataSource.setUser("sa");

dataSource.setPassword("jie104976");

Connection c=dataSource.getConnection();

Statement s=c.createStatement();

s.executeUpdate(

"create table SchoolJ(Sno integer,Sname char(40))");

s.executeUpdate(

"insert into SchoolJ values(009,'Computer')");

s.close();

c.close();

System.out.println("成功!");

}

catch(Exception e)

{

e.printStackTrace();

}

}

}

om.inet.tds.Tds4SQLException: Instance 'HCWSDIY' on host '127.0.0.1' not found.

at com.inet.tds.aa.a(Unknown Source)

at com.inet.tds.aa.a(Unknown Source)

at com.inet.tds.TdsDriver.a(Unknown Source)

at com.inet.tds.TdsDriver.connect(Unknown Source)

at com.inet.tds.TdsDataSource.getConnection(Unknown Source)

at com.inet.tds.PDataSource.getPooledConnection(Unknown Source)

at com.inet.pool.m.a(Unknown Source)

at com.inet.pool.PoolManager.a(Unknown Source)

at com.inet.pool.PoolManager.getConnection(Unknown Source)

at com.inet.tds.PDataSource.getConnection(Unknown Source)

at J_Jdbc.main(J_Jdbc.java:17)

应如何解决,谢谢

数据库中的目录结构为:

展开