import java.sql.*;
public class Insert
{
public static void main(String[] args)
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin@localhost:1521:???????";
Connection con = DriverManager.getConnection(url,"scott","tiger");
Statement st = con.createStatement();
st.execute("insert into basic_info value('000001',1,'zhang',,'1111111')");
}catch(Exception e)
{
e.printStackTrace();
}
}
}
错误提示:java.sql.SQLException: 指定了无效的 Oracle URL我上面URL赋值端口1521号后面的服务名是怎末填写?
服务名是在安装过程设定的吗?ORACLE是我自己按的,不知道哪一步设置的服务名?
还是后天设置的?请教?如何设定?
public class Insert
{
public static void main(String[] args)
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin@localhost:1521:???????";
Connection con = DriverManager.getConnection(url,"scott","tiger");
Statement st = con.createStatement();
st.execute("insert into basic_info value('000001',1,'zhang',,'1111111')");
}catch(Exception e)
{
e.printStackTrace();
}
}
}
错误提示:java.sql.SQLException: 指定了无效的 Oracle URL我上面URL赋值端口1521号后面的服务名是怎末填写?
服务名是在安装过程设定的吗?ORACLE是我自己按的,不知道哪一步设置的服务名?
还是后天设置的?请教?如何设定?
public class Insert
{
public static void main(String[] args)
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:??????";
Connection con = DriverManager.getConnection(url,"scott","tiger");
Statement st = con.createStatement();
st.execute("insert into basic_info values('000001',1,'zhang',,'1111111')");
}catch(Exception e)
{
e.printStackTrace();
}
}
}对不起刚才有两处写错了
问题还是上述的服务名问题~~?!!!
你配置的是?吗
是的,就是?号那个地方不知道怎摸填写,那不是填服务名吗,不知道服务名是如何确定的