MySQL数据库与登录注册

数据库

数据库中增删改查

CREATE DATABASE clazz

CREATE TABLE  student(id int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,stu_name varchar(30) NOT NULL,sex  int(1),age int(3))

insert into student(stu_name,sex,age)value('张三',1,0)
insert into student(stu_name,sex,age)value('李四',1,22)
insert into student(stu_name,sex,age)value('王五',0,23)

update  student set age=20,sex=0 where stu_name='张三'

select stu_name from student where age>20
select * from student

delete from student  where stu_name ='李四'
delete from student  where stu_name ='褚文斌'

insert into student(stu_name,sex,age)value('李海猛',0,23)

java连接数据库实现增删改查

   try {
            Class.forName(driver);//加载驱动
            //与数据库建立连接
            Connection conn=DriverManager.getConnection(url, user, password);
            if(!conn.isClosed()){
                //创建statement对象
                Statement state=conn.createStatement();
                //增
                String insert="insert into  student(stu_name,sex,age)values('旺财',1,23)";
                //改
                String update ="update student set age=20 where stu_name='李四'";
                //删
                String delete="delete from student where stu_name='李四'";

                //state.execute(insert);增删改
                //查
                String select="select *from student";
                //ResultSet 对象具有指向其当前数据行的光标。最初，
                //光标被置于第一行之前。next 方法将光标移动到下一行；
                //因为该方法在 ResultSet 对象没有下一行时返回 false，
                //所以可以在 while 循环中使用它来迭代结果集。 
                ResultSet set=state.executeQuery(select);
                set.first();
                while(!set.isAfterLast()){
                    String name =set.getString("stu_name");
                    System.out.println(name);
                    set.next();
                }

            }else{

            }

单例设计模式

/**
 * 
 * @author单例设计模式
 * 1私有构造器
 * 2静态公开的方法
 * 3私有静态的属性
 * 4方法加线程锁
 *
 */
public class SQLManager {
    private Statement statement;
    //私有静态的属性
    private static SQLManager manager;
    //静态公开的方法
    public static synchronized SQLManager newInstance() {
        if (manager == null) {
            manager = new SQLManager();
        }
        return manager;
    }
    //私有构造器
    private SQLManager() {

        String driver = "com.mysql.jdbc.Driver";
        String url = "jdbc:mysql://localhost:3306/clazz";
        String user = "root";
        String password = "123456";

        try {
            Class.forName(driver);// 加载驱动
            // 与数据库建立连接
            Connection conn = DriverManager.getConnection(url, user, password);
            if (!conn.isClosed()) {
                // 创建statement对象
                Statement state = conn.createStatement();
                // 增
                String insert = "insert into  student(stu_name,sex,age)values('旺财',1,23)";
                // 改
                String update = "update student set age=20 where stu_name='李四'";
                // 删
                String delete = "delete from student where stu_name='李四'";

                // state.execute(insert);增删改
                // 查
                String select = "select *from student";
                // ResultSet 对象具有指向其当前数据行的光标。最初，
                // 光标被置于第一行之前。next 方法将光标移动到下一行；
                // 因为该方法在 ResultSet 对象没有下一行时返回 false，
                // 所以可以在 while 循环中使用它来迭代结果集。
                ResultSet set = state.executeQuery(select);
                set.first();
                while (!set.isAfterLast()) {
                    String name = set.getString("stu_name");
                    System.out.println(name);
                    set.next();
                }

            } else {

            }

        } catch (ClassNotFoundException e) {

            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}

注册

public void actionPerformed(ActionEvent arg0) {
                String userName=textFieldUserName.getText();
                String password=textFieldPassword.getText();
                Statement  state=SQLManager.newInstance().getStatement();
                //查询
                String sql="select * from user where userName='"+userName+"'";
                try {
                    ResultSet  set=state.executeQuery(sql);
                    set.last();//游标移动到最后一行
                    int num =set.getRow();
                    System.out.println(num);
                    if(num>0){
                        System.out.println("该用户已存在");
                    }else{//查询没有然后注册

                        String register ="insert into user(userName,password)values('"+userName+"','"+password+"') ";
                        state.executeQuery(register);
                        System.out.println("注册成功");
                    }

登录

    public void actionPerformed(ActionEvent e) {
                String userName=textFieldUserName.getText();
                String password=textFieldpassword.getText();
                Statement  state=SQLManager.newInstance().getStatement();
                String select="select *from user where userName='"+userName+"'and '"+password+"'";

                try {
                    ResultSet set=state.executeQuery(select);
                    set.last();
                    int num=set.getRow();
                    System.out.println(num);
                    if(num==1){
                        System.out.println("存在此用户，跳转");
                    }else{
                        System.out.println("请先注册");
                    }


                } catch (SQLException e1) {

                    e1.printStackTrace();
                }



            }
        });