java连接mysql-2

数组与数据集

代码：

 

/* 创建表的SQL语句 
 use test;  
 create table empinfo
 (
 no varchar(10),
 name varchar(10),
 gender varchar(10),
 age varchar(10),
 dept varchar(10)
 );  
 */
package pa;
import java.io.*;
import java.sql.*;
public class MainDemo 
{
	static String[] EmpInfo;
	public static void getInfo()
	{
		BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
		try
		{
			EmpInfo=new String[5];
			System.out.println("请输入员工号：");
			EmpInfo[0]=new String(br.readLine().trim());
			System.out.println("请输入姓名：");
			EmpInfo[1]=new String(br.readLine().trim());
			System.out.println("请输入性别：");
			EmpInfo[2]=new String(br.readLine().trim());
			System.out.println("请输入年龄：");
			EmpInfo[3]=new String(br.readLine().trim());
			System.out.println("请输入部门：");
			EmpInfo[4]=new String(br.readLine().trim());
		}
		catch(IOException e)
		{
			e.printStackTrace();
		}
	}
	
	public static void insertInfo()
	{
		Connection conn=null;
		PreparedStatement pstmt=null;
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","xhp");
			String sql="insert into empinfo values(?,?,?,?,?)";
			pstmt=conn.prepareStatement(sql);
			pstmt.setString(1,EmpInfo[0]);
			pstmt.setString(2,EmpInfo[1]);
			pstmt.setString(3,EmpInfo[2]);
			pstmt.setString(4,EmpInfo[3]);
			pstmt.setString(5,EmpInfo[4]);
			int result=pstmt.executeUpdate();
			if(result==1)
				System.out.println("信息已经保存");
			else
				System.out.println("信息保存失败");
			conn.close();
			pstmt.close();
		}
		catch(ClassNotFoundException e)
		{
			e.printStackTrace();
		}
		catch(SQLException e)
		{
			System.out.println("信息保存失败");
			e.printStackTrace();
		}
		finally
		{
			try
			{
				if(conn!=null)
				{
					conn.close();
				}
				if(pstmt!=null)
				{
					pstmt.close();
				}
			}
			catch(SQLException ex)
			{
				ex.printStackTrace();
			}
		}
	}
	
	public static void showInfo()
	{
		{
			Connection conn=null;
			Statement stmt=null;
			ResultSet rs=null;
			try
			{
				Class.forName("com.mysql.jdbc.Driver");
				conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","xhp");
				stmt=conn.createStatement();
				String sql="select * from empinfo";
				rs=stmt.executeQuery(sql);//获得结果集的元数据
				ResultSetMetaData rsmd=rs.getMetaData();
				int columnsNum=rsmd.getColumnCount();
				System.out.print("Result:/n");
				System.out.print("no /t name /t gender /t age/t dept/n");
				while(rs.next())
				{
					for(int i=0;i<columnsNum;i++)
					{
						String data=rs.getString(i+1);
						System.out.print(data+"/t");
					}
					System.out.print("/n");
				}
				conn.close();
				stmt.close();
			}
			catch(ClassNotFoundException e)
			{
				e.printStackTrace();
			}
			catch(SQLException e)
			{
				e.printStackTrace();
			}
			finally
			{
				try
				{
					if(conn!=null)
					{
						conn.close();
					}
					if(stmt!=null)
					{
						stmt.close();
					}
				}
				catch(SQLException ex)
				{
					ex.printStackTrace();
				}
			}
		}
	}
	
	public static void main(String[] args) 
	{
//		getInfo();
//		insertInfo();
//		showInfo();
	}
}

使用参数列表实现数据的获取

运行结果：

C:/>javac MainDemo.java

C:/>java MainDemo

请输入员工号： a

请输入姓名： s

请输入性别： d

请输入年龄： f

请输入部门： g

信息已经保存

Result:

no name gender age dept

 1 2 3 4 5

0 9 8 7 k

2 3 4 5 6

s d f h j

a s d f g