J2EE学习笔记(1) --JDBC

前言

工欲善其事，必先利其器。J2EE的学习中，我选择了对J2EE具有良好支持的myeclipse作为IDE。
由于博主安装myeclipse中支持的tomcat最高只有tomcat7.x，故选用了tomcat7作为服务器

工具

mysql官方驱动

建立数据库

这里我建了一个简单的学生数据库作为示例 Stu  Stu (StuNum,StuName)

插入

    import java.sql.DriverManager;
    import java.sql.SQLException;

    import com.mysql.jdbc.Connection;
    import com.mysql.jdbc.Statement;


    public class Insert1 {

        /**
         * @param args
         * @throws ClassNotFoundException 
         * @throws SQLException 
         */
        public static void main(String[] args) throws ClassNotFoundException, SQLException {
            // TODO Auto-generated method stub
            Class.forName("com.mysql.jdbc.Driver");
            Connection conn=(Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Stu?useUnicode=true&characterEncoding=utf8", "root", "");

            //insert

            Statement stat=(Statement) conn.createStatement();
            String sql="insert into Stu(StuNum,StuName) values('123','哈哈')";
            int i=stat.executeUpdate(sql);
            System.out.println(i);
            stat.close();
            conn.close();



        }
    }

    import java.sql.DriverManager;
import java.sql.SQLException;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;


public class Delete {

    /**
     * @param args
     * @throws ClassNotFoundException 
     * @throws SQLException 
     */
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
        // TODO Auto-generated method stub
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn=(Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/Stu?useUnicode=true&characterEncoding=utf8", "root", "");
        Statement stat=(Statement) conn.createStatement();
        String sql="delete from stu where StuNum=123";
        int i=stat.executeUpdate(sql);
        System.out.println(i);
        stat.close();
        conn.close();


    }

}