package leaveword;
import java.sql.*;
public class DSbean
{
private String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName = leaveword";
private String user = "sa";
private String password = "sa";
Connection conn = null;
public DSbean()
{
}
public Connection getConn()
{
try
{
//System.out.println("one");
Class.forName(driver);
conn = DriverManager.getConnection(url, user, password);
//System.out.println("two");
}
catch(Exception ex)
{
ex.printStackTrace();
}
return conn;
}
}
package leaveword;
import java.sql.*;
public class test
{
public test()
{
}
Connection con = new DSbean().getConn();
try //这里报错:Connection con = new DSbean().getConn();
{
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from user_temp");
}
catch(Exception ex)
{
}
public static void main(String[] args)
{
test test = new test();
} //这里报错:<identifier> expected at line 22 (22:6)
}
----------------解决方案--------------------------------------------------------
错误信息给出来啊
再说数据库也都不一样 怎么帮你调试呢
----------------解决方案--------------------------------------------------------
你写的代码简直就是乱七八糟!!
先别说JDBC编程连接数据库的问题了,你先好好的练习下自己编写代码时候的格式(风格)在讨论其他问题吧?
这一句,那一句的,什么东西嘛!!!把要用到的变量统统的先声明好啊(预先先定义好啊)!!
靠,什么东西嘛!!!
----------------解决方案--------------------------------------------------------
LZ的代码强啊!给你改了一下!
public class test
{
public test()
{
}
public void getConn()
{
try
{
Connection con = new DSbean().getConn();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from user_temp");
}
catch(Exception ex)
{
}
}
public static void main(String[] args)
{
test test = new test();
test.getConn();
}
}
----------------解决方案--------------------------------------------------------