java 数据库编写代码_用java代码编写连接数据库操作

package JDBC_Manager;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.util.concurrent.ExecutionException;

import javax.swing.text.DefaultEditorKit.PasteAction;

import org.w3c.dom.html.HTMLHRElement;

import com.sun.corba.se.impl.orbutil.RepositoryIdStrings;

import com.sun.rmi.rmid.ExecPermission;

import Day1.PrepareStatement;

/**

*

在此类中创建并实现所有对数据库表的操作，包括增、删、改、查

*

*

*/

public class AccountDAO {

//1、实现通过卡号，查询账户的所有信息。

public Account queryAccount(String card_id)throws Exception{

Connection conn=null;

PreparedStatement pstm=null;

ResultSet rest=null;

//①、连接数据库

Accountutil accountutil=new Accountutil();

conn=accountutil.getconnection();

//②、准备sql语句

String str="select card_id,card_passward,card_balance,card_name,card_phone from Account where card_id=?";

//③、发送sql语句

pstm=conn.prepareStatement(str);

pstm.setString(1, card_id);

rest=pstm.executeQuery();

Account acc=new Account();

//④、处理返回的结果集

while(rest.next()){

String card_passward=rest.getString("card_passward");

double card_balance=rest.getDouble("card_balance");

String card_name=rest.getString("card_name");

String card_phone=rest.getString("card_phone");

acc.setCard_balance(card_balance);

acc.setCard_name(card_name);

acc.setCard_passward(card_passward);

acc.setCard_phone(card_phone);

acc.setCard_id(card_id);

}

//关闭资源

accountutil.closeconnection(conn, pstm, rest);

return acc;

}

/**

* 2、通过卡号查询某个信息，并修改查询的信息并保存最终的结果。

*/

public void UpdateAccount(Account account)throws Exception{

Connection con=null;

PreparedStatement past=null;

//①、连接数据库

Accountutil accountutil=new Accountutil();

con=accountutil.getconnection();

String str1=account.getCard_passward();

double dou1=account.getCard_balance();

String updatesql="update Account set card_passward=? ,card_balance=? ,card_name=? ,card_phone=? where card_id=?";

past=con.prepareStatement(updatesql);

past.setString(1, account.getCard_passward());

past.setDouble(2,account.getCard_balance());

past.setString(3, account.getCard_name());

past.setString(4, account.getCard_phone());

past.setString(5, account.getCard_id());

past.executeUpdate();

accountutil.closeconnection(con, past, null);

}

//3、根据卡号，删除该卡号的所有信息

public void deleteAccount(String a)throws Exception{

Connection conn=null;

PreparedStatement pstm=null;

//①、连接数据库

Accountutil accountutil=new Accountutil();

conn=accountutil.getconnection();

String deletesql="delete from Account where card_id=?";

pstm=conn.prepareStatement(deletesql);

pstm.setString(1, a);

pstm.executeUpdate();

accountutil.closeconnection(conn, pstm, null);

}

//4、增加一行数据，卡号随机生成。

public void addAccount(Account acc)throws Exception{

Connection conn=null;

PreparedStatement pstm=null;

ResultSet rest=null;

//①、连接数据库

Accountutil accountutil=new Accountutil();

conn=accountutil.getconnection();

String str2="select seq_newsid.nextval from sys.dual";

pstm=conn.prepareStatement(str2);

rest=pstm.executeQuery();

String str3 = null;

while(rest.next()){

str3=rest.getString(1);

}

String str="insert into Account(card_id,card_passward,card_balance,card_name,card_phone)values(?,?,?,?,?)";

pstm=conn.prepareStatement(str);

acc.setCard_id(str3);

pstm.setString(1, str3);

pstm.setString(2,acc.getCard_passward() );

pstm.setDouble(3, acc.getCard_balance());

pstm.setString(4, acc.getCard_name());

pstm.setString(5, acc.getCard_phone());

pstm.executeUpdate()；

accountutil.closeconnection(conn, pstm, rest);

}

}

//在此类中实现所有工具

package JDBC_Manager;

import java.io.InputStream;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.*;

import Day1.PrepareStatement;

public class JDBCutil2 {

private static final Properties prop=new Properties();

/**

* properties 是 map的子类 ，可以通过properties进行读取操作，

* 创建.properties文件 用来保存将来容易改变的数据 。例如 url、DriverManager等。

*/

static InputStream is=null;

static{

try {

is=JDBCutil2.class.getResourceAsStream("/JDBC_Manager/JDBC.properties");

prop.load(is);

String str1=prop.getProperty("DriverManager");

Class.forName(str1);

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public Connection getconnection(){

Connection con=null;

try {

String str2=prop.getProperty("url");

String str3=prop.getProperty("user");

String str4=prop.getProperty("password");

con=DriverManager.getConnection(str2,str3,str4);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return con;

}

public void closeconnection(Connection con,PreparedStatement pstm,ResultSet rest){

try {

rest.close();

} catch (SQLException e2) {

// TODO Auto-generated catch block

e2.printStackTrace();

}

try {

rest.close();

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

try {

con.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

package JDBC_Manager;

//在此类中管理表

import java.io.InputStream;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.*;

import Day1.PrepareStatement;

public class JDBCutil2 {

private static final Properties prop=new Properties();

/**

* properties 是 map的子类 ，可以通过properties进行读取操作，

* 创建.properties文件 用来保存将来容易改变的数据 。例如 url、DriverManager等。

*/

static InputStream is=null;

static{

try {

is=JDBCutil2.class.getResourceAsStream("/JDBC_Manager/JDBC.properties");

prop.load(is);

String str1=prop.getProperty("DriverManager");

Class.forName(str1);

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

public Connection getconnection(){

Connection con=null;

try {

String str2=prop.getProperty("url");

String str3=prop.getProperty("user");

String str4=prop.getProperty("password");

con=DriverManager.getConnection(str2,str3,str4);

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return con;

}

public void closeconnection(Connection con,PreparedStatement pstm,ResultSet rest){

try {

rest.close();

} catch (SQLException e2) {

// TODO Auto-generated catch block

e2.printStackTrace();

}

try {

rest.close();

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

try {

con.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

//JDBC工程里的properties文件 取名 JDBC.properties

DriverManager=oracle.jdbc.OracleDriver

user=hr

password=wpp

url=jdbc:oracle:thin:@127.0.0.1:1521:xe

//测试类，可自写

package JDBC_Manager;

import java.util.concurrent.ExecutionException;

public class Text_account {

public static void main(String[] args)throws Exception{

/*AccountDAO ado=new AccountDAO();

Account acc=new Account();

String str="999";

acc=ado.queryAccount(str);

System.out.println(acc.getCard_balance()+" "+acc.getCard_name()+acc.getCard_phone());

*/

/*

AccountDAO ado=new AccountDAO();

Account acc=new Account("999","abc",888.0,"wpp","18839788888");

ado.UpdateAccount(acc);

*/

/*String aString="999";

AccountDAO ado=new AccountDAO();

ado.deleteAccount(aString);

*/

Account account=new Account("null","abc",999.0,"wpp","18839788028");

AccountDAO accDAO=new AccountDAO();

accDAO.addAccount(account);

}

}