sqllite java 密码,通过sqlite建立账户及密码管理系统的实现与应用

1.sqlite建立表user

CREATE TABLE user(name text,

pwd text);

2.插入记录(省去...)

3.实现类:

package day7_2.d06;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Scanner;

public class manageMent {

public static void loginUser(){

System.out.println("请输入您的登录信息：");

System.out.println("-------------------------------------");

Connection conn=null;

try {

conn = DriverManager.getConnection("jdbc:sqlite:/c:/sqlite/db/my.db");

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

while(true){

Scanner sc=new Scanner(System.in);

System.out.println("请输入用户名:");

String name=sc.nextLine();

System.out.println("请输入密码:");

String pwd=sc.nextLine();

String sql="select * from user where name=? and pwd=?";

try {

Class.forName("org.sqlite.JDBC");

PreparedStatement stmt=conn.prepareStatement(sql);

stmt.setString(1,name);

stmt.setString(2,pwd);

ResultSet rs=stmt.executeQuery();

if(rs.next()){

System.out.println("登录成功!");

break;

}else{

System.out.println("登录失败!");

}

} catch (Exception e) {

e.printStackTrace();

}

}//while

try {

conn.close();

load();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

private static void findAllUser() {

String sql="select * from User";

try {

Class.forName("org.sqlite.JDBC");

Connection conn=DriverManager.getConnection("jdbc:sqlite:/c:/sqlite/db/my.db");

PreparedStatement stmt=conn.prepareStatement(sql);

ResultSet rs=stmt.executeQuery();

while(rs.next()){

System.out.println("用户名:"+rs.getString(1)+"-----"+"密码:"+rs.getString(2));

}

rs.close();

conn.close();

} catch (Exception e) {

e.printStackTrace();

}

}

public static void addUser(){

Scanner sc=new Scanner(System.in);

System.out.println("请输入添加的用户名:");

String name=sc.nextLine();

System.out.println("请输入添加的密码:");

String pwd=sc.nextLine();

//String sql="insert into user values("+name+","+pwd+")";

//String sql="insert into user values('ch','ch')";

String sql="insert into user values('"+name+"'"+","+"'"+pwd+"'"+")";

try {

Class.forName("org.sqlite.JDBC");

Connection conn=DriverManager.getConnection("jdbc:sqlite:/c:/sqlite/db/my.db");

Statement stmt=conn.createStatement();

int rs=stmt.executeUpdate(sql);

if(rs>0){

System.out.println("添加成功!");

}else{

System.out.println("添加失败！");

}

stmt.close();

conn.close();

} catch (Exception e) {

e.printStackTrace();

}

}

private static void deleteUser() {

Scanner sc=new Scanner(System.in);

System.out.println("请输入删除的用户名:");

String name=sc.nextLine();

String sql="delete from User where name="+"'"+name+"'";

try {

Class.forName("org.sqlite.JDBC");

Connection conn=DriverManager.getConnection("jdbc:sqlite:/c:/sqlite/db/my.db");

Statement stmt=conn.createStatement();

int rs=stmt.executeUpdate(sql);

if(rs>0){

System.out.println("删除成功!");

}else{

System.out.println("删除失败!");

}

stmt.close();

conn.close();

} catch (Exception e) {

e.printStackTrace();

}

}

private static void modifyUser() {

Scanner sc=new Scanner(System.in);

System.out.println("请输入您修改的用户名：");

String name=sc.nextLine();

System.out.println("请输入新的密码:");

String pwd=sc.nextLine();

String sql="update user set pwd="+"'"+pwd+"'"+"where name="+"'"+name+"'";

try {

Class.forName("org.sqlite.JDBC");

Connection conn=DriverManager.getConnection("jdbc:sqlite:/c:/sqlite/db/my.db");

Statement stmt=conn.createStatement();

int rs=stmt.executeUpdate(sql);

if(rs>0){

System.out.println("修改成功!");

}else{

System.out.println("修改失败 ！");

}

stmt.close();

conn.close();

} catch (Exception e) {

e.printStackTrace();

}

}

public static void load(){

while(true){

System.out.println("欢迎来到账户信息管理系统:");

System.out.println("--------------------------");

System.out.println("1:增加用户信息");

System.out.println("2:删除用户信息");

System.out.println("3:修改用户信息");

System.out.println("4:查看用户信息");

System.out.println("----------------------------");

System.out.println("请选择:");

Scanner sc=new Scanner(System.in);

int choose=0;

while(true){

try {

choose = sc.nextInt();

break;

} catch (Exception e) {

sc.next();//清除上次的输入信息

System.out.println("请输入合法信息:");

}

}

switch (choose) {

case 1:

addUser();

break;

case 2:

deleteUser();

break;

case 3:

modifyUser();

break;

case 4:

findAllUser();

break;

}

System.out.println("按任意键回到首页:");

String name=sc.next();

}//while

}

public static void main(String[] args) {

loginUser();

}

}