[Java练习]JAVA中调用数据库的方法

package com.company;


import java.sql.*;


public class Main
{

    public static void main(String[] args) throws ClassNotFoundException, SQLException
    {
        Class.forName("com.mysql.jdbc.Driver");  //oracle.jdbc.driver.oracleDriver
        //加载jdbc驱动

        String strUrl = "jdbc:mysql://10.25.59.28:3306/neusoft"; //jdbc:oracle:thin:服务器地址:端口:数据库名
        //定义链接url

        Connection con = DriverManager.getConnection(strUrl, "root","root");
        //获取数据库连接

        Statement st = con.createStatement();
        //获得statement 对象（用来执行sql语句，病返回结果）

        String strSql = "select * from emp where deptno = 20";
        //执行查询或更新

        ResultSet rs = st.executeQuery(strSql);

        while (rs.next())
        {
            String strName = rs.getString("ename");
            String strJob = rs.getString("job");
            Integer nEmpNO = rs.getInt("empno");
            Date d = rs.getDate("hiredate");
            System.out.println("NO.:" + nEmpNO.toString() + "\t"
                    + "Name:" + strName.toString() + "\t"
                    + "Job:" + strJob
                    + "\t" + "hiredate:" + d.toString() );

        }
        //处理结果

        rs.close();
        st.close();
        con.close();
        //关闭连接（释放资源）

    }
}