纯java应用程序连接数据库的方法:
1:首先要到microsoft里去把驱动程序给下载了,然后解压缩后会有三个文件,列表如下:
mssqlserver.jar,msutil.jar,msbase.jar文件
然后将上面的三个文件导入classpath路径中去:
2.然后就可以直接的去使用了:
连接数据库的程序代码如下:
import java.sql.*;
class dbconn
{
public static void main(string[] args)
{
system.out.println("hello world!");
dbconn aaa=new dbconn();
aaa.connectiondb();
system.out.println("this is ending!");
}
public static void connectiondb ()
{
try{
class.forname("com.microsoft.jdbc.sqlserver.sqlserverdriver").newinstance();
string url="jdbc:microsoft:sqlserver://panming:1433;databasename=pubs";
string user="sa";
string password="1980";
connection conn= drivermanager.getconnection(url,user,password);
statement stmt=conn.createstatement();
string sql="select * from jobs";
resultset rs=stmt.executequery(sql);
if(rs.next()){
system.out.println("it has some recordset!");
while(rs.next()) {
system.out.println(rs.getstring(1));
}
}
else
{
system.out.println("it has no recordset!");
}
}
catch (exception e)
{system.out.println("ok!!");}
}
}
闽公网安备 35060202000074号