jdbcapplication.java

来自「有关java的源程序,为讲授java程序设计课程使用」· Java 代码 · 共 723 行 · 第 1/2 页

JAVA
723 行
字号
12

import java.sql.*;
import java.io.*;
/*
In the database, Table Name==student,  Fields in Table student :
(id, int),(name,char),(age,int); Data Source Name(DSN) in DBC Is
studlist
*/
public class  JdbcApplication
{
        public static void main(String args[]) 
        {
			JdbcApplication myJdbcApp=new JdbcApplication();
			myJdbcApp.StatementExecSQLSelect();
			try
		    {
			System.out.println("\nPress Any Key to Continue...");
			System.in.read();
		    }catch(IOException e)
		    {                    
		    }

			myJdbcApp.StatementExecSQLUpdateDBRecord();
			try
		    {
			System.out.println("\nPress Any Key to Continue...");
			System.in.read();
		    }catch(IOException e)
		    {                    
		    }

			myJdbcApp.StatementExecSQLInsertUpdateDB();
			try
		    {
			System.out.println("\nPress Any Key to Continue...");
			System.in.read();
		    }catch(IOException e)
		    {                    
		    }

			myJdbcApp.StatementExecSQLDeleteUpdateDB();
			try
		    {
			System.out.println("nPress Any Key to Continue...");
			System.in.read();
		    }catch(IOException e)
		    {                    
		    }

			myJdbcApp.StatementExecSQLCreateTable();
			try
		    {
			System.out.println("\nPress Any Key to Continue...");
			System.in.read();
		    }catch(IOException e)
		    {                    
		    }

			myJdbcApp.StatementExecSQLDropTable();
			try
		    {
			System.out.println("\nPress Any Key to Continue...");
			System.in.read();
		    }catch(IOException e)
		    {                    
		    }

			myJdbcApp.PreparedStatementExecSQLSelect();
			try
		    {
			System.out.println("\nPress Any Key to Continue...");
			System.in.read();
		    }catch(IOException e)
		    {                    
		    }

			myJdbcApp.PreparedStatementExecSQLUpdateDBRecord();
			try
		    {
			System.out.println("\nPress Any Key to Continue...");
			System.in.read();
		    }catch(IOException e)
		    {                    
		    }

			myJdbcApp.PreparedStatementExecSQLUpdateDBRecordWithParameter();
			try
		    {
			System.out.println("\nPress Any Key to Continue...");
			System.in.read();
		    }catch(IOException e)
		    {                    
		    }

/*
			myJdbcApp.CallableStatementStoreProc();
			try
		    {
			System.out.println("\nPress Any Key to Continue...");
			System.in.read();
		    }catch(IOException e)
		    {                    
		    }
*/

        }

void StatementExecSQLSelect()
		{
//URL Format: "jdbc:odbc:Data Source Name",  DSN不区分大小写
                String url="jdbc:odbc:studlist";
				String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
				Connection con=null;
				Statement stmt;
				ResultSet rs;
		try
		{
				Class.forName(DBDriver);
		}
		catch(ClassNotFoundException e)
	    {
		        System.out.println(e);
	    }
/*
In SQL Server:
                con=DriverManager.getConnection(url,"yanguser","1234");
In Microsoft Access:
                con=DriverManager.getConnection(url,"","");
*/
		try
		{
                con=DriverManager.getConnection(url,"yanguser","1234");
//Get Data Base Basica Information
				System.out.println("\nData Base Basica Information");
                DatabaseMetaData dma=con.getMetaData();
				System.out.println("URL String:"+dma.getURL());
                System.out.println("Driver Name:"+dma.getDriverName());
                System.out.println("Driver Version:"+dma.getDriverVersion());
				System.out.println("Driver Major Version:"+dma.getDriverMajorVersion());
				System.out.println("Driver Minor Version:"+dma.getDriverMinorVersion());
				System.out.println("User Name:"+dma.getUserName());
System.out.println("Database Product Name:"+dma.getDatabaseProductName());
System.out.println("Database Product Name:"+dma.getDatabaseProductVersion());

                stmt=con.createStatement();
//Execute SQLSelect 
				System.out.print("Execute SQL Select Statement\n");
                rs=stmt.executeQuery("select * from  student");
                while(rs.next())
 	            {
// Field Name 不区分大小写
					int ID=rs.getInt("ID");
                    System.out.print("ID: "+ID+" ");		
                    String Name=rs.getString("NAME");
                    System.out.print("Name: "+Name+" ");
				    int AGE=rs.getInt("AGE");
                    System.out.println("Age: "+AGE);		

                }
				stmt.close();   //must close
                con.close();
      }
      catch(SQLException e)
      {
                System.out.println("SQLState:"+e.getSQLState());
                System.out.println("Message:"+e.getMessage());
                System.out.println("Vendor:"+e.getErrorCode());
      }
            
		}

void StatementExecSQLUpdateDBRecord()
		{
            try
            {
//URL Format: "jdbc:odbc:Data Source Name"
                String url="jdbc:odbc:studlist";
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
/*
In SQL Server:
                Connection con=DriverManager.getConnection(url,"yanguser","1234");
In Microsoft Access:
                Connection con=DriverManager.getConnection(url,"","");
*/
                Connection con=DriverManager.getConnection(url,"yanguser","1234");
//Get Data Base Basica Information
				System.out.println("\nData Base Basica Information");
                DatabaseMetaData dma=con.getMetaData();

				System.out.println("URL String:"+dma.getURL());
                System.out.println("Driver Name:"+dma.getDriverName());
                System.out.println("Driver Version:"+dma.getDriverVersion());
				System.out.println("Driver Major Version:"+dma.getDriverMajorVersion());
				System.out.println("Driver Minor Version:"+dma.getDriverMinorVersion());
				System.out.println("User Name:"+dma.getUserName());
System.out.println("Database Product Name:"+dma.getDatabaseProductName());
System.out.println("Database Product Name:"+dma.getDatabaseProductVersion());

                Statement stmt=con.createStatement();
//Update DB(Execute SQL update Statement)
                System.out.print("Update DateBase----StateMent.executeUpdate()\n");
		        int RecordRowNum=stmt.executeUpdate("Update student set name='yang' where id=1");
				System.out.println("The Record Row Num Is "+RecordRowNum);
                ResultSet rs=stmt.executeQuery("select * from  student");
                while(rs.next())
 	            {
		           int ID=rs.getInt("id");
                   System.out.print("ID: "+ID+" ");		
                   String Name=rs.getString("name");
                   System.out.print("Name: "+Name+" ");
				   int AGE=rs.getInt("age");
                   System.out.println("Age: "+AGE);		
                }
				stmt.close();   //must close
                con.close();
                }
            catch(SQLException e)
            {
                   System.out.println("SQLState:"+e.getSQLState());
                   System.out.println("Message:"+e.getMessage());
                   System.out.println("Vendor:"+e.getErrorCode());
            }
            catch(ClassNotFoundException e)
            {
                   System.out.println(e);
            }

		}

void StatementExecSQLInsertUpdateDB()
		{
            try
            {
//URL Format: "jdbc:odbc:Data Source Name"
                String url="jdbc:odbc:studlist";
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
/*
In SQL Server:
                Connection con=DriverManager.getConnection(url,"yanguser","1234");
In Microsoft Access:
                Connection con=DriverManager.getConnection(url,"","");
*/
                Connection con=DriverManager.getConnection(url,"yanguser","1234");
//Get Data Base Basica Information
				System.out.println("\nData Base Basica Information");
                DatabaseMetaData dma=con.getMetaData();
				System.out.println("URL String:"+dma.getURL());
                System.out.println("Driver Name:"+dma.getDriverName());
                System.out.println("Driver Version:"+dma.getDriverVersion());
				System.out.println("Driver Major Version:"+dma.getDriverMajorVersion());
				System.out.println("Driver Minor Version:"+dma.getDriverMinorVersion());
				System.out.println("User Name:"+dma.getUserName());
System.out.println("Database Product Name:"+dma.getDatabaseProductName());
System.out.println("Database Product Name:"+dma.getDatabaseProductVersion());

                Statement stmt=con.createStatement();
//Update DB(Execute SQL insert Statement)
                System.out.print("Insert DateBase----StateMent.executeUpdate()\n");
		        int RecordRowNum=stmt.executeUpdate("insert into student(id,name,age) values(3,'zhang',30)");
			  	System.out.println("The Record Row Num Is "+RecordRowNum);
				ResultSet rs=stmt.executeQuery("select * from  student");
                while(rs.next())
 	            {
				   int ID=rs.getInt("id");
                   System.out.print("ID: "+ID+" ");		
                   String Name=rs.getString("name");
                   System.out.print("Name: "+Name+" ");
				   int AGE=rs.getInt("age");
                   System.out.println("Age: "+AGE);		
                }
				stmt.close();   //must close
                con.close();
                }
            catch(SQLException e)
            {
                   System.out.println("SQLState:"+e.getSQLState());
                   System.out.println("Message:"+e.getMessage());
                   System.out.println("Vendor:"+e.getErrorCode());
            }
            catch(ClassNotFoundException e)
            {
                   System.out.println(e);
            }

		}

void StatementExecSQLDeleteUpdateDB()
		{
            try
            {
//URL Format: "jdbc:odbc:Data Source Name"
                String url="jdbc:odbc:studlist";
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
/*
In SQL Server:
                Connection con=DriverManager.getConnection(url,"yanguser","1234");
In Microsoft Access:
                Connection con=DriverManager.getConnection(url,"","");
*/
                Connection con=DriverManager.getConnection(url,"yanguser","1234");
//Get Data Base Basica Information
				System.out.println("\nData Base Basica Information");
                DatabaseMetaData dma=con.getMetaData();
				System.out.println("URL String:"+dma.getURL());
                System.out.println("Driver Name:"+dma.getDriverName());
                System.out.println("Driver Version:"+dma.getDriverVersion());
				System.out.println("Driver Major Version:"+dma.getDriverMajorVersion());
				System.out.println("Driver Minor Version:"+dma.getDriverMinorVersion());
				System.out.println("User Name:"+dma.getUserName());
System.out.println("Database Product Name:"+dma.getDatabaseProductName());
System.out.println("Database Product Name:"+dma.getDatabaseProductVersion());

                Statement stmt=con.createStatement();

//Update DB(Execute SQL delete Statement)
				System.out.print("Delete DateBase----StateMent.executeUpdate()\n");
		        int RecordRowNum=stmt.executeUpdate("DELETE FROM student WHERE id=3");
				System.out.println("The Record Row Num Is "+RecordRowNum);
                ResultSet rs=stmt.executeQuery("select * from  student");
                while(rs.next())
 	            {
		           int ID=rs.getInt("id");
                   System.out.print("ID: "+ID+" ");		
                   String Name=rs.getString("name");
                   System.out.print("Name: "+Name+" ");
				   int AGE=rs.getInt("age");
                   System.out.println("Age: "+AGE);		
                }
				stmt.close();   //must close
                con.close();
                }
            catch(SQLException e)
            {
                   System.out.println("SQLState:"+e.getSQLState());
                   System.out.println("Message:"+e.getMessage());
                   System.out.println("Vendor:"+e.getErrorCode());
            }
            catch(ClassNotFoundException e)
            {
                   System.out.println(e);
            }

		}
void StatementExecSQLCreateTable()
		{
            try
            {
//URL Format: "jdbc:odbc:Data Source Name"
                String url="jdbc:odbc:studlist";
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
/*
In SQL Server:
                Connection con=DriverManager.getConnection(url,"yanguser","1234");
In Microsoft Access:
                Connection con=DriverManager.getConnection(url,"","");
*/
                Connection con=DriverManager.getConnection(url,"yanguser","1234");
//Get Data Base Basica Information
				System.out.println("\nData Base Basica Information");
                DatabaseMetaData dma=con.getMetaData();
				System.out.println("URL String:"+dma.getURL());
                System.out.println("Driver Name:"+dma.getDriverName());
12

jdbcapplication.java - 源码说明

本页面展示了「有关java的源程序,为讲授java程序设计课程使用」中的 jdbcapplication.java 源码文件，采用 Java 编程语言编写，共 723 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与java相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?