java連接數(shù)據(jù)庫(kù)的代碼

package mysql;

成都創(chuàng)新互聯(lián)企業(yè)建站,10余年網(wǎng)站建設(shè)經(jīng)驗(yàn)，專(zhuān)注于網(wǎng)站建設(shè)技術(shù)，精于網(wǎng)頁(yè)設(shè)計(jì)，有多年建站和網(wǎng)站代運(yùn)營(yíng)經(jīng)驗(yàn)，設(shè)計(jì)師為客戶(hù)打造網(wǎng)絡(luò)企業(yè)風(fēng)格，提供周到的建站售前咨詢(xún)和貼心的售后服務(wù)。對(duì)于成都網(wǎng)站設(shè)計(jì)、網(wǎng)站制作中不同領(lǐng)域進(jìn)行深入了解和探索，創(chuàng)新互聯(lián)在網(wǎng)站建設(shè)中充分了解客戶(hù)行業(yè)的需求，以靈動(dòng)的思維在網(wǎng)頁(yè)中充分展現(xiàn)，通過(guò)對(duì)客戶(hù)行業(yè)精準(zhǔn)市場(chǎng)調(diào)研，為客戶(hù)提供的解決方案。

import java.sql.*;

/**

* @author xys

*/

public class ConnectMysql {

public static Connection getConnection() throws ClassNotFoundException, SQLException {

String url = "jdbc:mysql://localhost:3306/databaseName";

String user = "mysqluser";

String password = "password";

String driverClass = "com.mysql.cj.jdbc.Driver";

Connection connection = null;

Class.forName(driverClass);

try {

connection = DriverManager.getConnection(url, user, password);

} catch (SQLException e) {

e.printStackTrace();

}

if (connection != null) {

System.out.println("數(shù)據(jù)庫(kù)連接成功");

} else {

System.out.println("數(shù)據(jù)庫(kù)連接失敗");

connection.close();

}

return connection;

}

public void getResult() throws ClassNotFoundException, SQLException {

// 實(shí)例化 Statement 對(duì)象

Statement statement = getConnection().createStatement();

// 要執(zhí)行的 Mysql 數(shù)據(jù)庫(kù)操作語(yǔ)句（增、刪、改、查）

String sql = "";

// 展開(kāi)結(jié)果集數(shù)據(jù)庫(kù)

ResultSet resultSet = statement.executeQuery(sql);

while (resultSet.next()) {

// 通過(guò)字段檢索

int id = resultSet.getInt("id");

String name = resultSet.getString("name");

// 輸出數(shù)據(jù)

System.out.println("ID : " +id);

System.out.println("name :" + name);

}

// 完成后需要依次關(guān)閉

resultSet.close();

statement.close();

getConnection().close();

}

}

javaweb 做一個(gè)通訊錄的小項(xiàng)目 求源代碼 急求。

先設(shè)計(jì)數(shù)據(jù)庫(kù)中通訊錄表格（字段有:id,聯(lián)系人姓名，手機(jī)號(hào)，備注），然后，hebinate實(shí)現(xiàn)數(shù)據(jù)庫(kù)表到j(luò)avabean的映射，同時(shí)也會(huì)生成對(duì)通訊錄表格的增刪改查的基本sql語(yǔ)句對(duì)應(yīng)的接口。然后你再寫(xiě)一個(gè)Servlet，連接頁(yè)面自己數(shù)據(jù)庫(kù)操作接口即可

java通訊錄管理系統(tǒng)設(shè)計(jì)代碼怎么編譯

java編寫(xiě)這個(gè)通訊錄管理系統(tǒng)

java編寫(xiě)這個(gè)通訊錄管理系統(tǒng)_Java如何實(shí)現(xiàn)通訊錄管理系統(tǒng)

咕嚕嚕在芬蘭

原創(chuàng)

關(guān)注

3點(diǎn)贊·2305人閱讀

Java如何實(shí)現(xiàn)通訊錄管理系統(tǒng)

發(fā)布時(shí)間：2020-07-28 09:39:42

來(lái)源：億速云

閱讀：65

作者：Leah

這篇文章將為大家詳細(xì)講解有關(guān)Java如何實(shí)現(xiàn)通訊錄管理系統(tǒng)，文章內(nèi)容質(zhì)量較高，因此小編分享給大家做個(gè)參考，希望大家閱讀完這篇文章后對(duì)相關(guān)知識(shí)有一定的了解。

本文實(shí)例為大家分享了java實(shí)現(xiàn)通訊錄管理系統(tǒng)的具體代碼，供大家參考，具體內(nèi)容如下

完成項(xiàng)目的流程：

1.根據(jù)需求，確定大體方向

2.功能模塊分析

3.界面實(shí)現(xiàn)

4.功能模塊設(shè)計(jì)

5.coding

6.代碼測(cè)試

下面是源代碼：import java.awt.Container;

import java.awt.GridLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.io.BufferedReader;

import java.io.FileNotFoundException;

import java.io.FileReader;

import java.io.FileWriter;

import java.io.IOException;

import java.util.ArrayList;

import java.util.Scanner;

import java.util.concurrent.SynchronousQueue;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JPanel;

import javax.swing.WindowConstants;

import javax.swing.text.html.HTMLDocument.Iterator;

class Infro{

public String id;

public String name;

public String sex;

public String address;

public String e_mail;

public String phoneNumber;

static int index = 0;

static ArrayList list = new ArrayList();

static int len = list.size();

//構(gòu)造函數(shù)

public Infro(String id,String name,String sex,String address,String e_mail,String phoneNumber){

this.id = id;

this.name = name;

this.sex = sex;

this.address = address;

this.e_mail = e_mail;

this.phoneNumber = phoneNumber;

}

public String toString(){

return "編號(hào)："+id+" 姓名："+name+" 性別："+sex+" 通訊地址："+address+" 郵箱地址："+e_mail+" 電話(huà)："+phoneNumber;

}

/**

* 添加功能

**/

public static void addFunction(){//添加功能

Infro infro = new Infro("","","","","","");

System.out.println("請(qǐng)輸入添加的數(shù)據(jù)：");

Scanner in = new Scanner(System.in);

System.out.println("輸入編號(hào)：");

infro.id = in.next();

System.out.println("輸入姓名：");

infro.name = in.next();

System.out.println("輸入性別：");

infro.sex = in.next();

System.out.println("輸入通訊地址：");

infro.address = in.next();

System.

out.println("輸入郵箱地址：");

infro.e_mail = in.next();

System.out.println("輸入電話(huà)：");

infro.phoneNumber = in.next();

list.add(index,infro);

index++;

if(list.isEmpty()){

System.out.println("數(shù)據(jù)添加失敗啦");

}else{

System.out.println("數(shù)據(jù)添加成功啦");

len++;//list集合長(zhǎng)度加一

// System.out.println(list.get(0).toString());

}

}

// public static void deleteFunction(){//刪除功能

// System.out.println("輸入要?jiǎng)h除的聯(lián)系人的編號(hào)");

// Scanner in_2 = new Scanner(System.in);

// String d1 = in_2.nextLine();

// for(int a= 0; a

// if(d1.equals(list.get(a).id)){

// list.remove(list.get(a));

// len --;

// }

// }

// }

/**

* 刪除功能

**/

public static void deleteFunction(){

System.out.println("輸入要?jiǎng)h除的聯(lián)系人的編號(hào)");

Scanner in_2 = new Scanner(System.in);

String d1 = in_2.nextLine();

java.util.Iterator it = list.iterator();

while (it.hasNext()){

Infro infro = it.next();

if (infro.id.equals(d1)){

it.remove();

--index;//一定要加這個(gè)，否則當(dāng)做了刪除操作再做添加操作的時(shí)候會(huì)出現(xiàn)異常(類(lèi)似于指針，棧)

System.out.println("刪除完畢"+"此時(shí)通訊錄記錄條數(shù)為：" + --len);

}

}

}

/**

* 修改功能

**/

public static void reditFunction(){

System.out.println("輸入要修改的通訊錄的Id");

Scanner in_r = new Scanner(System.in);

String r1 = in_r.nextLine();

for(int a = 0; a len;a++){

if(r1.equals(list.get(a).id)){

System.out.println("輸入修改后的姓名：");

String name_1 = in_r.next();

list.get(a).name = name_1;

System.out.println("輸入修改后的性別：");

String sex_1 = in_r.next();

list.get(a).sex = sex_1;

System.out.println("輸入修改后的通訊地址：");

String address_1 = in_r.next();

list.get(a).address = address_1;

System.out.println("輸入修改后的郵箱地址：");

String e_mail_1 = in_r.next();

list.get(a).e_mail = e_mail_1;

System.out.println("輸入修改后的電話(huà)：");

String phoneNumber_1 = in_r.next();

list.get(a).phoneNumber = phoneNumber_1;

System.out.println("數(shù)據(jù)修改完畢");

}

}

}

/**

* 查詢(xún)功能

**/

public static void searchFunction() throws Exception{//查詢(xún)功能

System.out.println("請(qǐng)輸入要查詢(xún)的姓名：");

Scanner in_1 = new Scanner(System.in);

String s1=in_1.nextLine();

for(int a= 0; a

if(s1.equals(list.get(a).name)){

System.out.println(list.get(a).toString());

}

}

}

/**

* 顯示功能

**/

public static void showFunction(){

for(int i = 0 ;i

System.out.println(list.get(i).toString());

}

}

/**

* 保存功能

**/

public static void writeFunction() throws IOException{

FileWriter writer = new FileWriter("通訊錄管理.txt");

for(int i = 0 ;i

String []strwriter = new String[len];

strwriter[i]=list.get(i).toString();

writer.write(strwriter[i]);

writer.write("\r\n");

System.out.println("成功寫(xiě)入一行數(shù)據(jù)到 通訊錄管理.txt 中");

}

writer.close();//關(guān)閉寫(xiě)入流，釋放資源

}

/**

* 讀取功能

**/

public static void readFunction() throws IOException{

FileReader reader = new FileReader("通訊錄管理.txt");

BufferedReader br = new BufferedReader(reader);

String str;

while((str = br.readLine()) != null){//每次讀取一行文本，判斷是否到達(dá)文件尾

System.out.println(str);

}

br.close();

}

}

public class Demo extends JFrame {

/**

* 界面設(shè)計(jì)

**/

public Demo(){

Container c = getContentPane(); //定義一個(gè)頂級(jí)容器c

JPanel jp = new JPanel(); //新建JPanel面板--jp

JButton button1 = new JButton("新建聯(lián)系人");

JButton button2 = new JButton("刪除聯(lián)系人");

JButton button3 = new JButton("編輯聯(lián)系人");

JButton button4 = new JButton("查找聯(lián)系人");

JButton button5 = new JButton("顯示所有聯(lián)系人");

JButton button6 = new JButton("保存聯(lián)系人到本地");

JButton button7 = new JButton("讀取本地聯(lián)系人");

jp.setLayout(new GridLayout(2,4,5,5));//新建網(wǎng)格布局管理器(行數(shù)，列數(shù)，組件間的水平垂直間距)

jp.add(button1);

jp.add(button2);

jp.add(button3);

jp.add(button4);

jp.add(button5);

jp.add(button6);

jp.add(button7);

c.add(jp);//將JPanel面板jp添加到頂級(jí)容器c中

setSize(600,500);

setTitle("*通 訊 錄 管 理 系 統(tǒng)*");

setVisible(true);

setResizable(false);//窗體大小由程序員決定，用戶(hù)不能自由改變大小

setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);

/**

*按鍵響應(yīng)

*

**/

button1.addActionListener(new ActionListener(){//添加功能實(shí)現(xiàn)

public void actionPerformed(ActionEvent arg0){

Infro.addFunction();

}

});

button2.addActionListener(new ActionListener(){//刪除功能實(shí)現(xiàn)

public void actionPerformed(ActionEvent arg0){

Infro.deleteFunction();

}

});

button3.addActionListener(new ActionListener(){//修改功能實(shí)現(xiàn)

public void actionPerformed(ActionEvent arg0){

Infro.reditFunction();

}

});

button4.addActionListener(new ActionListener(){//查詢(xún)功能實(shí)現(xiàn)

public void actionPerformed(ActionEvent arg0){

try {

Infro.searchFunction();

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

});

button5.addActionListener(new ActionListener(){//顯示功能實(shí)現(xiàn)

public void actionPerformed(ActionEvent arg0){

Infro.showFunction();

}

});

button6.addActionListener(new ActionListener(){//保存功能實(shí)現(xiàn)

public void actionPerformed(ActionEvent arg0){

try {

Infro.writeFunction();

} catch (IOException e) {

e.printStackTrace();

}

}

});

button7.addActionListener(new ActionListener(){//讀取功能實(shí)現(xiàn)

public void actionPerformed(ActionEvent arg0){

try {

Infro.readFunction();

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

});

}

public static void main(String[] args) {

// TODO Auto-generated method stub

new Demo();

Infro a = new Infro("", "", "", "", "", "");

}

}

關(guān)于Java如何實(shí)現(xiàn)通訊錄管理系統(tǒng)就分享到這里了，希望以上內(nèi)容可以對(duì)大家有一定的幫助，可以學(xué)到更多知識(shí)。如果覺(jué)得文章不錯(cuò)，可以把它分享出去讓更多的人看到。

java通訊錄全部代碼！

import java.io.BufferedOutputStream;

import java.io.File;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.FileReader;

import java.io.IOException;

import java.io.PrintWriter;

import java.util.Scanner;

public class AddList {

private String filePath = "";

private String bakPath = "";

private String content = "";

Scanner sc = new Scanner(System.in);

public String readFile(){

content = "";

if (isNull(filePath)) {

System.out.println("文件存儲(chǔ)路徑：");

filePath = sc.nextLine();

}

File file = new File(filePath);

FileReader fr = null;

try {

if (file.exists()) {

fr = new FileReader(file);

char[] chars = new char[1024];

int n = 0;

while((n = fr.read(chars)) != -1){

String string = new String(chars, 0, n);

content = content + string;

}

} else {

System.out.println("文件不存在");

}

} catch (Exception e) {

e.printStackTrace();

} finally {

if (fr != null) {

try {

fr.close();

} catch (IOException e) {

e.printStackTrace();

}

}

}

return content;

}

public void writeFile(String path){

File file = new File(path);

FileOutputStream fos = null;

mkDirs(path);

try {

fos = new FileOutputStream(file);

BufferedOutputStream bos = new BufferedOutputStream(fos);

PrintWriter pw = new PrintWriter(bos, true);

pw.print(content);

pw.flush();

} catch (FileNotFoundException e) {

e.printStackTrace();

} finally {

if (fos != null) {

try {

fos.close();

} catch (IOException e) {

e.printStackTrace();

}

}

}

}

public void writeFile(){

if (isNull(filePath)) {

System.out.println("文件存儲(chǔ)路徑：");

filePath = sc.nextLine();

}

File file = new File(filePath);

FileOutputStream fos = null;

mkDirs(filePath);

try {

fos = new FileOutputStream(file);

BufferedOutputStream bos = new BufferedOutputStream(fos);

PrintWriter pw = new PrintWriter(bos, true);

pw.print(content);

pw.flush();

} catch (FileNotFoundException e) {

e.printStackTrace();

} finally {

if (fos != null) {

try {

fos.close();

} catch (IOException e) {

e.printStackTrace();

}

}

}

}

public void mkDirs(String filepath){

if (filepath.indexOf("\\") != -1) {

filepath = filepath.replaceAll("\\", "/");

}

int n = filepath.indexOf("http://");

String path = filepath.substring(0, n) + "http://";

filepath = filepath.substring(filepath.indexOf("http://") + 1, filepath.length());

String[] files = filepath.split("/");

for (int i = 0; i files.length - 1; i++) {

path = path + files[i];

File file = new File(path);

if (!file.exists()) {

file.mkdir();

}

}

}

public void addImfor(){

System.out.println("--------增加記錄---------");

String name = "";

String tel = "";

String email = "";

content = readFile();

while(true){

System.out.println("姓名：");

name = sc.next();

System.out.println("電話(huà)：");

tel = sc.next();

System.out.println("Email：");

email = sc.next();

content = content + name + "" + tel + "" + email +"==";

System.out.println("0、Exit 1、繼續(xù)");

int i = sc.nextInt();

if (i == 0) {

break;

}

}

writeFile();

}

public void deleteImfor(){

System.out.println("---------刪除記錄---------");

String name = "";

String[] imfors = null;

content = readFile();

while(true){

System.out.println("你要?jiǎng)h除的姓名是：");

name = sc.next();

if (content.indexOf(name) != -1) {

imfors = content.split("==");

for (int i = 0; i imfors.length; i++) {

if (imfors[i].indexOf(name) != -1) {

imfors[i] = "";

}

}

Java通訊錄連接到數(shù)據(jù)庫(kù)

數(shù)據(jù)庫(kù)保存數(shù)據(jù)？那就是JDBC了，會(huì)用吧?用mysql，oracle等來(lái)保存，寫(xiě)一個(gè)connection的Util類(lèi)，其他的操作,沒(méi)有代碼我也很難說(shuō)清楚，反正是把jdbc的操作加到你代碼就行了