eclipse 連接mysql資料庫的問題
package database;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.io.*;
import java.sql.*;
import javax.sql.DataSource;
public class Importdata{
private String sql = "insert into company_all(id,name,tel,address,category)values(?,?,?,?,?)";
private Connection con = null ;
private PreparedStatement ps = null ;
public Importdata()
{
try
{
con = getConnection();
ps = con.prepareStatement(sql);
java.io.File file = new java.io.File("c:/tools/原始.csv");
java.io.BufferedReader reader =
new java.io.BufferedReader(new FileReader(file));
String str = "";
while((str=reader.readLine())!=null)
{
System.out.println(str);
String arr[] = str.split(",");
for(int i = 0 ; i < 5 ; i ++)
{
ps.setString(i+1, arr[i]);
}
ps.executeUpdate();
}
DisConDB();
}catch(java.sql.SQLException ex )
{
System.out.println(ex);
}
catch(java.io.IOException ex )
{
System.out.println(ex);
}
}
public void DisConDB() throws java.sql.SQLException
{
if(ps!=null)
ps.close();
if(con!=null)
con.close();
ps = null;
con = null;
}
public static Connection getConnection () throws SQLException
{
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch(Exception e)
{
}
Connection con=java.sql.DriverManager.getConnection(
"jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=Big5","root","12345");
return con;
}
public static DataSource getPool()
{
mysql.jdbc.jdbc2.optional.MysqlDataSource ds = null;
{
ds = new mysql.jdbc.jdbc2.optional.MysqlDataSource();
ds.setServerName("127.0.0.1");
ds.setPortNumber(3306);
ds.setDatabaseName("test");
ds.setUser("root");
ds.setPassword("1234");
}
return ds;
}
public static void main(String args[])
{
new Importdata();
}
}
----------------------------------
新手第一次接觸android...
要連接Mysql(我用的是php)
上面程式碼都是網頁看來的..打完之後卻在mysql那邊出錯..
請問要如何更正錯誤?
