Java实现JDBC连接数据库简单案例

import java.sql.drivermanager;

import java.sql.resultset;

import java.sql.sqlexception;

import java.sql.statement;

public class dbm {

   public static void main(string[] args){

     //数据库连接参数

     string driverstr= "com.microsoft.sqlserver.jdbc.sqlserverdriver" ;

     string connstr= "jdbc:sqlserver://127.0.0.1:1433;databasename=school" ;// 可以localhost代替ip地址，端口号 1433

     string dbusername= "sa" ;

     string dbpassword= "" ;

     connection conn = null ;

     statement stmt = null ;

     resultset rs = null ;

     //1.连接数据库

     try {

       class .forname(driverstr);

       conn = drivermanager.getconnection(connstr,dbusername,dbpassword);

       stmt = conn.createstatement();

       system.out.println( "数据库建立连接成功！" );

     } catch (exception ex){

       system.out.println( "无法与数据库建立连接！" );

       system.out.println(ex.tostring());

     }

     //2.查询

     try {

       rs = stmt.executequery( "select * from student" );

     } catch (sqlexception e) {

       // todo auto-generated catch block

       e.printstacktrace();

     }

     //3.显示

     try {

       while (rs.next()){

         system.out.println(rs.getint( "sid" )+ " " +rs.getstring( "sname" )+ " " +rs.getstring( "ssex" )+ " " +rs.getint( "sage" ));

       }

     } catch (sqlexception e) {

       // todo auto-generated catch block

       e.printstacktrace();

     }

   }

}