Android接続MySQL
2318 ワード
public class MainActivity extends AppCompatActivity {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
new Thread(runnable).start();
}
Runnable runnable = new Runnable() {
private Connection con = null;
@Override
public void run() {
// TODO Auto-generated method stub
try {
Class.forName("com.mysql.jdbc.Driver");
// ,address IP,Port ,DBName ,UserName ,Password
con = DriverManager.getConnection("jdbc:mysql://192.168.1.202:3306/b2b", "root",
"123");
} catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println(e.getMessage());
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println(e.getMessage());
}
try {
insert("weishuyong", 12, con);
} catch (Exception e) {
}
}
};
private static void insert(String name, int age, Connection con) {
PreparedStatement pstmt;
try {
Statement st = con.createStatement();
String sql = "select * from alarm_plan_type where id = 1";
ResultSet res = st.executeQuery(sql);
if (res == null) {
} else {
List users = new ArrayList<>();
if(res.next()==false);
do{
User user = new User();
user.setSexy(res.getString("id"));
user.setName(res.getString("type"));
user.setId(res.getString("type_name"));
users.add(user);
Log.i("TAG", user.getId());
}while (res.next());
res.close();
st.close();
con.close();
}
} catch (Exception e) {
e.printStackTrace();
Log.d("TAG", " ");
}
}
}