用于phpmyadmin中的连接的Java代码? [英] Java Code for connection in phpmyadmin?

问题描述

救救我..
您可以为《准则》提供帮助吗?
预先谢谢您...........

Help me..
Can you help for the Codes?
Thank you in advance...........

推荐答案

这是我的示例代码...
这并不意味着我给您这段代码，它就可以像这样
并非如此，您的项目必须具有一个将Java连接到mysql的jar文件.

This is my sample code...
It does''t mean that I give you this code and its going to work just like that
its not, your project must have a jar file that connects your java to mysql

<br />
<br />
package sample;<br />
<br />
<br />
<br />
import java.sql.Connection;<br />
<br />
import java.sql.Statement;<br />
<br />
import java.sql.DriverManager;<br />
<br />
import java.sql.ResultSet;<br />
<br />
import java.sql.ResultSetMetaData;<br />
<br />
import java.sql.SQLException;<br />
<br />
<br />
<br />
public class MySQLJDBCDriverTest {<br />
<br />
<br />
<br />
	public static void main(String args[])<br />
<br />
	{<br />
<br />
		Connection connection = null;<br />
<br />
		Statement statement = null;<br />
<br />
		ResultSet resultSet = null;<br />
<br />
		ResultSetMetaData metaData = null;<br />
<br />
		int numberOfColumns = 0;<br />
<br />
		try<br />
<br />
		{<br />
<br />
			Class.forName("com.mysql.jdbc.Driver");<br />
<br />
			connection = DriverManager.getConnection("jdbc:mysql://localhost/login" ,"root","");<br />
<br />
			statement = connection.createStatement();<br />
<br />
			System.out.println("Connection Established");<br />
<br />
			System.out.println("\nUsername Table");<br />
<br />
			resultSet = statement.executeQuery("SELECT * FROM username");<br />
<br />
			metaData = resultSet.getMetaData();<br />
<br />
			numberOfColumns = metaData.getColumnCount();<br />
<br />
			for(int i=1 ; i<=numberOfColumns ; i++)<br />
<br />
			{<br />
<br />
				System.out.printf("%-8s\t",metaData.getColumnName(i));<br />
<br />
			}<br />
<br />
			System.out.println();<br />
<br />
<br />
<br />
			while(resultSet.next())<br />
<br />
			{<br />
<br />
				for(int i=1 ; i<=numberOfColumns ; i++)<br />
<br />
				{<br />
<br />
					System.out.printf("%-8s\t",resultSet.getObject(i));<br />
<br />
				}<br />
<br />
				System.out.println();<br />
<br />
			}<br />
<br />
			System.out.println("\nPassword Table");<br />
<br />
			resultSet = statement.executeQuery("SELECT * FROM password");<br />
<br />
			metaData = resultSet.getMetaData();<br />
<br />
			numberOfColumns = metaData.getColumnCount();<br />
<br />
			for(int i=1 ; i<=numberOfColumns ; i++)<br />
<br />
			{<br />
<br />
				System.out.printf("%-8s\t",metaData.getColumnName(i));<br />
<br />
			}<br />
<br />
			System.out.println();<br />
<br />
<br />
<br />
			while(resultSet.next())<br />
<br />
			{<br />
<br />
				for(int i=1 ; i<=numberOfColumns ; i++)<br />
<br />
				{<br />
<br />
					System.out.printf("%-8s\t",resultSet.getObject(i));<br />
<br />
				}<br />
<br />
				System.out.println();<br />
<br />
			}<br />
<br />
		}<br />
<br />
		catch(SQLException sqlException)<br />
<br />
		{<br />
<br />
			sqlException.printStackTrace();<br />
<br />
			System.exit(1);<br />
<br />
		}<br />
<br />
		catch(ClassNotFoundException classNotFound)<br />
<br />
		{<br />
<br />
			classNotFound.printStackTrace();<br />
<br />
			System.exit(1);<br />
<br />
		}<br />
<br />
		finally {<br />
<br />
<br />
<br />
<br />
<br />
			try<br />
<br />
			{<br />
<br />
				statement.close();<br />
<br />
				connection.close();<br />
<br />
			}<br />
<br />
			catch(Exception exception)<br />
<br />
			{<br />
<br />
				exception.printStackTrace();<br />
<br />
				System.exit(1);<br />
<br />
			}<br />
<br />
		}<br />
<br />
	}<br />
<br />
}<br />
<br />

我们可以解决编码问题，但不能解决.

We help with coding problems, we don''t solve them.

这篇关于用于phpmyadmin中的连接的Java代码?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！