jdbc 数据库连接验证 工具

加入相应的数据库驱动包
验证代码如下：

package com.study.jdbc;
import java.sql.*;

public class Mysql {

    //public static final String DBDRIVER ="oracle.jdbc.OracleDriver";//oracle
    //public static final String DBDRIVER ="com.microsoft.sqlserver.jdbc.SQLServerDriver";//sqlserver
    //public static final String DBDRIVER ="org.postgresql.Driver";//symfoware open,powergres plus
    //public static final String DBDRIVER ="com.fujitsu.symfoware.jdbc.SYMDriver";//symfoware native
    //public static final String DBDRIVER = "org.gjt.mm.mysql.Driver";
        public static final String DBDRIVER = "com.mysql.jdbc.Driver";
        //把SC换成你要连接的数据库的名字
        public static final String DBURL = "jdbc:mysql://localhost:3306/mytest"; //mysql
        //public static final String DBURL ="jdbc:oracle:thin:@10.167.157.157:1521:fnstdb2";//oracle
        //public static final String DBURL ="jdbc:sqlserver://193.168.250.221:1433;DatabaseName=db02";//sqlserver
        //public static final String DBURL ="jdbc:postgresql://10.167.133.112:26500/db01"; //symfoware open
        //public static final String DBURL ="jdbc:symford://193.168.228.221:26551/db01;schema=EJB"; //symfoware native
        //public static final String DBURL ="jdbc:postgresql://193.168.250.221:5432/postgres"; //powergres plus
        public static final String DBUSER = "root";   //user_name代表数据库用户的名称
        public static final String DBPASS = "911";   //user_password代表你对连接用户设置的密码


        public static void main(String[] args) {
            PreparedStatement ps1 = null;
            PreparedStatement ps2 = null;
            PreparedStatement ps3 = null;
            PreparedStatement ps4 = null;
            PreparedStatement ps5 = null;

//          Statement st = null;
            Connection ct = null;
            ResultSet rs1 = null;
            ResultSet rs2 = null;

            try {
                Class.forName(DBDRIVER);         //把驱动程序加载到jvm中去
                ct = DriverManager.getConnection(DBURL, DBUSER, DBPASS);   //取得数据库的一个连接对象
                if(ct!=null){
                System.out.println("连接成功！");
                }           
                //native
//              String sql1 = "DROP TABLE PERSON CASCADE";
//              String sql2 = "CREATE TABLE PERSON (PERSONID INTEGER NOT NULL PRIMARY KEY, PERSONNAME VARCHAR(32) NOT NULL)";
//              String sql3 = "CREATE INDEX PERSON.IXA KEY(PERSONID)";
//              String sql4 = "INSERT INTO PERSON(PERSONID, PERSONNAME) VALUES(1,'tong')";

                String sql1 = "DROP TABLE IF EXISTS PERSON";
                String sql2 = "CREATE TABLE PERSON (PERSONID INTEGER NOT NULL PRIMARY KEY, PERSONNAME VARCHAR(32) NOT NULL)";
                String sql3 = "INSERT INTO PERSON(PERSONID, PERSONNAME) VALUES(1,'tong')";
                String sql4 = "SELECT *FROM PERSON";
                String sql5 = "UPDATE PERSON SET PERSONNAME = 'CHX' where PERSONID = 1";

                ps1 = ct.prepareStatement(sql1);
                ps2 = ct.prepareStatement(sql2);
                ps3 = ct.prepareStatement(sql3);
                ps4 = ct.prepareStatement(sql4);
                ps5 = ct.prepareStatement(sql5);

                ps1.executeUpdate();
                 System.out.println("表删除成功！");
                ps2.executeUpdate();
                 System.out.println("表创建成功！");
                ps3.executeUpdate();
                 System.out.println("数据插入成功！");
                rs1=ps4.executeQuery();
                 System.out.println("数据表查询成功！");                
                 System.out.println("表中内容如下："); 
                while(rs1.next())
                {
                    System.out.println(rs1.getString(1) + " "
                            +rs1.getString(2)+ " "
//                          +rs.getString(3)+ " "
//                          +rs.getString(4)+ " "
                            );
                }   
                //表更新之后
                ps5.executeUpdate();
                 System.out.println("表更新成功！");
                 rs2=ps4.executeQuery();
                 System.out.println("数据表查询成功！");                
                 System.out.println("表中内容如下："); 
                while(rs2.next())
                {
                    System.out.println(rs2.getString(1) + " "
                            +rs2.getString(2)+ " "
//                          +rs.getString(3)+ " "
//                          +rs.getString(4)+ " "
                            );
                }   

            }catch(Exception e){
                e.printStackTrace();
                System.out.println("连接失败!");
            }finally{
                //关闭
                try {
                    if(rs1!=null) rs1.close();  
                    if(rs2!=null) rs2.close();

                    if(ps1!=null) ps1.close();
                    if(ps2!=null) ps2.close();
                    if(ps3!=null) ps3.close();
                    if(ps4!=null) ps4.close();
//                  if(st!=null) st.close();
                    if(ct!=null) ct.close();
                } catch (Exception e) {
                    // TODO: handle exception
                    e.printStackTrace();
                }
            }           
        }


    }