|
当前页面: JAVA 编程资料牛鼻论坛 → J2EE Datebase 数据库开发→怎样用java编程来连接SQL |
怎样用java编程来连接SQL
怎样用java编程来连接SQL
怎样用java编程来连接SQL
怎样用java编程来连接SQL 相关
你是在用VS2005编写软件吗，上面通常只要作几个简单的操作，就会自动生成此类代码的啊
代码片段：可以连接数据库
import java.sql.* ;
//连接数据库类
public class DBCon
{
private Connection connection = null;
private Statement statement = null ;
private ResultSet resultset = null ;
private final String classname= "sun.jdbc.odbc.JdbcOdbcDriver" ;
private final String strCon= "Jdbc:Odbc:cms" ;//CMS改为你自己的数据源名称就可以
public DBCon()throws ClassNotFoundException,SQLException
{
try
{
Class.forName(classname);
connection = DriverManager.getConnection(strCon);
}catch(Exception ex)
{}
}
参考资料:
自己写的一段代码，已测试通过
代码片段：可以连接数据库
import java.sql.* ;
//连接数据库类
public class DBCon
{
private Connection connection = null;
private Statement statement = null ;
private ResultSet resultset = null ;
private final String classname= "sun.jdbc.odbc.JdbcOdbcDriver" ;
private final String strCon= "Jdbc:Odbc:cms" ;//CMS改为你自己的数据源名称就可以
public DBCon()throws ClassNotFoundException,SQLException
{
try
{
Class.forName(classname);
connection = DriverManager.getConnection(strCon);
}catch(Exception ex)
{}
}
import java.sql.* ;
public class DBCon
{
public DBCon()
{
try
{
Class.forName(sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(strCon);
Statement stmt = connection.createStatement();
ResultSet rs=stmt.executeQuery();
}
catch(Exception e)
{
System.out.println("error");
}
}
}