databaseconnection.java

来自「如何在eclipse 中进行数据库的 开发,这里使用的数据库是mysql.」· Java 代码 · 共 50 行

package mypackage;

import java.sql.*;

public class DatabaseConnection {

	public static void main(String [] args) 
	{
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost/mydatabase";
		String  user = "root";
		String password = "111111";
			
		
		try
		{
			Class.forName(driver);
			Connection con = DriverManager.getConnection(url,user,password);						
			String insert = "insert friends(id,name) values(?,?)";
			PreparedStatement prestatement = con.prepareStatement(insert);
		    String [] names = {"Rachel","Rose","Phoebe","Monica","Chandler","Joey"};
		    for(int i = 0;i < 6;i++ )
		    {
			prestatement.setInt(1,i);
			prestatement.setString(2,names[i]);
			prestatement.execute();
			}			
			
			String query = "select * from friends";
			ResultSet result = prestatement.executeQuery(query);
			
			System.out.println("The Results is:");
			while (result.next())
			{
				System.out.println(result.getString("name"));
			}
			con.close();
			
		}catch(SQLException e)
		{
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	
}